Exam 3: Access: Creating and Using a Database

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

On the Ribbon, the ____________________ tab, called the primary tab, contains the more frequently used commands.

When you create a new database, the name of the database appears on the ____ bar.

Figure 1-3 In the accompanying figure, the ____________________ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted.

Figure 1-3 In the accompanying figure, ____________________ for the open objects appear at the top of the work area.

The Tools submenu on the Office menu provides commands to compact and repair a database.

A(n)____________________ is a software tool that can be used to create a database; add, change, and delete data in the database; sort and retrieve data; and create forms and reports using the data in the database.

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

Figure 1-1 As shown in the accompanying figure, you can move to the first record in a table by clicking the First record Navigation button.

A(n)____ contains information about a given person, product, or event.

A(n)____________________ contains a specific piece of information within a record.

Figure 1-4 In the accompanying figure, recruiter names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

A unique identifier also is called a(n)____________________.

The ____________________ feature of Access corrects common mistakes when you complete a text entry in a cell.

In Access, table names can be up to 128 characters in length.

To insert a field as the last field in a table, right-click the Add New Field column heading, click ____ on the shortcut menu, type the desired field name, click the down arrow, and then ensure the correct data type is already selected.

Figure 1-1 As shown in the accompanying figure, you can use the Last record button to move to the last record in the table.