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 |