| Term | Definition |
|
Ascending |
Sorting data in alphabetical order from A-Z or numerical order from 0-9. |
|
Comparison Operators |
Symbols used in search criteria. (>, <, =, >=, <=, <>) |
|
Connectors |
Words such as AND, OR and NOT that join certain conditions together when performing a search. |
|
Currency |
A numeric type which add a $ sign to number. |
|
Database |
An organized collection of information. |
|
Database Management System |
Software that allows the computer to create a database; add, change, and delete data in the database; sort the data; retrieve the data; and create forms and reports using the data in the database. |
|
Date data |
Entries in a database that are formatted for data in a particular style. (i.e. 04/15/03 or April 16, 2003) |
|
Descending |
Sorting data the opposite of ascending order. (Z-A & 9-0) |
|
Entry |
Data that is keyed into a field. |
|
Field |
A category of information in a database. |
|
File |
A group of related records. |
|
Filter/Query/Search |
A method to find specific data within a database that meets certain criteria. |
|
Form view |
A method of viewing or inputting data that displays only one record at a time. |
|
List view |
A method of viewing or inputting data that displays several records at a time. |
|
Numeric data |
Entries in a database that are formatted for numbers and can be used in a calculation. |
|
Primary key |
The field selected as a unique identifier for the database. |
|
Primary sort |
The first field that a database is sorted on. |
|
Record |
A group of fields related to one topic. |
|
Sort |
To arrange data in alphabetical or numerical order. |
|
Text data |
Entries in a database that represent text; such as, phone numbers, names, colors. |