Exam 3: Access: Creating and Using a Database

To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.

The term database management system describes a collection of data organized in a manner that allows access, retrieval, and use of that data.

You only can delete a primary key in ____ view.

A(n)___ combines both a datasheet and a form.

Access is a ____.

Discuss the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

Form view displays a single record at a time.

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

To delete a field, right-click the column heading for the field, and then click Delete Column on the shortcut menu.

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

____________________ is a feature that allows you to point to a gallery choice and see its effect in the database object - without actually selecting the choice.

Figure 1-2 In the accompanying figure, you would save the changes to the structure of the table by clicking the Save button on the ____.

File names can be a maximum of 260 characters including the file extension.

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

The URL Address data type can store text that can be used as a hyperlink address.

In Access, table and field names can be up to ____ characters in length.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Text.

The maximum number of characters allowed in a field whose data type is Text is 1024.

In Access, the columns in a table are called records.

Figure 1-2 In the accompanying figure, the key symbol that appears in the row selector for the Client Number field indicates that Client Number is the ____ for the table.