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

Question 1

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

Answer 1

D

Question 2

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

Answer 2

A

Question 3

Referencing the image above,this form contains a:

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

Answer 3

A

Question 4

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

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

Question 5

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 6

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 7

The ________ displays data horizontally across the page.

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

Question 8

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

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

Question 9

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 10

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 11

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

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

Question 12

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 13

All of the following are form creation tools EXCEPT:

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

Question 14

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

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

Question 15

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 16

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 17

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 18

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 19

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 20

Referencing the image above,this form contains a:

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

Question 21

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 22

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 23

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 24

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

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

Question 25

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

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

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

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 28

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

All of the following are report creation tools EXCEPT:

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

Question 33

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 34

Which of the following is NOT a report view?

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

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

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

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

Question 38

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 39

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 40

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

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

Question 41

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

Question 42

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

Question 43

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

Question 44

Labels and Text Boxes are known as controls.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

Form view allows changes to the data and layout.

Question 54

Form tool is the most common tool for creating forms.

Question 55

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

Question 56

Design view displays a form's data and layout.

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

A subform combines two views of the same record source

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

________ view allows a background image to be added to a form

Question 78

When viewing a form in Form view,you see that the records are displayed in order based on the primary key field.You prefer to temporarily view the records in alphabetical order by last names.Explain how to change the form to display records using the last name field,and how to return the form to display records in primary key order.

Question 79

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Question 80

The Arrange tab displays in both Layout and ________ views.