Question 1

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 2

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 
A)  check box 
B)  option button 
C)  command button 
D)  option group

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 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 
A)  Mistyping the word function 
B)  Using too many comments 
C)  Forgetting an End If statement 
D)  Dividing by zero

Question 6

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 
A)  Make a Backup 
B)  Back Up Database 
C)  Package and Sign 
D)  Compact & Repair

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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 
A)  arrow keys 
B)  conditional sizing 
C)  resizing handles 
D)  smart guides

Question 10

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 
A)  index 
B)  blank string 
C)  validation text 
D)  zero-length string

Question 11

In which object can you rename a field?

Accepted Answer

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

Question 12

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 
A)  To Default 
B)  To Fit 
C)  To Tallest 
D)  To Widest

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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 
A)  attachment 
B)  tab 
C)  option group 
D)  combo box

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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 
A)  Filter By Form 
B)  Advanced Filter 
C)  Find and Replace 
D)  Filter By Selection

Question 20

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. 
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.

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

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

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

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

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

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

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

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

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

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

In which object can you rename a field?

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

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

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

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

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

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

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

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

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?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

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

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

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

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

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

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

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

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

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

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

In which object can you rename a field?

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

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

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

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

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

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

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

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

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?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters