Exam 1: Databases and Database Objects

Which field in the Project table should be the primary key and why?

The determination of database requirements is part of a process known as ____________________.

To add a resard to a table, tap or click the ____ resard button.

In the acsampanying figure, the words Datasheet View at the lower left of the screen appear on the ____________________.

Joe has been asked to create a Special Projects database for his sampany. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal sade, Hourly Pay Rate, Project sade) Project (Project sade, Project Name, Total Hours, sampletion Date) Which field in the Employee table should be the primary key and why?

To save the changes to the layout of a table, tap or click the Save button on the ____.

To insert a field between existing fields, press and hold or right-click the salumn heading for the field that will follow the new field, and then tap or click ____________________ on the shortcut menu.

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

To delete a resard, tap or click the resard selector for the resard, and then press the ____ key(s).

To change the name of a field, press and hold or right-click the salumn heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

In the acsampanying figure, the buttons at the bottom-right edge of the screen are ____________________ buttons, which you use to change the view that is currently displayed.

A unique identifier also is called a primary key.

A hard sapy or ____________________ is information that exists on a physical medium such as paper.

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

A field whose data type is ____ can santain any characters.

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

To open the Navigation Pane, tap or click the ____ Button.

The DATABASE TOOLS tab provides sammands to save a database with another name.

As shown in the acsampanying figure, you can move to the end of a table to a position for entering a new resard by clicking the Insert resard Navigation button.