Question 1

Match between columns
                        Premises: A commonly accepted shorthand representation for showing the structure of a relational database.

Accepted Answer

The Answer of Currency and Metadata and DBDL and Print is...

Question 2

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

Accepted Answer

The answer of ____________________ view has more functionality for creating...

Question 3

The Database Tools tab provides commands to compact and repair a database.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Can include such information as the file's author, title, or subject.

Accepted Answer

The Answer of Metadata and DBDL and Memo and Layout is...

Question 5

Match between columns
                        Premises: View that shows a report on the screen and does not allow changes to the report.

Accepted Answer

The Answer of Text and Layout view and Status bar is...

Question 6

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

Accepted Answer

A)  Add New
B)  New (blank) 
C)  Last
D)  Insert

Question 7

You can create a table in ____.

Accepted Answer

A)  Design view
B)  Blank view
C)  Datasheet view
D)  Layout view

Question 8

Match between columns
                        Premises: Field can contain only monetary data.

Accepted Answer

The Answer of AutoNumber and Currency and DBDL and Memo is...

Question 9

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

Accepted Answer

A)  Layout
B)  Report
C)  Report Layout
D)  Simple Report

Question 10

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 Add record Navigation button.

Accepted Answer

A) True 
 B)False

Question 11

To move a field, click the column heading for the field to be moved to select the field, and then ____________________ the field to the desired position.

Accepted Answer

The answer of To move a field, click the column...

Question 12

When Access first creates a database, it automatically creates a table.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  Cancel
B)  Escape
C)  Back
D)  Undo

Question 14

To view the results of a saved query, right-click the query in the Navigation Pane and click ____ on the shortcut menu.

Accepted Answer

A)  Open
B)  Datasheet View
C)  Results View
D)  Run

Question 15

Table names cannot contain _____.

Accepted Answer

A)  square brackets [ ]
B)  periods (.) 
C)  hyphens (-) 
D)  accent graves (')

Question 16

File names cannot contain a(n) ____.

Accepted Answer

A)  question mark (?) 
B)  colon (:) 
C)  space
D)  underscore (_)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A field with a Yes/No data type can store only one of two values.The choices are ____.

Accepted Answer

A)  False
B)  One/Zero
C)  Yes/No
D)  On/Off

Question 19

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

Accepted Answer

A)  Navigation Pane
B)  Content pane
C)  Ribbon
D)  Quick Access Toolbar

Question 20

To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

Accepted Answer

A)  Erase
B)  Trash
C)  Remove
D)  Delete

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

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

Correct Answer
verified

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

To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

Correct Answer
verified

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

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

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

Correct Answer
verified

A field with a Yes/No data type can store only one of two values.The choices are ____.

Correct Answer
verified

The Database Tools tab provides commands to compact and repair a database.

Correct Answer
verified

To move a field, click the column heading for the field to be moved to select the field, and then ____________________ the field to the desired position.

Correct Answer
verified

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

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 Add record Navigation button.

Correct Answer
verified

When Access first creates a database, it automatically creates a table.

Correct Answer
verified

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

Correct Answer
verified

To view the results of a saved query, right-click the query in the Navigation Pane and click ____ on the shortcut menu.

Correct Answer
verified

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

Correct Answer
verified

Table names cannot contain _____.

Correct Answer
verified

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

Correct Answer
verified

You can create a table in ____.

Correct Answer
verified

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

Correct Answer
verified

File names cannot contain a(n) ____.

Correct Answer
verified

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

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

Correct AnswerverifiedShow Answer

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

To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

A field with a Yes/No data type can store only one of two values.The choices are ____.

Correct AnswerverifiedShow Answer

The Database Tools tab provides commands to compact and repair a database.

Correct AnswerverifiedShow Answer

To move a field, click the column heading for the field to be moved to select the field, and then ____________________ the field to the desired position.

Correct AnswerverifiedShow Answer

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

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 Add record Navigation button.

Correct AnswerverifiedShow Answer

When Access first creates a database, it automatically creates a table.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To view the results of a saved query, right-click the query in the Navigation Pane and click ____ on the shortcut menu.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Table names cannot contain _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You can create a table in ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

File names cannot contain a(n) ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified