| A | B |
|---|
| Filters | Tool used to view only information in a specific category; Eliminate records not requested, returning only relevant information; This operation cannot be saved! |
| Delimited | Field type that separates records by line and uses a special character to separate fields |
| Limit Field Size | Used to ensure only two characters for state abbreviations |
| Field Properties | Area at the bottom of the database's "Design View" used to specify detailed information about the table's fields |
| Sort Descending | View that shows information from highest to lowest |
| Text | Data type for the Last Name or Address field in a database |
| Exporting | Process of transferring data from one database for use in another application |
| .pdf | Export command that doesn't allow editing |
| Hyperlink | Data type that allows the user to immediately open an employee's email from a database |
| Description | Notes to provide users so they can better understand and properly use the field names and types in a database |
| Memo | Field with 10,000 characters; used for longer data |
| Design View | Used to prepare a custom table |
| Delete Record | Option to choose when a name needs to be removed from a database; Select the record and choose "Delete" from the Home Ribbon |
| Auto Number | Allows Access to automatically assign an ID number to each record |
| Fixed | Field property used to format numbers in a database to two decimal places |
| Sort Ascending | Used to view first the lowest-valued data in the database |
| Find | Searches a database for specific data |
| Validation | Rules that must be followed when entering data into a database |
| Currency | Format that uses dollar signs and two decimal places; Used for financial information, bills, etc. |
| Freeze Fields | Allows the user to see some data constantly while scrolling through the remaining data. |
| One to Many | Relationship where a record in one table is related to, or matches, more than one record in another table |
| Edit Record | First step to take to change information in a database |
| Unique Identifier | The purpose of a primary key in a database |
| Primary Key | An exclusive way of identifying each record in a database |
| Structure | Defined when names and data types are assigned to all fields in a table |
| Lookup | Field that allows users to select options from a list |
