Deck 4: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Question 1

When in Layout or Design view, which of the follow is NOT a form layout tab?

A) Design
B) Edit
C) Layout
D) Format

Answer 1

B

Question 2

Referencing the image above, this form contains a:

A) split Form.
B) multiple Items Form.
C) macro Form.
D) subform.

Answer 2

A

Question 3

The ________ view is used to add, edit, and delete data in a form, but it cannot be used to change the layout and design of the form.

A) Insert
B) Edit
C) Modify
D) Form

Answer 3

D

Question 4

The ________ view allows alterations to the form design while still viewing the data.

A) Data
B) Design
C) Layout
D) Form

Question 5

Text boxes, buttons, and boxes are examples of ________, which can be used to add, edit, and display data in a form or report.

A) placeholders
B) controls
C) containers
D) records

Question 6

The ________ displays data horizontally across the page.

A) Stacked Layout
B) Design View
C) Tabular Layout
D) Layout

Question 7

The form Layout view can be used for all of the following EXCEPT:

A) adding or removing a field.
B) changing the order of fields.
C) adding a calculated field.
D) changing the width of a field.

Question 8

Referencing the image above, this form contains a:

A) miniform.
B) subform.
C) macroform.
D) split form.

Question 9

When you use the Split Form tool, the ________ views are synchronized with each other at all times.

A) Form and Layout
B) Layout and Design
C) Form and Datasheet
D) Design and Datasheet

Question 10

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

A) Stacked Layout
B) Layout View
C) Tabular Layout
D) Print Preview

Question 11

The ________ displays form fields in vertical column, and displays one record at a time.

A) Stacked Layout
B) Layout View
C) Tabular Layout
D) Print Preview

Question 12

The table or query that supplies underlying data to a form or report is called the:

A) information source.
B) record source.
C) data source.
D) object source.

Question 13

Which of the following statements accurately describes a split form?

A) Split forms combine two different views of two different record sources
B) A Split form is a type of subform
C) You cannot edit records in a Split form
D) Split forms combine two different views of the same record source

Question 14

A ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

A) multiple Items form
B) subform
C) split form
D) datasheet form

Question 15

All of the following are form creation tools EXCEPT:

A) Form Design.
B) Form Wizard.
C) Form Layout.
D) Blank Form.

Question 16

Referencing the image above, this form is shown in ________ view.

A) Format
B) Form
C) Design
D) Layout

Question 17

What type of form displays records in a tabular layout similar to a table's Datasheet view but has more editing options, such as adding graphics and buttons, than a datasheet?

A) split Form
B) multiple Items Form
C) subform
D) compound form

Question 18

Which of the following is NOT a view when working with forms?

A) Form
B) Layout
C) Design
D) Tabular

Question 19

Which form view would be used to perform advanced layout adjustments?

A) Design
B) Layout
C) Form
D) Detail

Question 20

What type of control is used to help keep controls aligned horizontally and vertically, giving forms a uniform appearance?

A) Bounded
B) Layout
C) Unbounded
D) Calculated

Question 21

If you need to sort the records contained in a report, you can do so from either the Design view or the ________ of the report.

A) Sort View
B) Layout View
C) Print preview
D) Report view

Question 22

Which of the following is NOT a report view?

A) Design view
B) Print Preview
C) Format view
D) Layout view

Question 23

When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.

A) the Report Wizard
B) a Blank Report
C) Report Design
D) Report

Question 24

________ view allows alteration of the report design while viewing the data.

A) Report
B) Output
C) Layout
D) Design

Question 25

To apply a theme, you click Themes in the:

A) Themes group on the FORMAT tab.
B) Arrange group on the FORMAT tab.
C) Themes group on the DESIGN tab.
D) Arrange group on the DESIGN tab.

Question 26

To sort the order of records in a form, you need to open the form in:

A) Tabular View.
B) Form View.
C) Design View.
D) Print Preview.

Question 27

A ________ is a defined set of colors, fonts, and graphics that can be applied to a form or report.

A) prototype
B) style
C) theme
D) template

Question 28

To apply a background image to a file, click Background in the:

A) Background group on the FORMAT tab.
B) Picture group on the FORMAT tab.
C) Background group on the DESIGN tab.
D) Picture group on the DESIGN tab.

Question 29

The ________ is a file type that was created for exchanging documents independent of software applications and operating systems.

A) ACCDB
B) PDF
C) DOCX
D) MDB

Question 30

To add a field to a report, click Add Existing Fields in the:

A) Tools group on the DESIGN tab.
B) Tools group on the FORMAT tab.
C) Fields group on the DESIGN tab.
D) Fields group on the FORMAT tab.

Question 31

When working with forms, the Remove Layout option only appears in ________ view.

A) Design
B) Layout
C) Form
D) Control

Question 32

The ________Wizard is used to easily create name tags and other specialized tags.

A) Letter
B) Specialty
C) Label
D) Tag

Question 33

All of the following are report creation tools EXCEPT:

A) Report Design.
B) Report Wizard.
C) Report Layout.
D) Blank Report.

Question 34

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

A) Format view
B) Print Preview
C) Design view
D) Report view

Question 35

To modify a report, the Arrange tab is displayed in both the ________ views.

A) Layout and Report
B) Layout and Design
C) Format and Design
D) Report and Design

Question 36

In Form view, to sort a field containing names from A to Z, click Ascending in the:

A) Arrange group on the HOME tab.
B) Sort & Filter group on the HOME tab.
C) Arrange group on the DATABASE TOOLS tab.
D) Sort & Filter group on the DATABASE TOOLS tab.

Question 37

A ________ is a document that displays database information in a meaningful format.

A) form
B) report
C) table
D) query

Question 38

To sort fields in a report, click Group & Sort in the:

A) Fields group on the DESIGN tab.
B) Grouping & Totals group on the DESIGN tab.
C) Fields group on the CREATE tab.
D) Grouping & Totals group on the CREATE tab.

Question 39

A ________report is a specialized report that comes preformatted to coordinate with products such as those manufactured by Avery.

A) rapid distribution
B) mass distribution
C) value added
D) mailing label

Question 40

To add a calculated field to a report, you would use________ view.

A) Calculator
B) Report
C) Layout
D) Design

Question 41

The Report Wizard tool is used by advanced users who want to create a blank report with no help from Access.

Question 42

The Report Wizard can be used to group fields in a report.

Question 43

The first step in planning a report is to identify the record source.

Question 44

Layout view allows alterations to the form design while still viewing the data.

Question 45

Report view allows a report to be viewed onscreen in a continuous page layout.

Question 46

Form tool is the most common tool for creating forms.

Question 47

A report is a document used to distribute meaningful information in printed form, on a computer screen, or saved to a file.

Question 48

Form view is used to change a form's data and layout.

Question 49

Access can be used to create forms that match paper forms.

Question 50

A subform combines two views of the same record source

Question 51

Labels and Text Boxes are known as controls.

Question 52

Report tool creates a tabular report based on the selected table or query.

Question 53

To arrange the state field on a form in alphabetical order, you would use a descending sort.

Question 54

You would use the Modal Dialog Form tool to create a dialog box.

Question 55

The Tag Wizard is used create name tags and other specialized tags.

Question 56

The Remove Layout command is only available when using Layout view.

Question 57

Design view can be used to alter the report design while still viewing the data.

Question 58

A theme can be applied to a single form or to all the forms in a database.

Question 59

Form view allows changes to the data and layout.

Question 60

Design view displays a form's data and layout.

Question 61

When in Layout view, the Group, Sort, and Total pane is used to change the sorting in a report.

Question 62

Print Preview is used to see exactly what the report will look like when it is printed.

Question 63

Match each Form tool with its function:
I. Blank Form
II. Form Design
III. Split Form
IV. Form Wizard
V. Form
A. Creates a two-part form with a stacked and a tabular layouts
B. Creates a custom form based on questions you answer
C. Creates a form in a stacked layout displaying all record source fields
D. Creates an empty form in Layout view
E. Creates an Empty form in Design view

Question 64

A theme can be applied to a report in either Layout or Report views.

Question 65

The Format tab contains commands to change the font, display, and alignment of the controls on a report.

Question 66

Match each term to its meaning:
I. Theme
II. Form
III. Record Source
IV. Report
V. Wizard
A. Asks a series of questions and designs a custom form or report
B. Underlying table or query that provides the fields for a form
C. Document displaying database information in a format meaningful to its readers
D. Used to add data into or edit data in a table
E. Defined set of colors, fonts, and graphics

Question 67

The table or query that supplies the underlying data for a form or report is called the ________ or data source.

Question 68

To add a field to a report using the Add Existing Fields button, you must be in Design view.

Question 69

A(n) ________ layout displays form fields in vertical columns.

Question 70

Match each Report tool with its function:
I. Report
II. Report Design
III. Blank Report
IV. Report Wizard
V. Labels
A. Uses preformatted label templates
B. Creates a custom report based on questions you answer
C. Creates a tabular report showing all of the fields in the record source
D. Creates an a new blank report in Layout view
E. Creates an new blank report in Design view

Question 71

To create a form, you click Form in the Forms group on the ________ tab.

Question 72

You would use a(n)________ to add data into or edit data in a table.

Question 73

The width of a field in a report can be changed in either Report or Design views.

Question 74

To sort fields in a report, you begin by clicking Group & Sort in the Group & Sort group on the DESIGN tab.

Question 75

A field can be deleted from a report in either Layout or Design views.

Question 76

Match each view to its definition:
I. Report
II. Layout
III. Form
IV. Design
V. Print Preview
A. Primarily used for data entry
B. Allows advanced features to be applied
C. Displays a report onscreen in a continuous page layout
D. Used to view a report prior to printing
E. Allows form or report design to be altered while still viewing the data

Question 77

The ________ source is also referred to as the data source.

Question 78

ACCDB is a file type used to exchange documents independent of software applications and operating systems.

Question 79

Text boxes, buttons, and boxes are examples of form ________.

Question 80

A(n) ________ layout displays fields horizontally across a form.