Question 1

A ________ is a form that enables users to view but not change data.
A) read-only form
B) data entry form
C) sub form
D) split form

Accepted Answer

A read-only form allows users to view data but not make any changes to it. Data entry forms, on the other hand, allow users to input and edit data. Sub forms and split forms are not necessarily limited to read-only access and can be used for data input and editing as well.

Question 2

Which view do you use to modify lines or rectangles?
A) Design view
B) Layout view
C) Datasheet view
D) Form or Report view

Accepted Answer

A

Question 3

On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?
A) Combo box
B) Calculated
C) Unbound
D) Bound

Accepted Answer

A combo box provides a drop-down menu displaying a list of options from which the user can choose a single value.

Question 4

When are subforms created?
A) When the main form displays records from a related table
B) When two fields are next to each other in a table
C) When you have an autonumber field as the primary key
D) It can only be created when the form is created

Accepted Answer

Subforms are created when the main form displays records from a related table. This allows for the display of related records in a separate, sub-form within the main form.

Question 5

A(n) ________ is a control that is connected to a field in a table or query.
A) bound control
B) unbound control
C) calculated control
D) combo box control

Accepted Answer

A bound control is connected to a field in a table or query and displays data from that field. It is bound to the field and automatically updates when the data in the field changes. Unbound controls do not have a direct connection to a field and are used for displaying calculated values or accepting user input that is not directly stored in a table. Calculated controls are used for performing calculations on data in other fields or controls. Combo box controls are used for selecting a value from a list of options.

Question 6

Which of the following is an alternative to a combo box?
A) Add a data validation rule
B) Key in the field
C) Set a tab order
D) Make it a required field

Accepted Answer

Adding a data validation rule can limit the options that can be entered in a field, similar to a combo box, but without the drop-down list. This can be a valid alternative if a combo box is not preferred. The other options listed do not provide an alternative to a combo box.

Question 7

Sum, Min, Max, and Average are examples of which kind of functions?
A) Aggregate functions
B) Constant functions
C) Control functions
D) Bound functions

Accepted Answer

Sum, Min, Max, and Average are all examples of aggregate functions, which are used to summarize or manipulate large amounts of data. They calculate a single value based on a set of input values, such as the sum of all numbers in a range or the average of a set of values.

Question 8

Which of the following controls contains to decorative elements, such as the title of the report?
A) Unbound
B) Bound
C) Calculated
D) Rectangle and line

Accepted Answer

The answer of Which of the following controls contains to...

Question 9

When would a calculated field need to be added to a form or report?
A) When a formula is needed in the form or report
B) When you want to add some explanatory text to the form or report
C) When using an unbound control in the form or report
D) When using a bound control in the form or report

Accepted Answer

A calculated field is needed when a formula is needed in the form or report. This allows for calculations to be performed based on the data entered into other fields, providing more comprehensive information.

Question 10

Calculated controls begin with a(n):
A) equal sign (=).
B) plus sign (+).
C) pound sign (#).
D) bracket ([ ]).

Accepted Answer

Calculated controls begin with an equal sign (=), indicating that the control is a calculation based on the values of other controls on the form.

Question 11

Which view gives a designer a higher level of control when creating forms and/or reports?
A) Design view
B) Layout view
C) Datasheet view
D) Form or Report view

Accepted Answer

Design view provides a designer with a higher level of control as it allows them to manipulate and customize all aspects of the form or report, including the layout, formatting, and data sources. Layout view and Form/Report view have limitations in terms of customization, while Datasheet view is primarily used for working with tables and datasheets.

Question 12

Which of the following is NOT used when laying out forms and reports?
A) Changing the Allow Edits property to No
B) Controls not bound to specific fields
C) Controls that change each time a new record is displayed
D) Lines, pictures, and other non-data-related elements

Accepted Answer

Changing the Allow Edits property to No is not related to the layout of forms and reports, but rather controls whether users can edit the data in the form or report. The other options are all related to the layout, such as the use of controls, displaying data for each record, and non-data elements like lines and pictures.

Question 13

Which of the following fields is an example of a field that would not require a tab stop?
A) Calculated field
B) Last Name field
C) Address field
D) State field

Accepted Answer

A calculated field does not require user input and therefore does not need a tab stop. The other fields listed require user input and should have tab stops to efficiently navigate the form.

Question 14

What should be done before converting a text box to a combo box?
A) Create a new table and enter the values for the option list
B) Set a default value to appear on the form
C) Check the tab order of the form
D) Switch to Form view and attempt to change the data in the first record

Accepted Answer

Before converting a text box to a combo box, a new table should be created and the values for the option list should be entered into it. This table will serve as the source for the combo box options. Additionally, any necessary relationships between this table and other tables in the database should be defined.

Question 15

What are two options for adding emphasis to your form or report?
A) Line or rectangle control
B) Rectangle or calculated control
C) Unbound or rectangle control
D) Bound or unbound control

Accepted Answer

A line or rectangle control can be used to draw attention to specific sections or headings in a form or report. This helps to break up the content and make it easier to read and understand. Additionally, using bold or colored text can also add emphasis to important information within the form or report.

Question 16

A(n) ________ is text not tied to a specific field.
A) label
B) text box
C) calculated control
D) control box

Accepted Answer

A label is a text element in user interfaces that is not tied to a specific field; it's used to display static text such as titles, captions, or brief instructions.

Question 17

Which type of control does a lookup field become in a form?
A) Combo box control
B) Bound control
C) Calculated control
D) Unbound control

Accepted Answer

A lookup field becomes a combo box control in a form. A combo box control allows the user to select from a list of predefined values.

Question 18

The ________ is the sequential advancing in a form from one field to the next.
A) tab order
B) bound control
C) unbound control
D) calculated control

Accepted Answer

Tab order defines the order in which focus moves from one control to the next as the user tabs through the form.

Question 19

Where would you go to change tab order in a form?
A) Design view - Tab order in Tools group
B) Property sheet
C) Datasheet view - Tab order in Tools group
D) Detail section

Accepted Answer

To change tab order in a form, you need to go to Design view and look for the Tab Order option in the Tools group of the Ribbon. This allows you to select the order in which users will navigate through the form fields when using the Tab key.

Question 20

A(n) ________ contains an expression that generates a calculated result.
A) calculated control
B) rectangle control
C) bound control
D) unbound control

Accepted Answer

A calculated control contains an expression that generates a calculated result, based on the data and other controls on a form or report. This type of control is useful when you need to perform calculations that are not directly tied to data in a database.

Quiz 7: Advanced Forms and Reports: Moving Beyond the Basics

A ________ is a form that enables users to view but not change data.

Which view do you use to modify lines or rectangles?

On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

When are subforms created?

A(n) ________ is a control that is connected to a field in a table or query.

Which of the following is an alternative to a combo box?

Sum, Min, Max, and Average are examples of which kind of functions?

Which of the following controls contains to decorative elements, such as the title of the report?

When would a calculated field need to be added to a form or report?

Calculated controls begin with a(n) :

Which view gives a designer a higher level of control when creating forms and/or reports?

Which of the following is NOT used when laying out forms and reports?

Which of the following fields is an example of a field that would not require a tab stop?

What should be done before converting a text box to a combo box?

What are two options for adding emphasis to your form or report?

A(n) ________ is text not tied to a specific field.

Which type of control does a lookup field become in a form?

The ________ is the sequential advancing in a form from one field to the next.

Where would you go to change tab order in a form?

A(n) ________ contains an expression that generates a calculated result.