| A | B |
|---|
| 1. Database Management system | A DBMS allows you to store, retrieve, analyze, and print information. |
| Best fit | Another way of resizing a column is to change it to _____ _____, which automatically resizes the column to the best width for the data contained in the column. |
| Database | A collection of objects |
| Compacting | ___________ a database rearranges how the database is stored on the disk and optimizes the performance of the database. |
| Datasheet | In a ________, the table displays its data in rows and columns. |
| Record | A complete set of data. |
| Datasheet view | In _____ ______, the table displays its data in rows and columns in a datasheet. |
| Fields | Each record is made up of one or more_______. |
| Field name | To identify the fields, each field has a ______ ______ (column headings). |
| Field value | : The data entered into a field is called a ______ _______ |
| Record Selector | appears to the left of the first field for each record. |
| Field Selector | appears at the top of each column in a table and contains the field name. |
| Datasheet selector | You can also select all of the records and fields in a table by clicking the _______ ________ |
| AutoNumber | A field that automatically adds a unique number to the primary key field for each record in the table. For example – Product ID or your Student ID. |
| Data type | The kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text. |
| Design View | In this view, you can add, delete, and make changes to the way that fields store data. |
| An optional field property that you can use to describe what to enter in the field | An optional field property that you can use to describe what to enter in the field |
| Format property | Use the _____ ______ to specify how you want Access to display numbers, dates, times, and text. |
| Design grid | The field names and data types appear in the design grid in the top half of the Table window. |
| Field properties pane | The bottom half of the Table window that displays field properties |
| Field property | Describes a field’s contents beyond the field’s basic data type, such as indicating the number of characters the field can store. |
| Primary key | The field that contains a unique field value for each record in the table. |
| And operator | Selects records that match two or more conditions in a query. |
| Autofilter | A menu that contains options for sorting data and clearing any filters that you have already applied. |
| Condition | Another term for criterion; a way of telling the query which data you are interested in seeing. |
| Criterion | Another term for condition; a way of telling the query which data you are interested in seeing. |
| Expression | The calculation used in a calculated field. |
| Filter | Temporarily displays records in a datasheet based on the condition that you specify. |
| Filter by Selection | You select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab. A menu opens with a list of options for filtering the field. |
| Join line | After you add two related tables to the query design, a join line shows the relationship between the tables. The join line connects the common field used to relate the tables. |
| Matching field | A field that appears in both tables, has the same data type, and contains the same values. |
| Form | A database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form. |
| Form view | When a form is displayed in Form view, you will see each record in the record source in a form. |
| Form wizard | When you need to create a simple form quickly, you can use the Form Wizard, which helps you create a form by letting you select options in dialog boxes to specify the form’s record source, layout, and style |
| Layout view | View where you can view the controls in the form and data from the record source at the same time |
| Report | A database object that displays data from one or more tables or queries in a format that has an appearance similar to a printed report. |
| Grouping level | Organizes data based on one or more fields. |
