| A | B |
|---|
| database management system | allows you to store, retrieve, analyze and print information |
| record | complete set of data, appearing as row |
| field | single characteristic in a table's design and appears as a column in a datasheet |
| field name | identifies a field in a database |
| design view | this view allows you to add, delete and make changes to way fields store data |
| datasheet view | form similar to a spreadsheet that allows you to enter records for a database |
| primary key | field in database table that contains value which uniquely identifies each record |
| field property | specifications that allow you to customize field beyond choosing data type |
| field selector | located at top of each column in table, contains field name |
| record selector | located to left of record's first field |
| best fit | automatically resizes the column to best width for data contained in columnn |
| compacting | rearranges how database is stored on disk and optimizes database performance |
| database | collection of objects |
| datasheet | table that displays its data in rows and columns |
| datasheet selector | allows you to select entire datasheet by clicking this button |
| navigation pane | this opens on left side of screen when you open database |
| field value | data entered into a field |
| alphanumeric data | data that is combination of numbers and text |
| autonumber | primary key sometimes automatically adds a unique number for each record |
| blank database template | creates database with empty table in it |
| data type | determines kind of data you can enter in field, such as numbers or text |
| default value property | enters same field value every time new record is added to table |
| description property | you can describe what to enter into field with this optional property |
| design grid | in Design view, field names and data types appear in the top half of the Table window |
| format property | used to specify how Access displays numbers, dates, times and text |
| required property | specifies whether you must enter a field value in a record |
| template | creates database and one or more table, query, form and report objects you use to enter and view data |
| field properties pane | bottom half of Table window that change depending on field's data type |
| field size property | sets number of characters you can store in a field |
