Question 1

After Update is a typical event for a table macro.
​
​
​

Accepted Answer

A) True 
 B)False

Question 2

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

Accepted Answer

A) True 
 B)False

Question 3

To create a report in Report Layout view, click the Blank Report button on the Create tab.

Accepted Answer

A) True 
 B)False

Question 4

When you display the Visual Basic window, one line is highlighted in yellow.What does that mean?

Accepted Answer

A)   The code cannot run successfully.
B)   The yellow line will change data when you run the code.
C)   A new section of the code starts after the yellow line.
D)   An error has been corrected automatically.

Question 5

To allow users to enter more than one value in a field, you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

Accepted Answer

A)   General tab
B)   Lookup tab
C)   Description column
D)   Data Type column

Question 6

An Append query adds selected records to an existing table.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following tasks is a good candidate for a macro?

Accepted Answer

A)   Modifying the design of a form
B)   Printing several reports
C)   Creating a report
D)   Adding a chart to a tab control

Question 8

When you select a control in Form Design view and then press an arrow key, you _____ the control.

Accepted Answer

A)   resize
B)   anchor
C)   move
D)   lock

Question 9

Which control would you add to a report to allow users to enter or select an option from a list?

Accepted Answer

A)   Text box
B)   Option group
C)   Attachment
D)   Combo box

Question 10

Which of the following controls can you add to a form to clarify or organize form data? Select all the options that apply.

Accepted Answer

A)   line
B)   text box
C)   rectangle
D)   label

Question 11

To link the data from one table to another in an Access relational database, a(n)  ____ must be common to each table.

Accepted Answer

A)   field
B)   record
C)   data type
D)   property

Question 12

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Accepted Answer

A)   Import the data into a new table.
B)   Append the data to an existing table.
C)   Link to the workbook by creating a linked table.
D)   Import the data into a new report.

Question 13

Before you close a database, you must save any changes you made to the data.

Accepted Answer

A) True 
 B)False

Question 14

In Table Design view, you create a lookup list of values you enter using the _____ Lookup property of a field.

Accepted Answer

A)   Limit to List
B)   Allow Multiple Values
C)   Field Size
D)   Row Source

Question 15

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 prompt

Question 16

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.

Question 17

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

Accepted Answer

A)   5
B)   None
C)   25%
D)   All

Question 18

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.

Accepted Answer

A)   OrderDate
B)   Gender
C)   State
D)   Department

Question 19

What Access tool can you use to enter dates in a Date/Time field?

Accepted Answer

A)   Date Box
B)   Calendar Picker
C)   Property Sheet
D)   Lookup Wizard

Question 20

Which of the following is the fastest way to open an Access database?

Accepted Answer

A)   Start Access from the Start menu.
B)   Double-click the database icon.
C)   Start Access, and then create a new database.
D)   Right-click the database icon.

Exam 9: Access

To allow users to enter more than one value in a field, you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

Correct AnswerverifiedShow Answer

Which of the following tasks is a good candidate for a macro?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which control would you add to a report to allow users to enter or select an option from a list?

Correct AnswerverifiedShow Answer

When you select a control in Form Design view and then press an arrow key, you _____ the control.

Correct AnswerverifiedShow Answer

An Append query adds selected records to an existing table.

Correct AnswerverifiedShow Answer

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

Correct AnswerverifiedShow Answer

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following controls can you add to a form to clarify or organize form data? Select all the options that apply.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is the fastest way to open an Access database?

Correct AnswerverifiedShow Answer

When you display the Visual Basic window, one line is highlighted in yellow.What does that mean?

Correct AnswerverifiedShow Answer

Before you close a database, you must save any changes you made to the data.

Correct AnswerverifiedShow Answer

In Table Design view, you create a lookup list of values you enter using the _____ Lookup property of a field.

Correct AnswerverifiedShow Answer

What can you do with the data that you import from an Excel workbook into Access? Select all the options that apply.

Correct AnswerverifiedShow Answer

To create a report in Report Layout view, click the Blank Report button on the Create tab.

Correct AnswerverifiedShow Answer

After Update is a typical event for a table macro. ​ ​ ​

Correct AnswerverifiedShow Answer

What Access tool can you use to enter dates in a Date/Time field?

Correct AnswerverifiedShow Answer

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

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

After Update is a typical event for a table macro.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified