Question 1

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

Accepted Answer

A)  Picture 
B)  Logo 
C)  Graphics 
D)  Image 
A)  Picture 
B)  Logo 
C)  Graphics 
D)  Image

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

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

Accepted Answer

A)  Control 
B)  Form 
C)  Button 
D)  Field 
A)  Control 
B)  Form 
C)  Button 
D)  Field

Question 4

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Accepted Answer

A)  Use conditional formatting. 
B)  Bold the OrderAmt text box. 
C)  Change the font color of the OrderAmt label. 
D)  Change the background color of the OrderAmt text box. 
A)  Use conditional formatting. 
B)  Bold the OrderAmt text box. 
C)  Change the font color of the OrderAmt label. 
D)  Change the background color of the OrderAmt text box.

Question 5

Tab order refers to the order you added tabbed pages to a tab control.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following options can you set when creating a report with the Report Wizard?

Accepted Answer

A)  page numbers 
B)  grouping field 
C)  sort order 
D)  orientation 
A)  page numbers 
B)  grouping field 
C)  sort order 
D)  orientation

Question 7

To determine whether a control appears or is hidden on a form, set the _____ property for the control.

Accepted Answer

A)  Value 
B)  Caption 
C)  Visible 
D)  Format 
A)  Value 
B)  Caption 
C)  Visible 
D)  Format

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following options are available to you when you start Access? Select all the options that apply.

Accepted Answer

A)  Import an existing database. 
B)  Open an existing database. 
C)  Create a new blank database. 
D)  Create a database from a template. 
A)  Import an existing database. 
B)  Open an existing database. 
C)  Create a new blank database. 
D)  Create a database from a template.

Question 10

Which of the following features apply a coordinated set of changes to all the forms in the database? Select all the options that apply.

Accepted Answer

A)  theme 
B)  theme fonts 
C)  theme colors 
D)  theme margins 
A)  theme 
B)  theme fonts 
C)  theme colors 
D)  theme margins

Question 11

When you enter a record in a table, you are working in navigation mode.

Accepted Answer

A) True 
 B)False

Question 12

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

Accepted Answer

A) True 
 B)False

Question 13

Use the Default field property to specify that an entry is required for the field.

Accepted Answer

A) True 
 B)False

Question 14

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 15

A mail merge combines data from an Access table or form into a Word form letter.

Accepted Answer

A) True 
 B)False

Question 16

You select a control layoutso that you can move or change the controls as a group.

Accepted Answer

A) True 
 B)False

Question 17

Tables, queries, and forms are examples of Access ____.

Accepted Answer

A)  values 
B)  objects 
C)  fields 
D)  controls 
A)  values 
B)  objects 
C)  fields 
D)  controls

Question 18

Which of the following formatting changes can you make to a text box control in Form Design view? Select all the options that apply.

Accepted Answer

A)  font size 
B)  font color 
C)  background color 
D)  alternate row color 
A)  font size 
B)  font color 
C)  background color 
D)  alternate row color

Question 19

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following techniques can you use to select all the controls in Report Design view? Select all the options that apply.

Accepted Answer

A)  Click the Select All button on the Format tab. 
B)  Drag in the horizontal ruler from the left to the right margin of the report. 
C)  Click one control, press and hold the SHIFT key, and then click the other controls. 
D)  Click the report selector button. 
A)  Click the Select All button on the Format tab. 
B)  Drag in the horizontal ruler from the left to the right margin of the report. 
C)  Click one control, press and hold the SHIFT key, and then click the other controls. 
D)  Click the report selector button.

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

Deleting a text box in Form Layout view _____.

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Tab order refers to the order you added tabbed pages to a tab control.

Which of the following options can you set when creating a report with the Report Wizard?

To determine whether a control appears or is hidden on a form, set the _____ property for the control.

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

Which of the following options are available to you when you start Access? Select all the options that apply.

Which of the following features apply a coordinated set of changes to all the forms in the database? Select all the options that apply.

When you enter a record in a table, you are working in navigation mode.

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

Use the Default field property to specify that an entry is required for the field.

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

A mail merge combines data from an Access table or form into a Word form letter.

You select a control layoutso that you can move or change the controls as a group.

Tables, queries, and forms are examples of Access ____.

Which of the following formatting changes can you make to a text box control in Form Design view? Select all the options that apply.

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Which of the following techniques can you use to select all the controls in Report Design view? Select all the options that apply.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

Deleting a text box in Form Layout view _____.

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Tab order refers to the order you added tabbed pages to a tab control.

Which of the following options can you set when creating a report with the Report Wizard?

To determine whether a control appears or is hidden on a form, set the _____ property for the control.

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

Which of the following options are available to you when you start Access? Select all the options that apply.

Which of the following features apply a coordinated set of changes to all the forms in the database? Select all the options that apply.

When you enter a record in a table, you are working in navigation mode.

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

Use the Default field property to specify that an entry is required for the field.

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

A mail merge combines data from an Access table or form into a Word form letter.

You select a control layoutso that you can move or change the controls as a group.

Tables, queries, and forms are examples of Access ____.

Which of the following formatting changes can you make to a text box control in Form Design view? Select all the options that apply.

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Which of the following techniques can you use to select all the controls in Report Design view? Select all the options that apply.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters