Question 1

To set a startup form, click the File tab, and then click _____.

Accepted Answer

A)  New 
B)  Open 
C)  Options 
D)  Account 
A)  New 
B)  Open 
C)  Options 
D)  Account

Question 2

When you remove a control layout from a form or report, Access ____.

Accepted Answer

A)  removes the controls 
B)  changes the arrangement of the controls 
C)  displays an error message 
D)  no longer groups the controls together 
A)  removes the controls 
B)  changes the arrangement of the controls 
C)  displays an error message 
D)  no longer groups the controls together

Question 3

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Accepted Answer

A)  syntax 
B)  run-time 
C)  logic 
D)  compile-time 
A)  syntax 
B)  run-time 
C)  logic 
D)  compile-time

Question 4

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

Accepted Answer

A) True 
 B)False

Question 5

To display customized text in the Access title, bar, set the _____ option in the Options dialog box.

Accepted Answer

A)  Display Database Name 
B)  Use Access Special Keys 
C)  Application Title 
D)  Display Form 
A)  Display Database Name 
B)  Use Access Special Keys 
C)  Application Title 
D)  Display Form

Question 6

You use the Performance Analyzer to analyze tables only.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The edits you make in a query datasheet do not affect the data in the underlying table.

Accepted Answer

A) True 
 B)False

Question 9

You use the Header button to add a title to a report in Report Design view.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

Accepted Answer

A)  End Function 
B)  End Sub 
C)  End Statement 
D)  Close Function 
A)  End Function 
B)  End Sub 
C)  End Statement 
D)  Close Function

Question 11

You can use the Find command to find and then change data in a datasheet or a _____.

Accepted Answer

A)  form 
B)  relationship 
C)  data type 
D)  reports 
A)  form 
B)  relationship 
C)  data type 
D)  reports

Question 12

Delete queries delete entire records, not just selected fields within records.

Accepted Answer

A) True 
 B)False

Question 13

After you export report data to an HTML document, you can _____ the data in a browser.

Accepted Answer

A)  edit 
B)  format 
C)  view 
D)  update 
A)  edit 
B)  format 
C)  view 
D)  update

Question 14

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

Accepted Answer

A) True 
 B)False

Question 15

David is using the Form Wizard to create a form based on two tables that have a one-to-many relationship. What type of form is he probably creating?

Accepted Answer

A)  subform only 
B)  main form with a subform 
C)  blank form 
D)  major form with minor form 
A)  subform only 
B)  main form with a subform 
C)  blank form 
D)  major form with minor form

Question 16

If the background color of the Detail section of a form is blue and you want the form controls to look the same, use the Background Color button to change the background color of the controls.

Accepted Answer

A) True 
 B)False

Question 17

A delimited text file such as a CSV file stores one _____ on each line.

Accepted Answer

A)  record 
B)  field 
C)  table 
D)  property 
A)  record 
B)  field 
C)  table 
D)  property

Question 18

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 19

Allison wants to add text in the Comment field of every customer record with a particular set of characters in the Email field. What type of query should she create?

Accepted Answer

A)  Make-Table 
B)  Crosstab 
C)  Append 
D)  Update 
A)  Make-Table 
B)  Crosstab 
C)  Append 
D)  Update

Question 20

What must you use to create a custom function in Access?

Accepted Answer

A)  The Custom Function Wizard 
B)  An Access module 
C)  An Access macro 
D)  A data macro 
A)  The Custom Function Wizard 
B)  An Access module 
C)  An Access macro 
D)  A data macro

To set a startup form, click the File tab, and then click _____.

When you remove a control layout from a form or report, Access ____.

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

To display customized text in the Access title, bar, set the _____ option in the Options dialog box.

You use the Performance Analyzer to analyze tables only.

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

The edits you make in a query datasheet do not affect the data in the underlying table.

You use the Header button to add a title to a report in Report Design view.

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

You can use the Find command to find and then change data in a datasheet or a _____.

Delete queries delete entire records, not just selected fields within records.

After you export report data to an HTML document, you can _____ the data in a browser.

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

David is using the Form Wizard to create a form based on two tables that have a one-to-many relationship. What type of form is he probably creating?

If the background color of the Detail section of a form is blue and you want the form controls to look the same, use the Background Color button to change the background color of the controls.

A delimited text file such as a CSV file stores one _____ on each line.

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

Allison wants to add text in the Comment field of every customer record with a particular set of characters in the Email field. What type of query should she create?

What must you use to create a custom function in Access?

Excel 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 1: Access 2019

To set a startup form, click the File tab, and then click _____.

When you remove a control layout from a form or report, Access ____.

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

To display customized text in the Access title, bar, set the _____ option in the Options dialog box.

You use the Performance Analyzer to analyze tables only.

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

The edits you make in a query datasheet do not affect the data in the underlying table.

You use the Header button to add a title to a report in Report Design view.

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

You can use the Find command to find and then change data in a datasheet or a _____.

Delete queries delete entire records, not just selected fields within records.

After you export report data to an HTML document, you can _____ the data in a browser.

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

David is using the Form Wizard to create a form based on two tables that have a one-to-many relationship. What type of form is he probably creating?

If the background color of the Detail section of a form is blue and you want the form controls to look the same, use the Background Color button to change the background color of the controls.

A delimited text file such as a CSV file stores one _____ on each line.

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

Allison wants to add text in the Comment field of every customer record with a particular set of characters in the Email field. What type of query should she create?

What must you use to create a custom function in Access?

Excel 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters