Exam 15: Access: Databases and Database Objects: an Introduction

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

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

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 Employee table should be the primary key and why?

To open a table in Design view,press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu

-In the accompanying figure,the ____________________ Pane contains a list of all the objects in the database.

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

The term list database describes a database that consists of a collection of tables,each of which contains information on a specific subject.____________________

Identify the letter of the choice that best matches the phrase or definition. -Field can contain any characters and the total numbers of characters cannot exceed 255.

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.

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?