Question 1

As with other action queries, the icon for an Append query includes a(n)  _____ to remind you that it changes data when you run the query.

Accepted Answer

A)   question mark
B)   red asterisk
C)   exclamation point
D)   red XE) A) and D)
F) None of the above

Question 2

Tables, queries, and forms are examples of Access ____.

Accepted Answer

A)   values
B)   objects
C)   fields
D)   controlsE) B) and C)
F) A) and C)

Question 3

To delete a field in Table Datasheet view, you click _____.

Accepted Answer

A)   any value in the field
B)   the first value in the column
C)   the record selector for any record
D)   the column heading for the fieldE) A) and B)
F) All of the above

Question 4

To add a report to a Navigation form, change the report's Display property to Navigation.

Accepted Answer

A) True 
 B)False

Question 5

One way to group objects in the Navigation Pane is by object type.

Accepted Answer

A) True 
 B)False

Question 6

When you single step a macro, you _____.

Accepted Answer

A)   create the macro with one action
B)   run the macro one action at a time
C)   record the macro as you perform steps
D)   add an action with only one argumentE) C) and D)
F) None of the above

Question 7

How is the font set for a table in Table Datasheet view?

Accepted Answer

A)   Access controls the font automatically.
B)   You use the Format box on the Table Tools Design tab.
C)   Access prompts you for the font when you create the table.
D)   You use the Font box on the Home tab.E) A) and B)
F) A) and C)

Question 8

In a datasheet, what do you click to select a record for deletion?

Accepted Answer

A)   column heading
B)   field in the record
C)   record deletion button
D)   record selector buttonE) A) and D)
F) None of the above

Question 9

A mail merge combines data from an Access table or form into a Word form letter.

Accepted Answer

A) True 
 B)False

Question 10

Drag a form to the [Add New] button to display the form in a Navigation form.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.

Accepted Answer

A)   Currency
B)   Long Integer
C)   Byte
D)   SingleE) All of the above
F) C) and D)

Question 12

Which data type stores web addresses?

Accepted Answer

A)   Web
B)   URL
C)   HTML
D)   HyperlinkE) All of the above
F) C) and D)

Question 13

To resize a control in Report Layout view, you format an edge of the selected control.

Accepted Answer

A) True 
 B)False

Question 14

You can view the SQL code for any query by switching to _____ view.

Accepted Answer

A)   Code
B)   Design
C)   SQL
D)   LayoutE) C) and D)
F) None of the above

Question 15

To create a filter using the _____ feature, you work in a view similar to Query Design view.

Accepted Answer

A)   Filter By Selection
B)   Filter by Form
C)   Advanced Filter
D)   ComparisonE) A) and C)
F) A) and D)

Question 16

To create an Update query in Query Design view, you use the Add to row in the query design grid.

Accepted Answer

A) True 
 B)False

Question 17

You use _____ to document and explain the statements in VBA code.

Accepted Answer

A)   comments
B)   keywords
C)   breakpoints
D)   event proceduresE) B) and C)
F) A) and B)

Question 18

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

Accepted Answer

A)   Date
B)   Format
C)   Data Type
D)   Field SizeE) C) and D)
F) B) and D)

Question 19

What should you do before applying a new filter to a datasheet?

Accepted Answer

A)   Switch to Query Design view.
B)   Change the sort order of the records.
C)   Save the previous filters.
D)   Clear all previous filters.E) B) and C)
F) All of the above

Question 20

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

Accepted Answer

A) True 
 B)False

Exam 9: Access

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

Correct AnswerverifiedShow Answer

You use _____ to document and explain the statements in VBA code.

Correct AnswerverifiedShow Answer

To resize a control in Report Layout view, you format an edge of the selected control.

Correct AnswerverifiedShow Answer

To create an Update query in Query Design view, you use the Add to row in the query design grid.

Correct AnswerverifiedShow Answer

One way to group objects in the Navigation Pane is by object type.

Correct AnswerverifiedShow Answer

When you single step a macro, you _____.

Correct AnswerverifiedShow Answer

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

Correct AnswerverifiedShow Answer

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

Correct AnswerverifiedShow Answer

How is the font set for a table in Table Datasheet view?

Correct AnswerverifiedShow Answer

To add a report to a Navigation form, change the report's Display property to Navigation.

Correct AnswerverifiedShow Answer

To delete a field in Table Datasheet view, you click _____.

Correct AnswerverifiedShow Answer

In a datasheet, what do you click to select a record for deletion?

Correct AnswerverifiedShow Answer

Tables, queries, and forms are examples of Access ____.

Correct AnswerverifiedShow Answer

Which data type stores web addresses?

Correct AnswerverifiedShow Answer

Drag a form to the [Add New] button to display the form in a Navigation form.

Correct AnswerverifiedShow Answer

What should you do before applying a new filter to a datasheet?

Correct AnswerverifiedShow Answer

To create a filter using the _____ feature, you work in a view similar to Query Design view.

Correct AnswerverifiedShow Answer

You can view the SQL code for any query by switching to _____ view.

Correct AnswerverifiedShow Answer

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.

Correct AnswerverifiedShow Answer

A mail merge combines data from an Access table or form into a Word form letter.

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