FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Essay

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can store a unique sequential number that Access assigns to the record.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

-In the accompanying figure,the small box or bar to the left of each field is called the ____.

A) row selector
B) field selector
C) field bar
D) current field bar

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

The Access window consists of a variety of components.These include the ____.

To change the print orientation from portrait to landscape,tap or click the ____ button on the PRINT PREVIEW tab.

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.

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

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.

To change the name of a field,press and hold or right-click the column heading for the field,tap or click ____ on the shortcut menu,and then type the desired field name.

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

To add a record to a table,tap or click the ____ record button.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can contain any characters and the total numbers of characters cannot exceed 255.

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

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

A field whose data type is ____ can contain any characters.

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

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

To undo the most recent change to a table structure,tap or click the ____ button on the Quick Access Toolbar.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -View that shows a report as it will appear when printed.