Question 1

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 displays data in both Form view and Datasheet view at the same time, making it easy to edit and navigate through large amounts of data. Multiple Items and Datasheet display data only in Datasheet view, while Standard view displays data only in Form view.

Question 2

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 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 calculated control is used to display a value that is the result of an expression or calculation. The control's ControlSource property is set to an expression that performs the calculation and displays the result.

Question 4

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.

Question 5

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 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. Clicking on the section selector will highlight the entire section, allowing you to modify its properties through the Property Sheet. The section tab only allows you to switch between different sections within a form or report, while Layout view is a view option for designing forms and reports.

Question 7

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 allows users to either enter text or select from a list of predefined options. It combines the features of a text box and a list box, making it a versatile control for user input.

Question 8

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 9

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 and precision over the design of a form, including placement and size of form controls, setting properties, and adding custom code. Layout view and Form Wizard can be helpful for quick and simple form designs, but may not offer the same level of control and customization as Design view. Split Form Tool is a layout option and does not affect the level of control and precision in form design.

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

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 of the relationship is typically the primary table and the "many" side is the related table. The form will consist of the primary table with a subform for the related table. Therefore, the best choice is D, which refers to the primary table.

Question 12

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 13

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 14

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 typically displays the field name or Caption property, providing a clear identifier for the information displayed in the control. The other options listed may be displayed elsewhere in the control or form design, but are not typically associated with the label of a bound control.

Question 15

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 specifies the data source for a control, field in a table or query, or a column in a combo box or list box. It can contain a table or query name, SQL statement, or a list of values separated by semicolons. The other options listed do not relate to the data source of a control, field, or column.

Question 16

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 the form specifies the table or query that is the source for all the bound controls in the Detail section of the form. By changing the Record Source property to the desired table or query, the data in the combo box can be linked to that source and used to filter records in the form. Changing the Default View, Caption or Modal properties would not have any impact on the ability to find records using a combo box.

Question 17

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 calculated control in a form or report. It can be a field name or an expression. The Source property is used to specify the source of data for a control that is bound to a field in a table or query. The Visible property is used to determine whether a control is visible or hidden. The Calculate property does not exist in Access.

Question 18

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

Titles, instructions, command buttons, and other controls added to the bottom of a form are added to the Form Footer section of the form.

Question 19

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 is the Access tool that allows the user (or designer) to create detailed documentation of all, or selected, objects in a database. It can help users to understand the structure and relationships of a database and can be useful for troubleshooting and maintenance. Options B, C, and D are not specifically related to the creation of documentation.

Question 20

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 specifically used to count the number of occurrences of an expression in a form or report. Sum, Average, and Max do not count occurrences, but rather perform mathematical operations on a set of values.

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

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

A selected control will display how many sizing handles?

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

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

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

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

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.

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

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

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.

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

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

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

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

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.

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.

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

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