FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Access: Creating and Using a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Insert
B) New Object
C) Create
D) Report

E) A) and C)
F) B) and C)

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

You only can delete a primary key in ____ view.

A) Datasheet
B) Layout
C) Print Preview
D) Design

E) None of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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.

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

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

____________________ 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.

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

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

Access is a ____.

Form view displays a single record at a time.

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 ____.

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

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.

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

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

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

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

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

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