click below
click below
Normal Size Small Size show me how
Database Management
terms associated with database software or data management in spreadsheets
| Term | Definition |
|---|---|
| Field | a category of information |
| Record | a group of related fields |
| Database | organized data |
| Database file | related records in a database |
| Entry | data in a field |
| Table | hold fields and records |
| Queries | questions about the information |
| Sort | arrange data in a certain order such as alphabetical, numerical, or chronological |
| Criteria | specific information searched for |
| Ascending order | organize all data A-Z or 0-9; earliest data to latest data |
| Descending order | organize all data Z-A, 9-0; latest date to earliest data |
| search | use criteria to find only specific records in a database; filter data |
| Filter | use criteria to find only specific records in a database; search data |
| Operators | math symbols used in criteria; > greater than < less than = equal to >= greater than or equal to <= less than or equal to |
| Connectors | these words join conditions for a search AND OR NOT |