Question 1

Match the following form tools with their description:
I. Form
II. Form Design
III. Split Form
IV. Datasheet
V. Switchboard
A. Immediately creates a blank form with a stacked layout
B. Immediately creates a blank form in Design view
C. Creates a form that looks like a table in its normal view
D. Includes a stacked layout and a tabular layout in two different sections of the form
E. This is not an Access Form tool.

Accepted Answer

The answer of Match the following form tools with their...

Question 2

The default sort order for a table is by its primary key.

Accepted Answer

By default, tables are sorted by their primary key, unless otherwise specified.

Question 3

Match the following terms with their description:
I. Form view
II. Design view
III. Layout view
IV. Views group
V. Print preview
A. Used to make advanced changes to a form
B. Often keeps you from wasting paper
C. Enables changes while viewing actual data
D. Used for data entry
E. Found on the Home tab

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 4

Match the following terms with their description:
I. Form
II. Application Parts
III. Record source
IV. Stacked layout
V. Tabular layout
A. Used to build database objects
B. Fields are displayed in a vertical column
C. Fields are displayed in horizontal columns
D. A user-friendly interface
E. Supplies the records for a form or report

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 5

Data cannot be changed in Report view.

Accepted Answer

In Report view, data can only be viewed but cannot be modified or changed.  It is a read-only view for the user. Report view is a read-only view of the data and does not allow any changes to be made.

Question 6

If you want to resize just a few controls on a form they must be removed from the Layout control.

Accepted Answer

This is true. Controls that are part of a Layout control are automatically resized based on the layout rules, so individual resizing of those controls is not possible without first removing them from the Layout control. Controls within a Layout control are automatically resized when the form is resized. So, if you want to resize a few controls individually, you need to take them out of the Layout control.

Question 7

Match the following terms with their description:
I. Split form
II. Multiple items form
III. Property sheet
IV. Sub form
V. Dual Record form
A. Controls the behavior of the form
B. Displays related records
C. Two views of the same record source
D. Not available in Access
E. More than one record is displayed.

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 8

Match the following terms with the group in which they are found on the Create tab:
I. Form Design
II. Module
III. Application Parts
IV. Query Design
V. SharePoint Lists
A. Queries
B. Forms
C. Macros & Code
D. Templates
E. Tables

Accepted Answer

The answer of Match the following terms with the group...

Question 9

Match the following terms with their description:
I. Control
II. Theme
III. Form
IV. Report
V. Record Source
A. Helpful way of displaying data from multiple records
B. A consistent set of colors and other formatting which can be applied to a report or form
C. Used to display data in a form or report
D. Main data entry object
E. Determines what data can display in a form or report

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 10

Match the following terms with their description:
I. Label Wizard
II. Form Wizard
III. Report Wizard
IV. SubForm Wizard
V. SubReport Wizard
A. Simplified way to create forms
B. Simplified way to create subforms
C. Simplified way to create reports
D. Used to create name tags
E. This does not exist in Access.

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 11

Match the following groups with the tabs on which they are found:
I. Tables
II. Find
III. Themes
IV. Print
V. Rows & Columns
A. Design
B. Print Preview
C. Create
D. Arrange
E. Home

Accepted Answer

The answer of Match the following groups with the tabs...

Question 12

The sort order in a report's source overrides any sort order applied to the report.

Accepted Answer

The sort order applied directly to the report overrides the sort order in the report's source, allowing for customized presentation of data.

Question 13

You can edit data in form layout view.

Accepted Answer

The answer of You can edit data in form layout...

Question 14

Match the following terms with their description:
I. Report Layout Control
II. Form controls
III. Controls
IV. Control Wizard
V. Text controls
A. Used to keep a uniform look on a form
B. This does not exist in Access.
C. Used to display values
D. Items such as labels and text boxes
E. Used to keep a uniform look on a report

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 15

If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

Accepted Answer

The answer of If a field is found in a...

Question 16

Just as with forms, you can add, edit, or delete data in a report.

Accepted Answer

Reports in database systems are primarily used for viewing and formatting data, not for editing or deleting data. Editing or deleting data is typically done through forms or directly in the tables.

Question 17

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

Accepted Answer

The answer of If a sort has been added to...

Question 18

Mailing labels are considered reports in Access 2016.

Accepted Answer

The answer of Mailing labels are considered reports in Access...

Question 19

Database designers can disable all but the form view to protect the form's design and layout.

Accepted Answer

This is true, database designers can disable all but the form view to protect the form's design and layout. This can be done in Microsoft Access by going to the form's properties and selecting "Allow Design Changes" and "Allow Layout View." By unchecking these options, users will only be able to view the form, but not make any changes to its design or layout. This is true. Database designers can disable other views like Datasheet and Layout to protect the form's design and layout.

Question 20

Match the following terms with their description:
I. Subform
II. Subreport
III. Subquery
IV. Datasheet format
V. SubForm Wizard
A. Provides an easy way to add a subform to form
B. This does not exist in Access.
C. Displays data in a grid like Excel
D. Displays related record on a form
E. Displays related records on a report

Accepted Answer

The answer of Match the following terms with their description:
I....

Quiz 4: Creating and Using Professional Forms and Reports

The default sort order for a table is by its primary key.

Data cannot be changed in Report view.

If you want to resize just a few controls on a form they must be removed from the Layout control.

Match the following terms with the group in which they are found on the Create tab: I. Form Design II. Module III. Application Parts IV. Query Design V. SharePoint Lists A. Queries B. Forms C. Macros & Code D. Templates E. Tables

Match the following groups with the tabs on which they are found: I. Tables II. Find III. Themes IV. Print V. Rows & Columns A. Design B. Print Preview C. Create D. Arrange E. Home

The sort order in a report's source overrides any sort order applied to the report.

You can edit data in form layout view.

If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

Just as with forms, you can add, edit, or delete data in a report.

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

Mailing labels are considered reports in Access 2016.

Database designers can disable all but the form view to protect the form's design and layout.