Question 1

The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.
A) *education
B) .?education
C) *education*
D) .?education?

Accepted Answer

The asterisk (*) is a wildcard character in many database systems, including Microsoft Access, that represents any number of characters. Therefore, "*education*" will find any record where the long text field contains the word "education" anywhere within the text.

Question 2

To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.
A) Background Color
B) Color
C) Fill
D) Format

Accepted Answer

The Background Color button on the FORM DESIGN TOOLS FORMAT tab is used to change the background color of a form.

Question 3

To change the tab order in which fields are encountered on a form, tap or click the Tab Order button on the ____ tab.
A) HOME
B) FORM DESIGN TOOLS ARRANGE
C) CREATE
D) FORM DESIGN TOOLS DESIGN

Accepted Answer

The answer of To change the tab order in which...

Question 4

To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.
A) Open
B) Modify
C) Change Columns
D) Resize

Accepted Answer

The answer of To resize columns in a subform, press...

Question 5

To place a subform on a form, use the Subform/Subreport tool on the ____ tab.
A) FORM DESIGN TOOLS DESIGN
B) CREATE
C) HOME
D) FORM DESIGN TOOLS ARRANGE

Accepted Answer

The answer of To place a subform on a form,...

Question 6

To change the font color of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a color palette.
A) Color
B) Label Color
C) Font Color
D) Text Color

Accepted Answer

The correct option is "Font Color" as it is the standard term used in software applications for changing the color of the text or font.

Question 7

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.
A) Property Sheet
B) Special Effect
C) Properties
D) Labels

Accepted Answer

The answer of To change the special effect of a...

Question 8

To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.
A) Background
B) Format
C) Back Color
D) Fill/Back Color

Accepted Answer

The shortcut menu command to change the background color of a form is "Fill/Back Color".

Question 9

To test for the current date in a query, type ____ in the Criteria row of the appropriate column.
A) Current()
B) CurrentDate()
C) Today()
D) Date()

Accepted Answer

The answer of To test for the current date in...

Question 10

To go to a specific record in the main form, enter the record number in the ____ box for the main form.
A) Go to Record
B) Current Record
C) Next Record
D) Find Record

Accepted Answer

The "Current Record" box is used to enter a specific record number to navigate directly to that record in the main form.

Question 11

To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.
A) Simple Form
B) Datasheet Form
C) Form Design
D) Form

Accepted Answer

The answer of To create a simple form with a...

Question 12

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.
A) Add Section
B) Form Header/Footer
C) Insert Header
D) Arrange

Accepted Answer

The instructions specifically mention adding a header section, so Option B "Form Header/Footer" is the only appropriate choice. Option A "Add Section" could potentially create a header section, but it could also create other types of sections such as detail or footer sections. Option C "Insert Header" is not a valid option for adding a header to a form in this context. Option D "Arrange" is not related to adding a section or header to a form.

Question 13

To switch from Design view to Form view to display the form, tap or click the ____ button.
A) Display
B) Open
C) Window
D) View

Accepted Answer

To switch from Design view to Form view to display the form, tap or click the "View" button. This button can be found in the "Views" group on the "Ribbon" at the top of the screen.

Question 14

To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.
A) Picture
B) Size Mode
C) Cropping
D) Alignment

Accepted Answer

The "Size Mode" property is used to change how a picture is displayed in terms of its size within a form.

Question 15

To create a multiple-table form based on the "many" table, tap or click the ____ button on the CREATE tab to create a form in Layout view.
A) Multitable Form
B) Blank Form
C) Many Form
D) Layout Form

Accepted Answer

The answer of To create a multiple-table form based on...

Question 16

To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.
A) Layout Form
B) Layout View
C) Blank Form
D) Datasheet Form

Accepted Answer

The answer of To create a form with a datasheet...

Question 17

To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.
A) Tab
B) Order
C) Arrangement
D) Property Sheet

Accepted Answer

The Property Sheet button on the FORM DESIGN TOOLS DESIGN tab allows you to access and modify properties of a selected control, including the Tab Stop property.

Question 18

To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.
A) HOME
B) CREATE
C) DATABASE TOOLS
D) DESIGN

Accepted Answer

The correct tab to view object dependencies in Access is the DATABASE TOOLS tab on the ribbon. The Object Dependencies button can be found on this tab.

Question 19

To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.
A) Form Title
B) Name
C) Title
D) Text Box

Accepted Answer

The answer of To add a title to a form,...

Question 20

To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.
A) View
B) Form
C) Mode
D) Open

Accepted Answer

The answer of To use a form to view data,...

Quiz 7: Multiple-Table Forms

The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.

To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

To change the tab order in which fields are encountered on a form, tap or click the Tab Order button on the ____ tab.

To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.

To place a subform on a form, use the Subform/Subreport tool on the ____ tab.

To change the font color of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a color palette.

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.

To test for the current date in a query, type ____ in the Criteria row of the appropriate column.

To go to a specific record in the main form, enter the record number in the ____ box for the main form.

To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.

To switch from Design view to Form view to display the form, tap or click the ____ button.

To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

To create a multiple-table form based on the "many" table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.

To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.