Exam 3: Access: Creating and Using a Database

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of ____________________.

____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.

Figure 1-3 In the accompanying figure, the entire area that displays on the screen is called the ____________________ work area.

A unique identifier also is called a primary key.

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

To back up a database, use the ____ command on the Office Button menu.

Figure 1-1 As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Insert Record Navigation button.

In Access, a(n)____ consists of a collection of tables, each of which contains information on a specific subject.

To use a template to create a table, click Create on the Ribbon and then click the Table Wizards button on the Create tab.

Table names can be from 1 to ____________________ characters in length and can contain letters, digits, and spaces.

To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.

To create a new database, use either the Blank Database option or a template.

What data type should Mary use for the Social Security Number field? Why?

In ____________________ , the table is represented as a collection of rows and columns called a datasheet.

The rows in the tables are called ____________________.