Question 1

The Limit to List property is associated with the ____ control.
A) combo box
B) list box
C) text box
D) menu list

Accepted Answer

The Limit to List property is associated with the combo box control. This property restricts the user's input to only the items listed in the combo box, preventing them from entering any value not predefined in the list.

Question 2

Which control allows you to choose from a list as well as make an entry from the keyboard?
A) Label
B) List box
C) Combo box
D) Command box

Accepted Answer

A combo box allows the user to either select an item from a drop-down list or type in their own value. This is a useful control when you want to provide a set of predefined options, but also allow for custom input.

Question 3

The ____ property determines the layout of a form.
A) Appearance
B) Format
C) Form View
D) Default View

Accepted Answer

The Default View property in a form's design determines how the form is displayed or laid out when it is opened, allowing for customization of the form's presentation and interaction style.

Question 4

In Form Design View, you can press and hold ____ to select multiple controls together.
A) Alt
B) Caps Lock
C) F2
D) Shift

Accepted Answer

Pressing and holding the Shift key allows you to select multiple controls together in Form Design View.

Question 5

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.
A) Home
B) Arrange
C) Design
D) Layout

Accepted Answer

The Align button is found on the Arrange tab on the Ribbon, which makes choice (B) the correct answer. The Home tab contains buttons for basic formatting options like font, color and size but doesn't have any alignment options. The Design tab contains themes, styles, and variants for shaping the overall look of the presentation. The Layout tab contains tools to help with the arrangement of slides, placeholders, and objects on the slide.

Question 6

The ____ determines the underlying table or query for a form.
A) record source
B) attachment property
C) combo box
D) command button

Accepted Answer

The record source property is used to specify the underlying table or query for a form. This is essential for the form to be able to display and manipulate data from the specified source. The attachment property is used for adding attachments to a record, the combo box is a type of control used for making selections from a list, and the command button is a control used for running a specific action or procedure.

Question 7

Which two properties control how a form and subform are linked?
A) Link Child Fields and Link Master Fields
B) Form and Subform
C) Link Form and Link Subform
D) Form Layout and Subform Layout

Accepted Answer

The Link Child Fields property specifies the field or fields in the subform that are related to the fields in the master form specified in the Link Master Fields property. By linking these fields, Access knows how to display related records in the subform when a record is selected in the main form. The other options listed are not valid properties in Access.

Question 8

To reorder the values in a combo box, modify the Sort List property. _________________________

Accepted Answer

The Sort List property allows you to change the order of values in a combo box.

Question 9

In Form Design View, you can press and hold ____ to add more controls to a selection.
A) Alt or Caps Lock
B) F6 or F7
C) F1 or F2
D) Ctrl or Shift

Accepted Answer

In Form Design View, pressing and holding Ctrl or Shift allows you to select multiple controls and add them at once by clicking and dragging or copying and pasting.

Question 10

To add a page to a tab control, right click the page's tab and click Add Page. ____________________​

Accepted Answer

The answer of To add a page to a tab...

Question 11

To modify the number of items displayed in a combo box list, you use the ____ property.
A) Control Source
B) List Rows
C) Limit to List
D) Drop-Down

Accepted Answer

The List Rows property determines the number of items that will be displayed in the combo box list at a given time. By default, it is set to 8 rows, but it can be adjusted to show more or fewer rows depending on the needs of the user. The Control Source property is used to specify the data source for the combo box, while the Limit to List property restricts the user to only selecting items from the predefined list. The Drop-Down property determines whether the combo box will display a drop-down arrow icon to indicate that additional options are available.

Question 12

Which form layout shows each field name as a column heading and each record as a row?
A) Columnar
B) Tabular
C) Chart
D) PivotTable

Accepted Answer

The tabular form layout shows each field name as a column heading and each record as a row, making it the best choice for organizing and presenting data in a table format.

Question 13

The Enabled property specifies whether a control can be edited in Form View. _________________________

Accepted Answer

The Enabled property determines whether a control is available for interaction (e.g., can be clicked or selected) in Form View, not whether it can be edited.

Question 14

Which form layout shows each field on a separate line with a label to its left?
A) Columnar
B) Tabular
C) Datasheet
D) Chart

Accepted Answer

Columnar forms are typically used for inputting data and show each field on a separate line with a label to its left, making it easy for users to understand and fill in the required information.

Question 15

The ____ shows the fields you can add to a form.
A) Property Sheet
B) Field List
C) subform
D) option group

Accepted Answer

The Field List displays a list of available fields that you can add to a form. The other options mentioned (Property Sheet, subform, and option group) are not specifically related to adding fields to a form.

Question 16

The link between a main form and a subform is established through a common ____.
A) record
B) set of records
C) field
D) control

Accepted Answer

The link between a main form and a subform is established through a common field. This field serves as the primary key in the main form and as the foreign key in the subform, allowing for a one-to-many relationship between the two forms.

Question 17

A form ____ is the general way that the data and controls are arranged on the form.
A) view
B) group
C) control
D) layout

Accepted Answer

A layout refers to the physical arrangement of the various controls and data on a form. It defines the position, size, and behavior of each control in relation to the form as a whole. View is a way of looking at a form or report, group refers to a collection of controls or objects that are treated as a unit, and control refers to individual objects on a form such as text boxes or buttons.

Question 18

The combo box gets its values from the list entered in the ____ property.
A) Recordset
B) Limit to List
C) Data List
D) Row Source

Accepted Answer

The values for a combo box are obtained from the Row Source property, which can be set to a table, query, or list of values.

Question 19

To modify the number of items displayed in a combo box, use the List Rows property. _________________________

Accepted Answer

The List Rows property sets the maximum number of items displayed in a combo box.

Question 20

You can modify the Caption property to change the text that appears on the tab in Form View. _________________________

Accepted Answer

The answer of You can modify the Caption property to...

Quiz 7: Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

The Limit to List property is associated with the ____ control.

Which control allows you to choose from a list as well as make an entry from the keyboard?

The ____ property determines the layout of a form.

In Form Design View, you can press and hold ____ to select multiple controls together.

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

The ____ determines the underlying table or query for a form.

Which two properties control how a form and subform are linked?

To reorder the values in a combo box, modify the Sort List property. _________________________

In Form Design View, you can press and hold ____ to add more controls to a selection.

To add a page to a tab control, right click the page's tab and click Add Page. ____________________​

To modify the number of items displayed in a combo box list, you use the ____ property.

Which form layout shows each field name as a column heading and each record as a row?

The Enabled property specifies whether a control can be edited in Form View. _________________________

Which form layout shows each field on a separate line with a label to its left?

The ____ shows the fields you can add to a form.

The link between a main form and a subform is established through a common ____.

A form ____ is the general way that the data and controls are arranged on the form.

The combo box gets its values from the list entered in the ____ property.

To modify the number of items displayed in a combo box, use the List Rows property. _________________________

You can modify the Caption property to change the text that appears on the tab in Form View. _________________________

To add a page to a tab control, right click the page's tab and click Add Page. ____________________