Question 1

A _____ module is stored as a part of the form or report in which it was created.

Accepted Answer

A)  global 
B)  class 
C)  standard 
D)  sub 
A)  global 
B)  class 
C)  standard 
D)  sub

Question 2

Deleting a text box in Form Layout view _____.

Accepted Answer

A)  deletes the data from the field 
B)  does not delete the text box in Form Design view 
C)  deletes the field from the underlying table 
D)  removes the text box from the form 
A)  deletes the data from the field 
B)  does not delete the text box in Form Design view 
C)  deletes the field from the underlying table 
D)  removes the text box from the form

Question 3

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

Accepted Answer

A)  the date must be after 7/1/21 
B)  the date must be before 7/1/21 
C)  the date must be in July of 2021 
D)  the date must be 7/1/21 
A)  the date must be after 7/1/21 
B)  the date must be before 7/1/21 
C)  the date must be in July of 2021 
D)  the date must be 7/1/21

Question 4

How do you add an If statement to a macro in Macro Design view?

Accepted Answer

A)  Double-click If in the Program Flow area of the Action Catalog. 
B)  Double-click Submacro in the Program Flow area of the Action Catalog. 
C)  Double-click Conditional in the Actions area of the Action Catalog. 
D)  Click the Add New Action arrow and then click RunConditional. 
A)  Double-click If in the Program Flow area of the Action Catalog. 
B)  Double-click Submacro in the Program Flow area of the Action Catalog. 
C)  Double-click Conditional in the Actions area of the Action Catalog. 
D)  Click the Add New Action arrow and then click RunConditional.

Question 5

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

Accepted Answer

A) True 
 B)False

Question 6

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 7

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

Accepted Answer

A) True 
 B)False

Question 8

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

Accepted Answer

A)  navigation form 
B)  tab control 
C)  subform 
D)  split form 
A)  navigation form 
B)  tab control 
C)  subform 
D)  split form

Question 9

When you export table data to a PDF file, you need software such as _____ to view the data.

Accepted Answer

A)  Microsoft Excel 
B)  an Access web template 
C)  Microsoft Outlook 
D)  Adobe Reader 
A)  Microsoft Excel 
B)  an Access web template 
C)  Microsoft Outlook 
D)  Adobe Reader

Question 10

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 11

The Lookup Source property stores the values that are provided in the list for a Lookup field.

Accepted Answer

A) True 
 B)False

Question 12

When you create a form using the Form Wizard, the Record Source property is blank.

Accepted Answer

A) True 
 B)False

Question 13

In Access, you create a macro by recording a series of steps you want the macro to perform.

Accepted Answer

A) True 
 B)False

Question 14

To import data from Excel to Access, you would begin by clicking the ____.

Accepted Answer

A)  Edit Relationships button 
B)  Property Sheet button 
C)  Relationships tab 
D)  External Data tab 
A)  Edit Relationships button 
B)  Property Sheet button 
C)  Relationships tab 
D)  External Data tab

Question 15

Which of the following controls would you use to display a Yes/No field on a form?

Accepted Answer

A)  combo box 
B)  command button 
C)  check box 
D)  label 
A)  combo box 
B)  command button 
C)  check box 
D)  label

Question 16

Which of the following changes makes a datasheet easier to read?

Accepted Answer

A)  Change the field sizes in Table Design view. 
B)  Increase the font size. 
C)  Add new records. 
D)  Reset table relationships. 
A)  Change the field sizes in Table Design view. 
B)  Increase the font size. 
C)  Add new records. 
D)  Reset table relationships.

Question 17

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top. This arrangement is called a(n) _____.

Accepted Answer

A)  stacked layout 
B)  anchored layout 
C)  spreadsheet layout 
D)  tabular layout 
A)  stacked layout 
B)  anchored layout 
C)  spreadsheet layout 
D)  tabular layout

Question 18

How can you select all the labels in a report section when working in Report Design view?

Accepted Answer

A)  Double-click each control in the report section. 
B)  Drag in the horizontal ruler from the left to the right margin of the report. 
C)  Drag a selection box around the controls. 
D)  Double-click the report selector button. 
A)  Double-click each control in the report section. 
B)  Drag in the horizontal ruler from the left to the right margin of the report. 
C)  Drag a selection box around the controls. 
D)  Double-click the report selector button.

Question 19

Aimee wants to display labels as white text on a dark blue background. While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

Accepted Answer

A)  Alternate Row Color 
B)  Background Color 
C)  Font Color 
D)  Shape Effects 
A)  Alternate Row Color 
B)  Background Color 
C)  Font Color 
D)  Shape Effects

Question 20

Joe adds the ClientName and ProjectID fields to the query grid. To find records without values in the ProjectID field, he can use Is Null as the criterion for the ProjectID field.

Accepted Answer

A) True 
 B)False

A _____ module is stored as a part of the form or report in which it was created.

Deleting a text box in Form Layout view _____.

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

How do you add an If statement to a macro in Macro Design view?

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

When you export table data to a PDF file, you need software such as _____ to view the data.

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

The Lookup Source property stores the values that are provided in the list for a Lookup field.

When you create a form using the Form Wizard, the Record Source property is blank.

In Access, you create a macro by recording a series of steps you want the macro to perform.

To import data from Excel to Access, you would begin by clicking the ____.

Which of the following controls would you use to display a Yes/No field on a form?

Which of the following changes makes a datasheet easier to read?

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top. This arrangement is called a(n) _____.

How can you select all the labels in a report section when working in Report Design view?

Aimee wants to display labels as white text on a dark blue background. While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

Joe adds the ClientName and ProjectID fields to the query grid. To find records without values in the ProjectID field, he can use Is Null as the criterion for the ProjectID field.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

A _____ module is stored as a part of the form or report in which it was created.

Deleting a text box in Form Layout view _____.

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

How do you add an If statement to a macro in Macro Design view?

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

When you export table data to a PDF file, you need software such as _____ to view the data.

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

The Lookup Source property stores the values that are provided in the list for a Lookup field.

When you create a form using the Form Wizard, the Record Source property is blank.

In Access, you create a macro by recording a series of steps you want the macro to perform.

To import data from Excel to Access, you would begin by clicking the ____.

Which of the following controls would you use to display a Yes/No field on a form?

Which of the following changes makes a datasheet easier to read?

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top. This arrangement is called a(n) _____.

How can you select all the labels in a report section when working in Report Design view?

Aimee wants to display labels as white text on a dark blue background. While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

Joe adds the ClientName and ProjectID fields to the query grid. To find records without values in the ProjectID field, he can use Is Null as the criterion for the ProjectID field.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters