Question 1

The body of the form is in the ____ section.
A) Body
B) Main
C) Detail
D) Record

Accepted Answer

The answer of The body of the form is in...

Question 2

____ shows the form on the screen and allows you to use the form to update data.
A) Layout view
B) Design view
C) Form view
D) Screen view

Accepted Answer

Form view is specifically designed to show the form on the screen and allows users to update or enter data using the form. Layout view shows the form structure and Design view allows editing and designing the form structure. Screen view is not a valid view option in Microsoft Access.

Question 3

To filter records on a form, tap or click the Advanced button on the ____ tab to display the Advanced menu.
A) CREATE
B) FORMAT
C) HOME
D) DATABASE TOOLS

Accepted Answer

The answer of To filter records on a form, tap...

Question 4

In ____ you cannot update the data, but you can make changes to the layout of the form.
A) Layout view
B) Form view
C) Design view
D) Screen view

Accepted Answer

In Layout view, you can adjust the placement and size of fields on a form, but you cannot update the actual data in the fields. In Form view, you can update data in the fields, but not make layout changes. In Design view, you can make both layout and data changes. Screen view is not a valid view option in Microsoft Access.

Question 5

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a(n) ____ report.
A) summary
B) grouped
C) abstract
D) header/footer

Accepted Answer

A summary report only includes the subtotals of the group calculations, and does not show the individual detail lines. Grouped, abstract, and header/footer reports may still include individual detail lines, whereas a summary report focuses solely on the aggregated data.

Question 6

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.
A) Form Wizard
B) More Forms
C) Blank Form
D) Form

Accepted Answer

The question specifically mentions using the Form Wizard to create a form, so the correct answer is A - Form Wizard. B - More Forms, and C - Blank Form are also options in the CREATE tab, but they do not pertain to using the Form Wizard to create a form for a table as specified in the question. Similarly, D - Form is a button that appears in the CREATE tab, but it is not the specific option requested in the question.

Question 7

To clear a current filter, tap or click ____ on the Advanced menu.
A) Toggle Filters
B) Remove Filters
C) Delete Filters
D) Clear All Filters

Accepted Answer

"Clear All Filters" is the option that explicitly states that all filters will be cleared, which is what the question is asking for. The other options (Toggle Filters, Remove Filters, and Delete Filters) do not necessarily imply that all filters will be cleared.

Question 8

To find themes that are not listed in Access but are available for download, tap or click the ____ command.
A) Download Themes
B) Online Themes
C) Browse for Themes
D) Microsoft Access

Accepted Answer

The answer of To find themes that are not listed...

Question 9

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.
A) Advanced Filter/Sort
B) Apply Filter/Sort
C) Query/Sort
D) Filter by Form

Accepted Answer

The Advanced Filter/Sort command on the Advanced menu provides the option to sort records and enter criteria to restrict retrieval. The other options listed on the answer choices do not include both sorting and entering criteria to filter records.

Question 10

To add an additional field to a form, tap or click the ____ button to display a field list.
A) Show Tables
B) Field List
C) Add Existing Fields
D) Add Form Fields

Accepted Answer

The answer of To add an additional field to a...

Question 11

____ allows you to make changes, but it does not show you the actual form.
A) Form view
B) Layout view
C) Design view
D) Screen view

Accepted Answer

Design view is a view in which you can make changes to the form or report but it does not show you the actual form or report. It is used to change the structure, properties, and controls of the form or report.

Question 12

A(n) ____ layout arranges controls horizontally with the labels across the top, typically in the Form Header section.
A) arranged
B) horizontal
C) tabular
D) top aligned

Accepted Answer

The answer of A(n) ____ layout arranges controls horizontally with...

Question 13

The ____ section appears at the top of the form and usually contains the form title.
A) Title
B) Form Header
C) Group Header
D) Form Label

Accepted Answer

The form header is the section at the top of the form that usually contains the form title. The title is typically placed here to provide users with quick identification of the form's purpose. The other options do not accurately describe this section of the form.

Question 14

To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ____ button on the DESIGN tab.
A) Add Title
B) Add Header
C) Title
D) Header

Accepted Answer

The question specifically asks for adding a title, and the option "Title" is provided, making it the best choice. Option A and B both include the word "Add" which implies there is already a title or header present, which may not be the case. Option D only mentions adding a header, which is not the same as a title.

Question 15

To place controls on a form in a stacked layout, select all the controls and tap or click the Stacked button on the ____ tab.
A) DESIGN
B) FORMAT
C) PAGE SETUP
D) ARRANGE

Accepted Answer

The Stacked button is located on the ARRANGE tab in Microsoft Access.

Question 16

To add a date to a form, tap or click the ____ button on the DESIGN tab.
A) Date and Time
B) Date
C) Show Date
D) Add Date

Accepted Answer

The "Date and Time" button on the DESIGN tab is specifically designed to add a date to a form, as it opens a dropdown menu with various date and time formatting options. The other options listed (B, C, D) do not necessarily pertain to adding a date to a form.

Question 17

To create labels using the Label Wizard, tap or click the ____ button on the CREATE tab.
A) Mailing Label
B) More Wizards
C) Mailing Label Wizard
D) Labels

Accepted Answer

The Labels button on the CREATE tab is the best choice to access the Label Wizard.

Question 18

A(n) ____ layout arranges controls vertically with the labels to the left of the control.
A) arranged
B) stacked
C) formatted
D) vertical

Accepted Answer

A stacked layout is a type of layout where controls are arranged vertically with labels to the left. This layout is commonly used for forms and input fields. The other options do not accurately describe this type of layout.

Question 19

The ____ section appears at the bottom of the form and often is empty.
A) Form Footer
B) Totals
C) Page Footer
D) Grand Totals

Accepted Answer

The answer of The ____ section appears at the bottom...

Question 20

A ____ consists of a selection of colors and fonts for the various sections in a report or form.
A) template
B) style
C) theme
D) persona

Accepted Answer

A theme consists of a selection of colors and fonts for the various sections in a report or form. A template refers to a pre-designed format for a document, a style refers to the way text or graphics are formatted, and a persona is a fictional representation of a user that is used in design and development processes.

Quiz 1: Access: Creating Reports and Forms

The body of the form is in the ____ section.

____ shows the form on the screen and allows you to use the form to update data.

To filter records on a form, tap or click the Advanced button on the ____ tab to display the Advanced menu.

In ____ you cannot update the data, but you can make changes to the layout of the form.

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a(n) ____ report.

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.

To clear a current filter, tap or click ____ on the Advanced menu.

To find themes that are not listed in Access but are available for download, tap or click the ____ command.

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

To add an additional field to a form, tap or click the ____ button to display a field list.

____ allows you to make changes, but it does not show you the actual form.

A(n) ____ layout arranges controls horizontally with the labels across the top, typically in the Form Header section.

The ____ section appears at the top of the form and usually contains the form title.

To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ____ button on the DESIGN tab.

To place controls on a form in a stacked layout, select all the controls and tap or click the Stacked button on the ____ tab.

To add a date to a form, tap or click the ____ button on the DESIGN tab.

To create labels using the Label Wizard, tap or click the ____ button on the CREATE tab.

A(n) ____ layout arranges controls vertically with the labels to the left of the control.

The ____ section appears at the bottom of the form and often is empty.

A ____ consists of a selection of colors and fonts for the various sections in a report or form.