| A | B |
|---|
| Access | The database software of the Microsoft Office Suite |
| database | A collection of objects that work together to store, retrieve, display, & summarize data |
| DBMS | Database Management System |
| table | stored in a format called a datasheet |
| query | use to search for and retrieve data from tables using conditions |
| form | displays data from tables/queries similar to a paper form |
| report | displays data in a format that is customized on-screen |
| macro | Automates database operations |
| module | Similar to a macro; more complex |
| record | complete set of data |
| field | Single characteristic within a record |
| field name | name of a columns/field |
| field value | data entered into a field |
| datasheet view | displays data in rows and columns |
| design view | view that allows you to add, delete, and rearrange fields |
| field selector | appears at top of column/allows you to select entire field column |
| record selector | appears at left of the first field/allows you to select entire record |
| datasheet selector | box in upper-left corner of a datasheet/select all records and all fields |
| primary key | field that contains a unique field for each record |
| autonumber | automatically adds a unique number to the primary key field |
| data type | determines the kind of data that you can enter in the field |
| alphanumberic data | combination of numbers and text |
| accdb | Access 2007 file extension |
| design grid | top half of the Table Window in Design View |
| field property | describes a field's content beyond the field's basic data type |
