| A | B |
|---|
| Database | An organized collection of facts about a particular subject or group that allows you to access, retrieve, and use the data electronically |
| Record | The rows in a table with individual information |
| Field | Contains a specific piece of information within a record; a column on a table |
| Filter | To have only the record or records that satisfy the criterion appear |
| Sort | To put in ascending or descending order |
| Table | An object in a database with information arranged in columns and rows |
| Query | A question presented in a way that Access can process |
| Report | Displays information retrieved from the database in a specific format |
| ACCESS | One type of database software |
| Datasheet View | Displays the table in a column and row format, similar to a spreadsheet grid |
| Design View | Create and modify the field names and field properties in this view |
| Text | The "data type" default in table design view |
| Form | A database object that displays one record at a time |
| Primary Key | Also called a "unique identifier"; an entry on a record that is unique to that record |
| Data Type | Indicates the type of data that can be stored in a field - i.e. text, currency, number, yes/no box |
| Parameter Query | Prompts for input whenever it is used - i.e. keying in name of city before receiving correct info in query |
| Wildcards | Symbols that represent any character or combination of characters in a filter |
| Question Mark | Wildcard symbol that represents any "individual" character |
| Asterisk | Wildcard symbol that represents any "collection" of characters |
| Criterion | A condition that the records to be included in a query must satisfy |
| .accdb | The file extension for Access 2007 |
| Filter by Selection | The simplest type of filter |
| Lookup Field | Allows the user to select from a list of values |
| Multivalued Fields | Fields that contain more than one value |
| Navigation Pane | Shows objects that have been created in the database |
