Question 1

_____ view is a spreadsheet-like view of the data in a table.

Accepted Answer

A)   Design
B)   Layout
C)   Form
D)   DatasheetE) A) and B)
F) None of the above

Question 2

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

Accepted Answer

A) True 
 B)False

Question 3

The programming language used in Access modules is called Visual Basic for _____.

Accepted Answer

A)   Access
B)   Modules
C)   Applications
D)   MacrosE) A) and B)
F) A) and C)

Question 4

Which of the following statements describe Query Design view? Select all the options that apply.

Accepted Answer

A)   Field lists appear in the upper pane of Query Design view.
B)   Query Design view shows the SQL code for the query.
C)   The query design grid provides a way to sort records.
D)   Query Design view lets you modify an existing query.E) A) and C)
F) A) and D)

Question 5

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

Accepted Answer

A) True 
 B)False

Question 6

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

Accepted Answer

A)   AND criteria
B)   row headings
C)   sort order
D)   parameter promptE) B) and D)
F) A) and C)

Question 7

You can use the arrow keys to move a selected control in Report Design view.

Accepted Answer

A) True 
 B)False

Question 8

You use a subdatasheet to modify a field's properties.

Accepted Answer

A) True 
 B)False

Question 9

To import data from Excel to Access, you would begin by clicking the ____.

Accepted Answer

A)   Edit Relationships button
B)   Property Sheet button
C)   Relationships tab
D)   External Data tabE) A) and B)
F) A) and C)

Question 10

When you remove a control layout from a report, Access _____.

Accepted Answer

A)   removes the controls from the report
B)   changes the arrangement of the controls
C)   displays an error message
D)   no longer groups the controls together in the reportE) A) and C)
F) None of the above

Question 11

You can display numbers on a report in Currency, Percent, or Standard formats.

Accepted Answer

A) True 
 B)False

Question 12

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

Accepted Answer

A) True 
 B)False

Question 13

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

Accepted Answer

A) True 
 B)False

Question 14

Number fields store values that represent quantities, measurements, and scores, for example.

Accepted Answer

A) True 
 B)False

Question 15

Press ESC to remove editing changes you made to the previous record.

Accepted Answer

A) True 
 B)False

Question 16

To set the Validation Text property for a table in Table Design view, you use the _____.

Accepted Answer

A)   Validation Text property for any field in the table
B)   Object dialog box
C)   Expression dialog box
D)   property sheet for the tableE) A) and D)
F) A) and C)

Question 17

To select more than one control in Form Design view, you _____ and then click each control.

Accepted Answer

A)   press and hold the ALT key
B)   press the ENTER key
C)   press the INSERT key
D)   press and hold the SHIFT keyE) All of the above
F) None of the above

Question 18

To display the data in a table, you open the table in Table Design view.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following are ways to improve database performance? Select all the options that apply.

Accepted Answer

A)   Compact the database regularly.
B)   Add more memory.
C)   Convert the database to an earlier format.
D)   Close other open applications you do not need.E) A) and D)
F) All of the above

Question 20

When you split an Access database, what do you call the database stored on your computer?

Accepted Answer

A)   Client-end database
B)   Object database
C)   Front-end database
D)   Table databaseE) A) and B)
F) A) and C)

Exam 8: Access

You can use the arrow keys to move a selected control in Report Design view.

Correct AnswerverifiedShow Answer

_____ view is a spreadsheet-like view of the data in a table.

Correct AnswerverifiedShow Answer

You can display numbers on a report in Currency, Percent, or Standard formats.

Correct AnswerverifiedShow Answer

To import data from Excel to Access, you would begin by clicking the ____.

Correct AnswerverifiedShow Answer

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

Correct AnswerverifiedShow Answer

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

Correct AnswerverifiedShow Answer

Which of the following are ways to improve database performance? Select all the options that apply.

Correct AnswerverifiedShow Answer

To select more than one control in Form Design view, you _____ and then click each control.

Correct AnswerverifiedShow Answer

Press ESC to remove editing changes you made to the previous record.

Correct AnswerverifiedShow Answer

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

Correct AnswerverifiedShow Answer

The programming language used in Access modules is called Visual Basic for _____.

Correct AnswerverifiedShow Answer

Number fields store values that represent quantities, measurements, and scores, for example.

Correct AnswerverifiedShow Answer

To display the data in a table, you open the table in Table Design view.

Correct AnswerverifiedShow Answer

When you split an Access database, what do you call the database stored on your computer?

Correct AnswerverifiedShow Answer

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

Correct AnswerverifiedShow Answer

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

Correct AnswerverifiedShow Answer

You use a subdatasheet to modify a field's properties.

Correct AnswerverifiedShow Answer

To set the Validation Text property for a table in Table Design view, you use the _____.

Correct AnswerverifiedShow Answer

When you remove a control layout from a report, Access _____.

Correct AnswerverifiedShow Answer

Which of the following statements describe Query Design view? Select all the options that apply.

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified