Question 1

If you want users to view a form but not make any changes to its data,you would use a ________ form.&#10;A)protected&#10;B)locked&#10;C)secure&#10;D)read-only

Accepted Answer

A read-only form allows users to view the data but not edit, delete, or add any information. This can be useful when sharing information with others but wanting to maintain the integrity of the original data.  A protected or secure form suggests that the information is private and may require a password or permission to access. A locked form typically means that the form is unable to be edited or changed in any way, which would prevent users from being able to view the form altogether.

Question 2

A locked form displays data but does not allow any changes to the data.

Accepted Answer

False

Question 3

Sections can be used in reports but not in forms.

Accepted Answer

Sections can be used in forms to divide and organize fields.

Question 4

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.&#10;A)Changes dialog box&#10;B)Property Sheet&#10;C)Protection dialog box&#10;D)Attributes Sheet

Accepted Answer

The Property Sheet is where you can find the settings for Allow Additions, Allow Deletions, and Allow Edits. By selecting No for all three options, it will prevent any changes from being made to the form. The Changes dialog box, Protection dialog box, and Attributes Sheet do not have these specific settings.

Question 5

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

Accepted Answer

A combo box is indeed used to display a drop-down menu with multiple options, from which users can pick only one option.

Question 6

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.&#10;A)selection&#10;B)check&#10;C)list&#10;D)combo

Accepted Answer

A combo box allows the user to choose from a dropdown list of options, making it the best choice for displaying a list of customer satisfaction options. Selection and check boxes are better suited for yes/no or multiple option choices, while a list box would display all the options at once and require the user to scroll through them.

Question 7

You can adjust the tab order to control the advancement from one field or control to the next.

Accepted Answer

This statement is true. In most software applications, the order in which fields or controls are accessed by the user is determined by the tab order. This can usually be adjusted by the designer or developer to ensure a logical and efficient flow for the user.

Question 8

By using a ________,you can create a form that displays records from two related tables.&#10;A)linked form&#10;B)subordinate form&#10;C)subform&#10;D)mini-form

Accepted Answer

A subform can display records from two related tables by allowing the user to view related records in a single form. The subform is commonly used to display fields that are not in the main form but are linked to that form.

Question 9

Advanced controls can be used in forms but not in reports.

Accepted Answer

This statement is incorrect. Advanced controls can be used in both forms and reports in Microsoft Access. Some examples of advanced controls are combo boxes, option groups, and subforms.

Question 10

Form headers or report footers are examples of form or report ________.&#10;A)subdivisions&#10;B)divisions&#10;C)segments&#10;D)sections

Accepted Answer

Form headers or report footers are typically separate sections of a form or report that are used to provide additional context or information. These sections are often referred to as report or form sections or simply as sections. Therefore, the best choice is D, sections.

Question 11

The expression IIf(IsNull([ClosedDate]),&#34;Open&#34;,&#34;Closed&#34;)displays ________.&#10;A)Closed when the ClosedDate field has no value and Open otherwise&#10;B)Open when the ClosedDate field has no value and Closed otherwise&#10;C)Closed when the ClosedDate field has no value and nothing otherwise&#10;D)Open when the ClosedDate field has no value and nothing otherwise

Accepted Answer

The answer of The expression IIf(IsNull([ClosedDate]),&#34;Open&#34;,&#34;Closed&#34;)displays ________.&#10;A)Closed when the ClosedDate...

Question 12

A text box can be converted into a combo box.

Accepted Answer

The answer of A text box can be converted into...

Deck 24: Advanced Forms and Reports: Hands On Exercise Videos