FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

To import data to a table,tap or click the ____ tab on the ribbon.

A) DATABASE TOOLS
B) FILE
C) EXTERNAL DATA
D) IMPORT

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition. -Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

A) AutoNumber
B) Layout view
C) DBDL
D) Report view
E) Long Text
F) Currency
G) Metadata
H) Print Preview
I) Short Text
J) status bar

K) E) and G)
L) A) and B)

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

In Access,field names cannot contain digits.

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

The ____________________ data type in Access is referred to as Money in SQL Server.

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

Landscape orientation means the printout is across the length (height)of the page.

____________________ view has more functionality for creating a table than Datasheet view.

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

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

-As shown in the accompanying figure,you can move to the first record in a table by clicking the Start record Navigation button.

To delete a record,tap or click the record selector for the record,and then press the ____ key(s) .

Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys,he needs to determine the data types for the fields in each table. -What data type should Joe use for the Completion Date field?

Identify the letter of the choice that best matches the phrase or definition. -View that shows a report as it will appear when printed.

To rename 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 maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Identify the letter of the choice that best matches the phrase or definition. -Can include such information as the file's author,title,or subject.

The rows in the tables are called ____________________.

Changing the column width in a datasheet changes the structure of a table.

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