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

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

In the accompanying figure, the database name, Bavant Publishing appears on the ____________________.

Critical Thinking Questions 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?

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

In the accompanying figure, the Book Rep table displays in ____.

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

One way to undo changes to a field is to click the Undo button on the status bar.

Modified Multiple Choice A field with a Yes/No data type can store only one of two values.The choices are ____.

To exit Access, tap or click the ____ button on the right side of the title bar.

A unique identifier also is called a primary key.

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

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

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

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

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

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

The Short Text data type replaces the ____________________ data type in previous editions of Access.

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

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

Redundancy means storing the same fact in more than one place.