| A | B |
|---|
| Auto Number | used to automatically assign a number to each record and to assist in preventing duplication of data. |
| Caption | a field property used for column naming that allows a more user-friendly and properly formatted field name than that stored in the database design |
| Currency | data type used to format numbers as decimal values with a dollar sign. |
| Database | a tool used to organize, store, retrieve, and communicate groups of related information that have similar characteristics |
| Data Type | defines the value of a cell |
| Date | data type used to arrange and sort data chronologically. This type often uses the input mask field property. |
| Decimal | field property used to format numbers for one or more decimal points. |
| Editing | procedures to add and delete records and fields, edit field names, and rearrange fields in a database. |
| Entry | a single piece of data in a database table, made up of characters and also known as data. |
| Field | a group or category of similar information contained in a table. One item or bit of information in a record; represented by a column. Comprised of entries |
| Field Property | field property defines the format of the data within the cell |
| Input Mask | a template-like field property that regulates how data is entered in a cell. |
| Lookup Wizard | a data type used to define preset values for database entries. |
| Memo | a data type used for lengthy entries that allows combinations of text and numbers. (64,000 characters) |
| Number Data Type | used for data that may be calculated, sorted, or filtered |
| Primary Key | used to format a record in a database as a unique entity; also refers to a field in a database table that is of the same data type and size as a related field in a linked table. |
| Record | A group of related fields of information in a table. Everything on one row. |
| Table | an arrangement of data in columns and rows. It is used to group and organize the information within a database. |
| Text Data Type | used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations |
| Time | data type used to arrange and sort data chronologically |
| Yes/No | a data type in toggle format that allows a user to select a yes or not value in a database cell. |
| Lookup Wizard | This feature increases productivity and accuracy by reducing the amount of data entry required. |
| Primary Key | It unlocks the relationship potential of a table by creating a unique link between tables. It allows database tables to communicate. |
| Table | It is the fundamental building block of all databases. |
