Question 1

Where do you specify the number of columns for a report?

Accepted Answer

A)   Print Preview toolbar
B)   Form Design property sheet
C)   Page Setup dialog box
D)   Page Layout tabE) A) and B)
F) All of the above

Question 2

Which of the following are ways to run a query? Select all the options that apply.

Accepted Answer

A)   Right-click a query in the Navigation Pane, and then click Run.
B)   Double-click the query in the Navigation Pane.
C)   Click the Run button in Query Design view.
D)   Click the View button in Query Design view.E) None of the above
F) All of the above B, C, D

Question 3

To change the background color of a form control in Form Design view, you use the _____ button.

Accepted Answer

A)   Shape Outline
B)   Shape Fill
C)   Row Color
D)   Form ColorE) All of the above
F) None of the above

Question 4

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

Accepted Answer

A) True 
 B)False

Question 5

Besides reducing file size, what other benefit does compacting an Access database provide?

Accepted Answer

A)   sorting the records in the database
B)   repairing the database
C)   saving the database
D)   relating tables in the databaseE) C) and D)
F) None of the above B

Question 6

When you convert a macro, you break it down, step by step, to observe the effect of each action.
​

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements are true about field properties? Select all the options that apply.

Accepted Answer

A)   Modifying the properties helps ensure database accuracy.
B)   Some properties are required, and some are optional.
C)   The properties are the same for each data type.
D)   The properties can be used to change the way data is displayed.E) None of the above
F) B) and D)

Question 8

A self join relates a record of a table to _____.

Accepted Answer

A)   another record in the same table
B)   an identical record in another table
C)   a matching record in another database
D)   a record with one or more blank field valuesE) A) and B)
F) None of the above

Question 9

Which of the following types of tables can you create from an Application Part? Select all the options that apply.

Accepted Answer

A)   blank table
B)   contacts table
C)   tasks table
D)   issues tableE) None of the above
F) A) and D)

Question 10

Which of the following are examples of correct criteria syntax? Select all the options that apply.

Accepted Answer

A)   
B)   >= #1/1/2021#
C)   
D)   <= 33.50E) B) and C)
F) A) and D)

Question 11

How do you display the results of a query listed in the Navigation Pane?

Accepted Answer

A)   Right-click the query, and then click Design View on the shortcut menu.
B)   Right-click the query, and then click Run on the shortcut menu.
C)   Double-click the query.
D)   Click the query, and then click the Open button in the Navigation Pane.E) B) and D)
F) None of the above

Question 12

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.

Accepted Answer

A)   hide the Navigation Pane itself
B)   change the Navigation Options to show hidden objects
C)   restart Access
D)   open the Property Sheet for the Navigation PaneE) B) and C)
F) A) and D)

Question 13

_____ is the default name for a new table in an Access database.

Accepted Answer

A)   Table1
B)   NewTable
C)   Table
D)   TableAE) None of the above
F) B) and C)

Question 14

Which of the following is a startup command-line option?

Accepted Answer

A)   /repair
B)   /excl
C)   /open.
D)   /openE) A) and B)
F) None of the above

Question 15

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

Accepted Answer

A)   Top/Left
B)   Detail
C)   Custom Order
D)   Auto OrderE) B) and D)
F) None of the above

Question 16

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

Accepted Answer

A) True 
 B)False

Question 17

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

Accepted Answer

A) True 
 B)False

Question 18

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

Accepted Answer

A)   Unique
B)   Indexed
C)   Default Value
D)   RequiredE) C) and D)
F) B) and C)

Question 19

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply. ​

Accepted Answer

A)   right outer
B)   left outer
C)   inner
D)   upperE) A) and B)
F) All of the above A, C

Question 20

A(n)  _____ is an individual step that a macro performs.

Accepted Answer

A)   action
B)   argument
C)   property
D)   flowE) A) and C)
F) B) and C)

Exam 9: Access

Where do you specify the number of columns for a report?

Correct AnswerverifiedShow Answer

Which of the following are ways to run a query? Select all the options that apply.

Correct AnswerverifiedB, C, D

To change the background color of a form control in Form Design view, you use the _____ button.

Correct AnswerverifiedShow Answer

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

Correct AnswerverifiedShow Answer

Besides reducing file size, what other benefit does compacting an Access database provide?

Correct AnswerverifiedB

When you convert a macro, you break it down, step by step, to observe the effect of each action. ​

Correct AnswerverifiedShow Answer

Which of the following statements are true about field properties? Select all the options that apply.

Correct AnswerverifiedShow Answer

A self join relates a record of a table to _____.

Correct AnswerverifiedShow Answer

Which of the following types of tables can you create from an Application Part? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following are examples of correct criteria syntax? Select all the options that apply.

Correct AnswerverifiedShow Answer

How do you display the results of a query listed in the Navigation Pane?

Correct AnswerverifiedShow Answer

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.

Correct AnswerverifiedShow Answer

_____ is the default name for a new table in an Access database.

Correct AnswerverifiedShow Answer

Which of the following is a startup command-line option?

Correct AnswerverifiedShow Answer

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

Correct AnswerverifiedShow Answer

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

Correct AnswerverifiedShow Answer

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

Correct AnswerverifiedShow Answer

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

Correct AnswerverifiedShow Answer

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply. ​

Correct AnswerverifiedA, C

A(n) _____ is an individual step that a macro performs.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
B, C, D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

When you convert a macro, you break it down, step by step, to observe the effect of each action.

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

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

Correct Answer
verified
A, C

Correct Answer
verified