Question 1

The label attached to a bound control displays which of the following?
A)the field value
B)the field name or Caption property
C)the field character length
D)the field data type property

Accepted Answer

The label attached to a bound control displays the field name or Caption property to identify what data is being shown in the control.

Question 2

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 3

A value that is the result of an expression is displayed in which type of control in a form?
A)bound control
B)unbound control
C)label
D)calculated

Accepted Answer

A value that is the result of an expression is displayed in a calculated control, which is designed to display the result of a calculation or expression. Bound controls display data from a table or query, unbound controls do not display data from a source, and a label is a type of control used to display text or a caption for other controls.

Question 4

The ____ property specifies the data source for a control in a form or report or for a field in a table or query.
A)Row Source Type
B)Row Source
C)List Items Edit Form
D)Column Heads

Accepted Answer

The Row Source property is used to specify the data source for a control in a form or report or for a field in a table or query. This property can be set to a table, query, or list of values to populate the control or field.

Question 5

Which form tool displays data in both Form view and Datasheet view at the same time?
A)Multiple Items
B)Datasheet
C)Split Form
D)Standard

Accepted Answer

The Split Form tool allows the user to view and edit data in both Form view and Datasheet view simultaneously, providing a more efficient way to navigate and manage data within a form. The Multiple Items tool displays multiple records in Form view, while the Datasheet tool only displays data in Datasheet view. The Standard tool creates a basic form with only one record displayed at a time.

Question 6

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. This option is not available in the Property Sheet or section tab. Layout view allows you to design and modify form and report layouts, but it is not specifically related to selecting and setting properties for a section.

Question 7

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

The main table in the form is the "one" side of the one-to-many relationship, and the related subform displays the "many" side of the relationship. Therefore, the main table is the primary table in the relationship.

Question 8

A control that combines the features of a text box and a list box is a ____.
A)text box
B)lookup box
C)custom box
D)combo box

Accepted Answer

A combo box combines the features of both a text box and a list box. It allows users to either type directly in the box or select from pre-defined options in the list.

Question 9

A customizable form that displays multiple records from a source table or query in a datasheet format may be created using the ____ form tool.
A)Datasheet
B)Split Form
C)Pivot Table
D)Multiple Items

Accepted Answer

The answer of A customizable form that displays multiple records...

Question 10

The Layout view or the Design view may be used to create a ____ form.
A)control
B)tabular
C)custom
D)wizard

Accepted Answer

The answer of The Layout view or the Design view...

Question 11

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 an expression in a form or report. The other choices are not suited for this purpose - Sum adds together values, Average calculates the average of values, and Max returns the maximum value in a set.

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 is what determines the source of data for all the bound controls in the Detail section of the form. By changing the Record Source property to the table or query that is the source for the Combo box, the form can be filtered to show only records that match the selected value in the Combo box.

Question 13

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 of a calculated control specifies the expression used to calculate the value displayed in the control. This can be a field name or an expression. The Source property is used for other types of controls, such as images or files. The Visible property determines whether the control is visible or hidden. The Calculate property is not a valid property for a calculated control.

Question 14

A selected control will display how many sizing handles?
A)1
B)2
C)4
D)7

Accepted Answer

The answer of A selected control will display how many...

Question 15

Titles, instructions, command buttons, and other controls added to the bottom of a form and that remain on the screen when the form is displayed in Form view or Layout view are added to the ____ section of the form.
A)Form Footer
B)Form Header
C)Details
D)Form Grid

Accepted Answer

The Form Footer is where titles, instructions, command buttons, and other controls added to the bottom of a form are placed. The Form Header is located at the top of the form and typically contains a title or logo. The Details section is where the main content of the form is displayed, and the Form Grid is the underlying structure of the form.

Question 16

Which view or tool allows the form designer the most control and precision when designing a form?
A)Design view
B)Layout view
C)Form Wizard
D)Split Form Tool

Accepted Answer

Design view allows the form designer to have complete control over the form's layout, controls, and properties, and provides the most precision in terms of design. Layout view also provides some control, but it is less precise and more geared towards quickly making adjustments to the layout without having to switch to Design view. The Form Wizard and Split Form Tool provide pre-built templates and layouts, which may not necessarily fit the designer's needs or preferences.

Question 17

Spacing around the text inside a control is determined using the ____ property.
A)Control Margins
B)Control Padding
C)Anchor
D)Text Format

Accepted Answer

The answer of Spacing around the text inside a control...

Question 18

The Access tool that allows the user (or designer)to create detailed documentation of all, or selected, objects in a database is the ____.
A)Documenter
B)Document Properties
C)Database Object Properties
D)Database Relationships

Accepted Answer

The Documenter tool in Access allows the user or designer to create detailed documentation of all or selected objects in a database, such as tables, forms, queries, and reports. The Document Properties option refers to specific properties of individual documents in Access, while Database Object Properties and Database Relationships are not tools for creating documentation of a database as a whole.

Question 19

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.
A)stacked
B)tabular
C)columnar
D)grid

Accepted Answer

The answer of Text box controls arranged in a datasheet...

Question 20

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 to display a control or a section in the form. The other options (Height, Special Effect, Auto Height) do not affect the visibility of the control or section.

Quiz 6: Using Form Tools and Creating Custom Forms

The label attached to a bound control displays which of the following?

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

A value that is the result of an expression is displayed in which type of control in a form?

The ____ property specifies the data source for a control in a form or report or for a field in a table or query.

Which form tool displays data in both Form view and Datasheet view at the same time?

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

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 control that combines the features of a text box and a list box is a ____.

A customizable form that displays multiple records from a source table or query in a datasheet format may be created using the ____ form tool.

The Layout view or the Design view may be used to create a ____ form.

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

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.

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

A selected control will display how many sizing handles?

Titles, instructions, command buttons, and other controls added to the bottom of a form and that remain on the screen when the form is displayed in Form view or Layout view are added to the ____ section of the form.

Which view or tool allows the form designer the most control and precision when designing a form?

Spacing around the text inside a control is determined using the ____ property.

The Access tool that allows the user (or designer) to create detailed documentation of all, or selected, objects in a database is the ____.

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.

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