| A | B |
|---|
| database | a tool for organizing, storing, retrieving, and communicating groups of information that have similar characteristics |
| tables | store data in rows and columns |
| queries | retrieve and process data |
| forms | control data entry and data views |
| reports | summarize and print data |
| records | Tables contain Rows called _________ |
| fields | Tables contain Columns called |
| data type | defines the value of a cell |
| field property | defines the format of the data within the cell |
| text | used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations |
| memo | a data type used for lengthy entries that allows combinations of text and numbers |
| number | used for data that may be calculated, sorted, or filtered. |
| currency | data type used to format numbers as decimal values with a dollar sign. The default format for currency is two decimal places. |
| auto number | used to automatically assign a number to each record and to assist in preventing duplication of data |
| lookup wizard | a data type used to define preset values for database entries. This feature increases productivity and accuracy by reducing the amount of data entry required |
| field size | used to control the size of the field, measured in characters |
| format | used to control the layout of the field, such as one or two decimal places |
| input mask | a template-like field property that regulates how data is entered in a cell. For example, if the phone number input mask is used, the user will be prompted to input data in a specific format, such as (919) 555-5555 |
| caption | a field property used for column naming that allows a more user-friendly and properly formatted field name than the field name stored in the database design |
