Question 1

To remove one or more selected controls from a control layout, ____ the control to open the shortcut menu, point to Layout, and then click Remove Layout.
A) right-click
B) single-click
C) double-click
D) select

Accepted Answer

To open the shortcut menu for a control and access the Remove Layout option, you need to right-click on the control.

Question 2

Match between columns
                        Premises: Used to display only certain records based on certain criteria

Accepted Answer

The Answer of filter and arguments and comment and multiple is...

Question 3

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Whole Field option in the Match menu, she'll find values that ____.
A) contain the letter S anywhere in the value
B) contain only the letter S
C) begin with the letter S
D) none of the above

Accepted Answer

The answer of Case AC 4-1 Jessica wants to find...

Question 4

FIGURE AC 4-1  Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.
A) File
B) Create
C) Home
D) Format

Accepted Answer

The More Forms button is located in the Forms group on the Create tab in Microsoft Word.

Question 5

Match between columns
                        Premises: Explanatory text that you can add to a macro

Accepted Answer

The Answer of filter and code and comment and multiple is...

Question 6

Match between columns
                        Premises: The macro actions formatted in easy-to-read sentences

Accepted Answer

The Answer of comment and arguments and filter and code is...

Question 7

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

Accepted Answer

The answer of The Form Wizard provides four form layouts...

Question 8

The ____________________ pane contains the tables in the database and displays the fields they contain.

Accepted Answer

The answer of The ____________________ pane contains the tables in...

Question 9

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.
A) grids
B) rulers
C) guides
D) rows

Accepted Answer

The horizontal and vertical rulers show measurements that allow for precise positioning of controls in Design view. The other options (grids, guides, and rows) do not provide this level of precision.

Question 10

Match between columns
                        Premises: Should be entered in a logical order

Accepted Answer

The Answer of comment and arguments and filter and code is...

Question 11

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

Accepted Answer

The answer of A form's style, also called a(n) ____________________,...

Question 12

FIGURE AC 4-1  Referring to Figure AC 4-1 above, the form shown was created by using the ____ tool.
A) Double Form
B) Double View
C) Split Form
D) Split View

Accepted Answer

The form shown in Figure AC 4-1 is divided into two sections, with the fields on the left and a datasheet on the right. This is a characteristic of a Split Form, which allows users to view and edit data in both a form view and a datasheet view at the same time. Double Form, Double View, and Split View do not accurately describe the form shown.

Question 13

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.
A) contain the letter S anywhere in the value
B) contain only the letter S
C) begin with the letter S
D) none of the above

Accepted Answer

The option "Any Part of Field" means that the search will look for values that contain the letter S anywhere in the value, not just at the beginning or end.

Question 14

To delete a control from a form, click the control to select it, and then press ____________________.

Accepted Answer

The answer of To delete a control from a form,...

Question 15

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ____ group.
A) Data
B) Forms
C) Edit
D) Query

Accepted Answer

The Blank Form button is located in the Forms group on the Create tab.

Question 16

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. Zack has opened the Field List pane and wants to add a field to the form. What should he do?
A) Double-click a field in the Field List
B) Click Create Field on the Ribbon
C) Both a. and b.
D) Neither a. nor b.

Accepted Answer

The correct way to add a field to the custom form is to double-click a field in the Field List pane. This will add the selected field to the form. Option B is not correct as there is no "Create Field" button on the Ribbon for creating a new field. Therefore, the correct answer is A.

Question 17

Match between columns
                        Premises: Additional information that Access needs based on the chosen action

Accepted Answer

The Answer of filter and arguments and comment and multiple is...

Question 18

When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form's record source and layout.

Accepted Answer

The answer of When you need to create a simple...

Question 19

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.
A) Design
B) Layout
C) Datasheet
D) Form

Accepted Answer

To print the form with the current record displayed, you must be in Form view where you can navigate to the desired record that you want to print. Design view is used to make changes to the form design, Layout view is used to adjust the positioning of form elements, and Datasheet view displays records in a table-like format.

Question 20

The ____________________ tool creates a form that looks just like a datasheet.

Accepted Answer

The answer of The ____________________ tool creates a form that...

Quiz 1: Microsoft Access Basics

To remove one or more selected controls from a control layout, ____ the control to open the shortcut menu, point to Layout, and then click Remove Layout.

Identify the letter of the choice that best matches the phrase or definition.

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Whole Field option in the Match menu, she'll find values that ____.

FIGURE AC 4-1 Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

The ____________________ pane contains the tables in the database and displays the fields they contain.

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

Identify the letter of the choice that best matches the phrase or definition.

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

FIGURE AC 4-1 Referring to Figure AC 4-1 above, the form shown was created by using the ____ tool.

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

To delete a control from a form, click the control to select it, and then press ____________________.

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ____ group.

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. Zack has opened the Field List pane and wants to add a field to the form. What should he do?

Identify the letter of the choice that best matches the phrase or definition.

When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form's record source and layout.

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.

The ____________________ tool creates a form that looks just like a datasheet.