| A | B |
|---|
| Table | an arrangement of columns and rows. It is the fundamental building block of all databases. |
| Entry | a single piece of data in a database table. |
| Field | a grouping or category of similar information contained in a table; a unique identifier for a category of information |
| Record | a complete description of all of the fields related to one item in a table. |
| 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. |
| Date/time | data type used to arrange and sort data chronologically, often used with the input mask field property |
| 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. |
| Yes/No | a data type in toggle format that allows a user to select a yes or no value in a database cell. The default setting is No. |
| 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 properties | used to control how data is entered in a field |
| 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 |
| Editing and Printing | Procedures to add and delete records and fields, edit field names, rearrange fields in a database and print. |
