A | B |
ascending | A sort order whereby items with a lower value are placed before items with a higher value |
comparison operators | Symbols used in search criteria (> |
connectors | Words such as AND |
currency | Numeric data type which adds a $ sign to a number |
database | A large collection of data organized for quick retrieval. |
database designer | A person who collects and organizes a large amount of data for quick retrieval. |
database management system | Software that allows the computer to create a database; add |
date data | Entries in a database that are formatted in date style; can be sorted chronologically |
descending | A sort order whereby items with a higher value are placed before items with a lower value |
entry | Data that is keyed into a field |
field | Category of information in a database – combine to form a record. |
file | A group of related records |
filter/query/search | Method to find specific dat within a database that meets certain criteria; filter is one time; query can be saved and reused |
form | A window used to display |
numeric data | Entries in a database that are formatted for numbers and can be used in a calculation |
object | In Microsoft Access |
primary key | A unique identifier that makes sure records are never confused or duplicated |
primary sort | The first field that a database is sorted on |
record | A group of associated fields that store information about a single item in a database. |
sorting | A method of organizing data based on one or more criterion |
table | A storage container in a database that holds related information and can be managed independently of the rest of the database. – building block of all databases |
text data | Entries in a database that represent text |
wizard | A Microsoft Office application tool that walks users through a process step by step. |