Question 1

When you import Excel data into an existing Access table, you relate the data to the table.

Accepted Answer

A) True 
 B)False

Question 2

Each page of a(n)  _____ control is a container for other controls, such as text boxes or command buttons.

Accepted Answer

A)   attachment
B)   tab
C)   option group
D)   combo box

Question 3

What criterion would you use to find numbers greater than or equal to 100?

Accepted Answer

A)   
B)   100
C)   >+100
D)   >=100

Question 4

In a calculated control, expressions must start with what character?

Accepted Answer

A)   : colon
B)   [ left square bracket
C)   ( left parenthesis
D)   '= equal sign

Question 5

Which of the following are errors that prevent VBA code from running successfully? Select all the options that apply.

Accepted Answer

A)   Mistyping the word function
B)   Using too many comments
C)   Forgetting an End If statement
D)   Dividing by zero

Question 6

To close an Access module, you must close the Visual Basic Editor.

Accepted Answer

A) True 
 B)False

Question 7

Which tab contains options for aligning the text in a report control?

Accepted Answer

A)   Home
B)   Arrange
C)   Format
D)   Page Setup

Question 8

The easiest way to filter the records for an exact match is to use the _____ feature.

Accepted Answer

A)   Filter By Form
B)   Advanced Filter
C)   Find and Replace
D)   Filter By Selection

Question 9

A(n)  _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

Accepted Answer

A)   index
B)   blank string
C)   validation text
D)   zero-length string

Question 10

To back up a database, you use the _____ command.

Accepted Answer

A)   Make a Backup
B)   Back Up Database
C)   Package and Sign
D)   Compact & Repair

Question 11

Which of the following report controls can you format in bold?

Accepted Answer

A)   Line
B)   Label
C)   Check box
D)   Rectangle

Question 12

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following are Size options you can apply to selected controls? Select all the options that apply.

Accepted Answer

A)   To Default
B)   To Fit
C)   To Tallest
D)   To Widest

Question 14

What data type is most appropriate for a field named PaymentAmt?

Accepted Answer

A)   Number
B)   Currency
C)   AutoNumber
D)   Input Mask

Question 15

To change the text displayed on the report tab, use the report's Caption property.

Accepted Answer

A) True 
 B)False

Question 16

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 17

In which object can you rename a field?

Accepted Answer

A)   form
B)   macro
C)   report
D)   table

Question 18

If you select a(n)  _____ control on a form in Form view, it means "yes" or "true".

Accepted Answer

A)   check box
B)   option button
C)   command button
D)   option group

Question 19

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

Accepted Answer

A)   You can change the orientation of the report to landscape.
B)   You can change the theme colors in the report.
C)   You can switch to Report view.
D)   You can change the report to a different type of object.

Question 20

When you select a control in Form Design view, you can use _____ to resize the control.

Accepted Answer

A)   arrow keys
B)   conditional sizing
C)   resizing handles
D)   smart guides

Exam 8: Access

Which of the following are errors that prevent VBA code from running successfully? Select all the options that apply.

Correct AnswerverifiedShow Answer

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

Correct AnswerverifiedShow Answer

The easiest way to filter the records for an exact match is to use the _____ feature.

Correct AnswerverifiedShow Answer

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

Correct AnswerverifiedShow Answer

To display field values as Currency or Percent values, use the Data Type box in Table Datasheet view.

Correct AnswerverifiedShow Answer

Which of the following are Size options you can apply to selected controls? Select all the options that apply.

Correct AnswerverifiedShow Answer

To close an Access module, you must close the Visual Basic Editor.

Correct AnswerverifiedShow Answer

What criterion would you use to find numbers greater than or equal to 100?

Correct AnswerverifiedShow Answer

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

Correct AnswerverifiedShow Answer

To change the text displayed on the report tab, use the report's Caption property.

Correct AnswerverifiedShow Answer

What data type is most appropriate for a field named PaymentAmt?

Correct AnswerverifiedShow Answer

When you select a control in Form Design view, you can use _____ to resize the control.

Correct AnswerverifiedShow Answer

Which tab contains options for aligning the text in a report control?

Correct AnswerverifiedShow Answer

Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.

Correct AnswerverifiedShow Answer

In which object can you rename a field?

Correct AnswerverifiedShow Answer

When you import Excel data into an existing Access table, you relate the data to the table.

Correct AnswerverifiedShow Answer

Which of the following report controls can you format in bold?

Correct AnswerverifiedShow Answer

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

Correct AnswerverifiedShow Answer

To back up a database, you use the _____ command.

Correct AnswerverifiedShow Answer

In a calculated control, expressions must start with what character?

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