Exam 6: Access_Module_1

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

Layout view shows a report on the screen and allows the user to make changes to the report.

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

To define an additional field in Datasheet view, tap or click the ____ column heading.

To import data to a table, tap or click the ____ tab on the ribbon.

To insert a field between existing fields, press and hold or right-click the column 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 contain any characters.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

The rows in the tables are called ____________________.

Landscape orientation means the printout is across the length (height) of the page.

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

To preview and then print the contents of a table, use Table Preview.

Form view displays a single record at a time.

Case 1-1 Joe has been asked to create a Special Projects database for his company. 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 Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) -Which field in the Project table should be the primary key and why?

The Navigation Pane contains a list of all the objects in the database.