FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

A) Illustration
B) Image
C) Bitmap
D) OLE object

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

Each customer has one book rep, but each book rep can have many customers.This is an example of a one-to-many relationship.

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.

A field with the ____ data type can store a unique sequential number that Access assigns to a record.Access will increment the number by 1 as each new record is added.

____________________ refers to the process of determining the tables and fields that make up the database.

Identify the letter of the choice that best matches the phrase or definition.

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.

As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Insert record Navigation button.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

The Currency data type is used for fields that contain only monetary data.

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

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.

Identify the letter of the choice that best matches the phrase or definition.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Identify the letter of the choice that best matches the phrase or definition.

In the accompanying figure, ____________________ for the open objects appear at the top of the work area.

Identify the letter of the choice that best matches the phrase or definition.

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