Question 1

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.
A) Rectangle
B) Bound Object Frame
C) Unbound Object Frame
D) Line

Accepted Answer

The answer of A tool used to form a group...

Question 2

A form created from related tables usually consists of a ____ table which is the "one" side of the one-to-many relationship with a subform.
A) secondary
B) main
C) subordinate
D) primary

Accepted Answer

In a one-to-many relationship, the "one" side is the primary table and the "many" side is the subordinate table. Therefore, the form would consist of the primary table with a subform linked to the subordinate table.

Question 3

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.
A) tab alignment
B) tab stop
C) tab order
D) tab focus

Accepted Answer

Tab order refers to the order in which the focus moves from one control to another control when a user presses the Tab key. This is an important feature for ensuring efficient and intuitive navigation of user interfaces, particularly for users with disabilities who rely on keyboard commands.

Question 4

Which symbol is used to distinguish an expression from a fieldname in a calculated control?
A) #
B) !
C) =
D) +

Accepted Answer

The symbol used to distinguish an expression from a fieldname in a calculated control is the equal sign (=). This is because expressions in Access are always preceded by an equal sign, while field names are not.

Question 5

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.
A) FORMAT
B) ARRANGE
C) LAYOUT
D) DESIGN

Accepted Answer

The Tab Order button is located on the DESIGN tab in Form Design view.

Question 6

Which button on the FORMAT tab is used to change the background color of a control, section, or object?
A) Background Image
B) Conditional Formatting
C) Background Color
D) Shape Fill

Accepted Answer

The Background Color button is specifically designed to change the background color of a control, section, or object. The other options, such as Background Image, Conditional Formatting, and Shape Fill, may be used for other purposes, but are not specifically designed for changing the background color.

Question 7

Only a field name or an expression may be used for the ____ property in a calculated control.
A) Source
B) Control Source
C) Visible
D) Calculate

Accepted Answer

The Control Source property is used to specify the source of data for a control, including calculated controls. It accepts either a field name or an expression. The Source property is not applicable to calculated controls, as it is used to specify the source object of a control (such as a table or query). The Visible property is used to determine whether a control is displayed on a form, and the Calculate property is not a valid property for controls.

Question 8

Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report?
A) Shift
B) Ctrl
C) Alt
D) Tab

Accepted Answer

The Shift key can be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report. Holding down the Shift key while drawing a line will constrain the line to a straight horizontal or vertical direction.

Question 9

Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property.
A) Visible
B) Format
C) Border Style
D) Special Effect

Accepted Answer

The options Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are all related to the visual appearance of an element and are part of the Special Effect control property. The other options, Visible and Border Style, do not include these specific visual effects.

Question 10

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.
A) Auto Order
B) Move
C) Custom Order
D) Tab Stop

Accepted Answer

The "Auto Order" option in the Tab Order dialog box automatically sets the tab order based on the position of the form elements on the page. It can set the order from left-to-right or top-to-bottom depending on the layout of the form. The other options (Move, Custom Order, Tab Stop) allow manual adjustment of the tab order, but do not offer the automatic left-to-right or top-to-bottom option.

Question 11

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.
A) Control Source
B) ControlTip Text
C) Text Format
D) Visible

Accepted Answer

The ControlTip Text property is specifically used to determine the text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form. The other options listed (Control Source, Text Format, and Visible) do not affect the display of ScreenTips.

Question 12

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.
A) Record Source
B) Default View
C) Caption
D) Modal

Accepted Answer

The Record Source property of a form specifies the table or query that is the source for all the bound controls in the Detail section, including the combo box. By setting the Record Source to the appropriate table or query, the combo box can be used to search for and display specific records from that source. The other listed properties (Default View, Caption, Modal) are not directly related to the functionality of the combo box in searching for records.

Question 13

Which property must be set to Yes in the Property Sheet to display a control or a section in the form?
A) Height
B) Special Effect
C) Auto Height
D) Visible

Accepted Answer

The Visible property must be set to Yes for a control or section to be displayed in the form.

Question 14

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.
A) one inch
B) one-half inch
C) one-quarter inch
D) zero

Accepted Answer

The answer of The default Form Footer section Height property...

Question 15

A ____ asks a series of questions and then uses your answers to create a control in a form or report.
A) Form Wizard
B) Control Wizard
C) Report Wizard
D) Control Gallery

Accepted Answer

The Control Wizard is used to create controls in a form or report based on the user's input. It asks a series of questions to determine the type of control needed and how it should be configured. The Form Wizard and Report Wizard are used to create entire forms or reports, whereas the Control Gallery is a collection of pre-made controls that can be added to a form or report.

Question 16

The expression =Sum([InvoiceAmt]) might be found in which type of control added to a form?
A) field control
B) label control
C) calculated control
D) combo control

Accepted Answer

The expression =Sum([InvoiceAmt]) is used to calculate the total sum of the InvoiceAmt field, which is a calculated control. Therefore, the correct answer is C.

Question 17

The number of occurrences of an expression is determined using the ____ function in a form or report.
A) SUM
B) AVERAGE
C) COUNT
D) MAX

Accepted Answer

The COUNT function is used to count the number of occurrences of a specific expression in a form or report. The other functions (SUM, AVERAGE, MAX) are used for numerical calculations and would not provide the desired result in this context.

Question 18

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.
A) Tab Stop
B) On Tab
C) Tab Index
D) Text Align

Accepted Answer

The Tab Stop property allows the designer to specify whether a control should receive focus when the Tab key is pressed. Setting the Tab Stop property to No prevents the control from being tabbed to, thus preventing users from navigating to it using the Tab key. On Tab and Tab Index properties are not relevant in this context, and Text Align property does not affect the control's ability to receive focus.

Question 19

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.
A) Property Sheet
B) Controls group on the ribbon
C) Form view
D) Expression Builder

Accepted Answer

Expression Builder provides a visual interface that helps to create complex expressions with built-in functions, operators, and syntax checking. This reduces the likelihood of typing errors and makes it easier to write advanced calculations.

Question 20

To select and set properties for an entire section, click on the ____.
A) Property Sheet
B) section selector
C) section tab
D) Layout view

Accepted Answer

The section selector allows you to select and set properties for an entire section in Microsoft Access. The property sheet allows you to view and modify the properties of selected objects (such as tables, forms, and reports), the section tab allows you to switch between different sections of a form or report, and layout view allows you to adjust the layout and design of a form or report but does not provide specific section selection options.

Quiz 2: Access: Using Form Tools and Creating Custom Forms

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

A form created from related tables usually consists of a ____ table which is the "one" side of the one-to-many relationship with a subform.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.

Which button on the FORMAT tab is used to change the background color of a control, section, or object?

Only a field name or an expression may be used for the ____ property in a calculated control.

Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report?

Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property.

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

Which property must be set to Yes in the Property Sheet to display a control or a section in the form?

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

A ____ asks a series of questions and then uses your answers to create a control in a form or report.

The expression =Sum([InvoiceAmt]) might be found in which type of control added to a form?

The number of occurrences of an expression is determined using the ____ function in a form or report.

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.

To select and set properties for an entire section, click on the ____.