Question 1

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

Accepted Answer

A selected control typically displays 7 sizing handles, which are used to resize the control from different directions.

Question 2

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 in order to display a control or section in the form. If this property is set to No, the control or section will not be visible to the user. Setting it to Yes ensures the element is visible when the form is opened.

Question 3

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 4

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 in a calculated control to specify the expression that calculates the value of the control. The other properties listed are not relevant to a calculated control.

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

Split Form displays data in both Form view and Datasheet view at the same time, allowing the user to see an individual record and the entire dataset simultaneously. This is useful for comparing and navigating through large amounts of data. Multiple Items creates a Form view with multiple records, Datasheet view displays the entire dataset only, and Standard creates a single record Form view.

Question 6

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 defines the source of data for all the bound controls in the Detail section of a form. By selecting the appropriate table or query as the Record Source, the combo box can be used to filter records in the form based on user selection. The other options are not related to this functionality.

Question 7

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 determine the number of occurrences of an expression in a form or report. It counts the number of non-null values in a specified field or expression. The Sum function calculates the total of a set of values, the Average function calculates the mean of a set of values, and the Max function returns the maximum value from a set of values.

Question 8

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. This documentation can include information such as object names, descriptions, data types, field sizes, and more. The Documenter tool can be accessed from the Database Tools tab in the ribbon.

Question 9

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 the entire section, including its layout, formatting, and other properties. It is located on the left side of the section in the design view of Access. The property sheet, section tab, and layout view are options for working with specific properties and views within a section, but do not allow you to set properties for the entire section.

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 Layout view or the Design view in form creation tools allows users to create custom forms by manually designing and arranging the form elements.

Question 11

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 type in text or select from a list of predetermined options. It combines the features of a text box and a list box into a single control, making it a useful and efficient tool for data entry and user interaction.

Question 12

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 Multiple Items form tool in Access allows you to create a form that displays multiple records in a datasheet-like format, making it customizable and suitable for viewing multiple entries simultaneously.

Question 13

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 is typically the primary table in a one-to-many relationship and would have a related subform displaying data from the "many" side of the relationship. Therefore, the best choice is D. "Secondary" and "subordinate" imply a lower importance or status than the "main" table, which is not accurate, while "primary" describes the role of the table more accurately.

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

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 tabular layout arranges text box controls in a datasheet format with labels above each column, similar to a table or spreadsheet.

Question 16

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. This provides a clear indication of what data is being displayed in the control for the user. The other options (A, C, and D) are not typically displayed in the label attached to a bound control.

Question 17

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 in a form or report or for a field in a table or query. It can be used to populate a control with a list of values or to limit the choices available in a control. Row Source Type specifies the type of data source, List Items Edit Form specifies the editing form for list items, and Column Heads specifies whether column headings are displayed for a control that is used to display a datasheet or table.

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

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 Form Footer section of the form. The Form Header section is at the top of the form and typically contains titles, logos, or other information about the form. The Details section is where the main data entry and display fields are located. The Form Grid is the underlying structure of the form that helps with the alignment and placement of controls.

Question 19

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 complete control over the placement, size, and formatting of all form elements. It also provides access to advanced settings and features not available in other views or tools. Layout view and the Form Wizard may be quicker options, but they lack the precision and flexibility of Design view. The Split Form Tool only creates a specific type of form layout and may not be suitable for all form designs.

Question 20

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 the result of an expression or calculation on a form. This type of control is bound to a field or fields in the underlying data source and displays a value that is the result of a calculation, such as a sum, average, or concatenation of fields.

Quiz 6: Using Form Tools and Creating Custom Formsmodule

A selected control will display how many sizing handles?

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

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

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

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

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.

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

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

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

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

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.

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 default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

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

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.

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?

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