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

Question 1

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

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

Answer 1

C

Question 2

All of the following are form creation tools EXCEPT:

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

Answer 2

C

Question 3

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.

Answer 3

C

Question 4

Referencing the image above,this form contains a:

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

Question 5

Referencing the image above,this form contains a:

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

Question 6

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 7

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 8

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 9

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

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

Question 10

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 11

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

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

Question 12

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

Question 13

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

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

Question 14

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 15

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 16

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 17

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 18

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

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

Question 19

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 20

The ________ displays data horizontally across the page.

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

Question 21

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 22

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 23

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 24

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 25

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

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

Question 26

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 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 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 29

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 30

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

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

Question 31

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 32

Which of the following is NOT a report view?

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

Question 33

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

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

Question 34

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

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

Question 35

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

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

Question 36

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 37

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 38

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 39

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 40

All of the following are report creation tools EXCEPT:

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

Design view displays a form's data and layout.

Question 48

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

Question 49

Labels and Text Boxes are known as controls.

Question 50

Form tool is the most common tool for creating forms.

Question 51

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

Question 52

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

Question 53

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

Question 54

Form view allows changes to the data and layout.

Question 55

A subform combines two views of the same record source

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 74

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

Question 75

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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