Question 1

The Align button in the Sizing and Ordering group is available on the ____ tab.
A) Arrange
B) Options
C) Home
D) Format

Accepted Answer

The Align button is part of the Arrange group which is located on the Arrange tab.

Question 2

Expressions must start with what character?
A) [ left square bracket
B) = equal sign
C) ( left parenthesis
D) : colon

Accepted Answer

The answer of Expressions must start with what character?
A) [...

Question 3

____ refers to the space between the outer edge of the control and the data displayed inside the control.
A) Spacing
B) Reference
C) Padding
D) Margin

Accepted Answer

The answer of ____ refers to the space between the...

Question 4

Which control is used to provide consistent descriptive text as you navigate from record to record?
A) Text box
B) Combo box
C) List box
D) Label

Accepted Answer

Labels are the best choice for providing consistent descriptive text as you navigate from record to record. Labels are static controls that do not allow user input, and they are commonly used to provide descriptive text for other controls on a form or report. They can be linked to fields in a database to display the corresponding data for each record, and they remain the same as you move through the records.

Question 5

You can press ____ to move the focus through the controls of the form.
A) [Page Down]
B) [Tab]
C) [F5]
D) [F12]

Accepted Answer

The [Tab] key is used for navigating through the controls of a form. It moves the focus to the next control in the tab order, which is usually from left to right and top to bottom.

Question 6

____ View lets you make some design changes to a form while you are browsing the data.
A) Layout
B) Design
C) Browse
D) Data

Accepted Answer

Layout view allows you to make design changes to a form while you are browsing the data. It lets you modify the layout and formatting of a form without having to switch to Design view.

Question 7

Which of the following is NOT a bound control?
A) Text box
B) Combo box
C) List box
D) Label

Accepted Answer

Labels are not bound controls, as they do not display data from a datasource. Text boxes, combo boxes, and list boxes are all examples of bound controls.

Question 8

Which of the following would most likely be used to display a Yes/No field on a form?
A) Check box
B) Command button
C) Combo box
D) Label

Accepted Answer

A check box is the most common and intuitive way to display a Yes/No field on a form. The user can simply check or uncheck the box to indicate their answer.

Question 9

Which control displays a list of possible data entries from which the user can choose?
A) Label
B) Text box
C) List box
D) Tab control

Accepted Answer

The list box control displays a list of possible data entries from which the user can choose. Labels are used for displaying text, text boxes are used for user input, and tab controls are used for organizing content into multiple tabs.

Question 10

Which control is used to create a three-dimensional aspect to a form?
A) Command button
B) Toggle button
C) Rectangle control
D) Tab control

Accepted Answer

The answer of Which control is used to create a...

Question 11

The Font Color list arrow in the Font group is available on the ____ tab.
A) Arrange
B) Options
C) Home
D) Format

Accepted Answer

The answer of The Font Color list arrow in the...

Question 12

When referencing field names within an expression, surround the field name with ____.
A) [square brackets]
B) {curly brackets}
C) (parentheses)
D) "quotation marks"

Accepted Answer

In Microsoft Access, field names should be surrounded by square brackets when used within an expression to ensure proper syntax and prevent errors.

Question 13

Controls placed in the ____ form section print only once at the top of the printout.
A) Form Header
B) Detail
C) Form First
D) Form Top

Accepted Answer

Controls placed in the Form Header section are printed only once at the top of the page, making it the best choice for items such as report titles, logos, or page numbers that need to appear at the top of the printout. The Detail section is repeated for each record, while the Form First and Form Top sections are not commonly used.

Question 14

Which control, when it appears pressed, displays "yes" information?
A) Bound image control
B) Combo box
C) Tab control
D) Toggle button

Accepted Answer

When a toggle button appears pressed, it typically displays "yes" information or indicates an "on" state. Therefore, the best choice is a toggle button.

Question 15

____ records are those on the many side of a relationship that do not have a match on the one side.
A) indexed
B) split
C) unlicensed
D) orphan

Accepted Answer

Orphan records are those that do not have a match on the one side of a relationship. They are also known as unlinked or dangling records. These records can create issues in database design and should be identified and addressed to ensure data integrity.

Question 16

Which control provides an easy way to initiate a command or run a macro?
A) Check box
B) Toggle button
C) Command button
D) Image control

Accepted Answer

The Command button is specifically designed to initiate a command or run a macro when clicked. The other controls listed do not have this functionality.

Question 17

You can toggle the Field List on and off using the _____ button on the Design tab in Layout or Design View.
A) Form Fields
B) Add Existing Fields
C) Field List
D) Add Fields and Tables

Accepted Answer

The answer of You can toggle the Field List on...

Question 18

You can insert a logo on a form using the ____ button in the Controls group.
A) Graphic Art
B) Art
C) Graphic Image
D) Insert Image

Accepted Answer

The most logical choice for inserting an image or logo onto a form is the "Insert Image" button, as it is a direct and clear option. The other choices, such as "Graphic Art" and "Graphic Image," are less specific and could potentially refer to a variety of different design elements. "Art" is too vague and could include any type of visual representation, not necessarily a logo or image.

Question 19

Which control is both a list box and a text box control?
A) Bound image control
B) Unbound image control
C) Combo box
D) Option group

Accepted Answer

A combo box control is both a list box and a text box control. Users can either select an option from the list box or enter their own text in the text box. The other options listed (bound and unbound image controls, option group) do not have the functionality of both a list box and text box.

Question 20

When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image.
A) label indices
B) sizing handles
C) combo boxes
D) command squares

Accepted Answer

Sizing handles are small squares at the corners of the selection box that allow you to resize the image or control when it is selected in Design View, making B the correct choice. Label indices, combo boxes, and command squares do not have anything to do with resizing images, so they are not the correct choice.

Quiz 3: Using Forms

The Align button in the Sizing and Ordering group is available on the ____ tab.

Expressions must start with what character?

____ refers to the space between the outer edge of the control and the data displayed inside the control.

Which control is used to provide consistent descriptive text as you navigate from record to record?

You can press ____ to move the focus through the controls of the form.

____ View lets you make some design changes to a form while you are browsing the data.

Which of the following is NOT a bound control?

Which of the following would most likely be used to display a Yes/No field on a form?

Which control displays a list of possible data entries from which the user can choose?

Which control is used to create a three-dimensional aspect to a form?

The Font Color list arrow in the Font group is available on the ____ tab.

When referencing field names within an expression, surround the field name with ____.

Controls placed in the ____ form section print only once at the top of the printout.

Which control, when it appears pressed, displays "yes" information?

____ records are those on the many side of a relationship that do not have a match on the one side.

Which control provides an easy way to initiate a command or run a macro?

You can toggle the Field List on and off using the _____ button on the Design tab in Layout or Design View.

You can insert a logo on a form using the ____ button in the Controls group.

Which control is both a list box and a text box control?

When an image or control is selected in Design View, you can use ____, which are small squares at the corners of the selection box, to resize the image.