| A | B |
|---|
| Database | A collection of data organized in a manner that allows access, retrieval, and use of that data. |
| Database Management System | Software that allows you to use a computer to create a database |
| Relational database | Collection of tables, each of which contains information on a specific subject |
| Records | Contains information about a given person, product, or event. |
| Field | Contains a specific piece of information within a record |
| Unique identifier | A way of uniquely identifying each record in the database. |
| Primary Key | Unique Idetifyer |
| Access Work Area | Working on tables, forms, and reports here |
| Navigation Pane | Contains a list of all the objects in the database |
| Status Bar | Located at the bottom of the access window |
| Datasheet View | The table is represented as a collection of rows and columns a datasheet |
| Autonumber Field | Access will assign the value 1 to the first record |
| Data type | Data that can be stored in a field |
| Short Text | Field that can contain any characters |
| Number | Field that can contain only numbers |
| Currency | Contain monetary data |
| Date and Time | Contain date and time |
| Datasheet View | data in the table is presented in rows and columns, similar to a spreadsheet |
| Design View | Used to create a table or to modify the structure of a table |
| Caption | will display the value you assign |
| Import | Make a copy of the data as a table in the access database |
| List | Collection of rows and columnsin which all the entries in a column represent the same type of data |
| Column headings | Description of the content of athe column, rather than data |
| Queries | Questions |
| Run | To perform the necessary actions to produce and display the results in Datasheet view |
| Form View | Where data is displayed in a form on the screen |
| Form | formatted document with fields that contain data |
| Database Properties | details about a file |
| Metadata | Contain information as the projet author, title, or subject |
| Keywords | Words or phrases that further describe the database |
| Standard Properties | Associated with all Microsoft office documents and include author, title, and subject |
| Automatically updated properties | File system properties |
| recover | Retrieve the database |
| Backup | Backup database |
| Live database | live version of the backup copy |
| Database design | Determining the gtables and fields that make up the database |
| Redundancy | Storing the same fact in more than one place |
