Deck 9: Workshop 9: Advanced Reports and Mailing Labels

Question 1

To add a field,you add a field from the ________.This adds both the bound control and a Label control containing the field's caption.

A)Field List
B)Property Sheet
C)Field properties
D)Field sheet

Answer 1

A

Question 2

The duplicate values can be hidden using the ________.

A)Layout view
B)characteristics
C)property sheet
D)controls property

Answer 2

C

Question 3

The Report Wizard ________ functions can be helpful to create simple calculations on a report,but sometimes they do not or cannot complete the calculations the way you want.

A)SUM
B)calculated fields
C)summary
D)totals

Answer 3

C

Question 4

Which of the following is NOT true about using the Group,Sort,and Total Pane?

A)You can add,delete,or change the grouping and sort options manually on an existing report without having to use the Report Wizard.
B)A line or other shape can be added to a report in order to highlight different controls.
C)When you create a report using the Report Wizard,one of the steps asks you how you want to group the report and another asks how you want to sort the report.
D)When you create groups and totals,calculated fields are often added to the report with a label.

Question 5

By default,two controls shown in the ________ are the current date using the Now function,and a calculated control representing the page number for this page.

A)Page Footer
B)Page Header
C)Report Footer
D)Report Header

Question 6

The ________ is shown if you choose summary options in the Report Wizard.

A)Page Header
B)Page Footer
C)Report Header
D)Report Footer

Question 7

Which of the following is NOT true regarding report views?

A)Report view shows how the report will look in a continuous page layout.
B)Print Preview shows how the report will look on the printed page.
C)Design view shows the report design and the data.
D)Layout view shows the report and the data.

Question 8

When you create a report using the ________,one of the steps asks you how you want to group the report and another asks how you want to sort the report.

A)Report Wizard
B)Report tool
C)Blank Report tool
D)Report Design tool

Question 9

The ________ lets you control how information is sorted and grouped in a report.

A)Field List
B)Group,Sort,and Total pane
C)Property Sheet
D)Totals pane

Question 10

Which of the following is NOT true about adding labels and shapes to a report?

A)A line or other shape can be added to a report in order to highlight different controls.
B)A line is a bound control that can be moved and resized like any other control on the report.
C)When Access adds a field to a report without a label,it is good practice to add a label manually so the user of the report knows what he or she is looking at.
D)When you create groups and totals,calculated fields are often added to the report without a label.

Question 11

In Design view,the ________ bar is labeled with the primary key of the record that the report was grouped by.

A)Page Header
B)Report Header
C)Detail area
D)Group Header

Question 12

A(n)________ control is a control that contains descriptive information,typically a field name.

A)label
B)bound
C)unbound
D)calculated

Question 13

A ________ is a value that can be changed each time you run the query.

A)parameter
B)condition
C)prompt
D)criterion

Question 14

If you add a logo or date and time,they appear in the ________.

A)Page Header
B)Report Header
C)Group Header
D)Group Footer

Question 15

Which of the following is NOT true regarding reports with subtotals and totals?

A)When you are creating a report with a wizard,sums,averages,minimums,and maximums are available as standard summations.
B)One common use of grouping is to use one-to-many relationships in your database.
C)Reports have a grouping feature allowing records to be presented in sets.
D)In Layout view,you can build more complex formulas.

Question 16

The default information contained in the ________ is the column headers,which are taken from the captions from the table design.

A)Report Header
B)Report Footer
C)Page Header
D)Page Footer

Question 17

Which of the following is NOT true regarding reports?

A)The source of data for a report must be a query.
B)A report provides data in an easy-to-read format suitable for printing.
C)Reports are used for providing professional-looking printed output from a database.
D)A report is designed to fit well on the printed page,with breaks built in for each page.

Question 18

The ________ selects the fields you want and formats the report with headers and footers for grouping.

A)Layout view
B)Design view
C)Combo Box Wizard
D)Report Wizard

Question 19

The ________ shows the fields from the underlying record source.

A)Group Footer
B)Page Header
C)Detail area
D)Report Header

Question 20

The Group Footer is shown if you choose ________ options in the Report Wizard.

A)groups
B)summary
C)totals
D)Group Header

Question 21

Which of the following is NOT true regarding previewing your reports before you print?

A)it is a good idea to preview it before you print it or send it in PDF form to someone else to ensure the formatting is what you expected.
B)It is a good idea to preview the report before you print it or send it in PDF form to someone else to ensure the formatting is what you expected.
C)In Print Preview,the labels may not look the way they will look when you print them.
D)On mailing labels,it is common for the address to not quite fit into the label.

Question 22

Access has a ________ report that can be used for mailing labels,name tags,or other types of labels.

A)customized
B)specialized
C)merged
D)summarized

Question 23

Which of the following is NOT true about conditional formatting?

A)The Conditional Formatting Rules Manager dialog box is used to set conditional formatting conditions.
B)The Conditional Formatting Rules Manager dialog box can be accessed in Layout or Datasheet view.
C)Comparisons can be based on the value of the control or on a calculation that includes other values.
D)Comparisons can compare a value to the value in other records.

Question 24

Reports are used for providing professional-looking printed output from a database.

Question 25

________ formats a control based on one or more comparisons to a set rule set.

A)The Property Sheet
B)Field formatting
C)Conditional formatting
D)Control formatting

Question 26

If a report has multiple pages,the Layout view shows the report as one continuous layout without individual page headers or footers.

Question 27

Layout view is ideal for making changes where seeing the data as you make the change would be useful.

Question 28

Any aspect of the report design can be changed in Layout view.

Question 29

Report view allows you to change the page layout such as from landscape to portrait view,or to change margins.

Question 30

Which of the following views is NOT available for mailing labels?

A)PivotTable
B)Print Preview
C)Report
D)Layout

Question 31

Some of the report design,such as column widths and fonts,can be changed in Design view.

Question 32

A(n)________ can be helpful as an input tool for parameter reports.

A)control
B)bound form
C)unbound form
D)condition

Question 33

Which of the following is NOT true about creating mailing labels?

A)Since mailing labels are actually reports,they have the four views that all reports have.
B)In Print Preview,the labels look the way they will look when you print them.
C)Access has a specialized report that can be used for mailing labels,name tags,or other types of labels.
D)You can only create labels based on data in queries.

Question 34

Which of the following is NOT true about reports based on queries?

A)A macro should be created to run a query and then a report.
B)When a report is based on a table with records,you can run the report and there will always be records in the report because there are always records in the table.
C)A query does not store any records,so if a report is run on a query with no records,the report will have no records.
D)Instructions should always be provided so the user knows what steps to take to successfully run a query or report.

Question 35

Reports provide ways to report on data by groups,such as by each customer or product.

Question 36

Reports cannot be created with the same controls that are available in forms.

Question 37

Which of the following is NOT true regarding running and modifying reports from parameter queries?

A)Because reports are designed to be displayed on a monitor,that means that after time it might not be easy to recall what parameter value was used to run that particular report.
B)Once a form is created and the query points to the form,the report and query should only be run from the form.
C)When reports are built from parameter queries,running the report yields different results depending on the parameter values entered.
D)You can add the parameter values to the report header so that the parameters can be easily identified.

Question 38

Which of the following is NOT true regarding reports that are built from parameter queries?

A)Running the report can display different results depending on the parameter values that were entered.
B)Reports can be created from parameter queries to have flexibility.
C)It is a good idea to add the parameter to the report header so that the parameters can be identified when the report is printed.
D)Access stores the parameter values that have been entered so it is easy to recall what parameter value was used to run that report.

Question 39

You can create a report with an embedded graph or image.

Question 40

Reports have three views: Report view,Layout view,and Design view.

Question 41

An example of a report with subtotals and totals could include customer orders by first showing the customer and then grouping all of the customer's orders together.

Question 42

The Detail area shows the fields from the underlying record source.These are the unbound controls showing values.

Question 43

The order you select the fields in the Report Wizard will determine how the fields are laid out on the report.

Question 44

In the Report Wizard,the one-to-many grouping is the first grouping suggested to you.

Question 45

The Page Header contains the information printed once at the beginning of a report.

Question 46

Reports can be created in four different ways: with the Report tool,with the Report Design tool,with the Blank Report tool,and with the Report Wizard.

Question 47

The default information contained in the Report Header is the column headers,which are taken from the captions from the table design.If no captions were defined,the values are field names.

Question 48

The default title is the name of the report.

Question 49

Reports have a grouping feature allowing records to be presented in sets.

Question 50

The Report tool guides you through creating a report by asking you questions.The report is created based upon your answers to the questions.

Question 51

The Report Footer shows the calculated summary field on the left.

Question 52

The Report Design tool creates a blank report in Design view.You add fields or other controls to the design.

Question 53

When a control is selected,the smaller orange handles are move handles.

Question 54

Like fields on a form,every field on a report has certain characteristics or properties about the field stored in a property sheet.

Question 55

When a control is selected,the control in outlined in orange.

Question 56

Reports are designed for printing.You can use them to provide an easy-to-understand output for a client or manager.You can create mailing labels and other specialized printable formats.

Question 57

The Group Header contains the information at the end of every group of records and is shown if you choose summary options in the Report Wizard.

Question 58

The Report Header contains the information printed at the top of every page of a report.

Question 59

The Blank Report tool creates a blank report in Layout view.You can insert fields or other controls while you see the data.

Question 60

A Label control is a control that contains descriptive information,typically a table name.

Question 61

One common use of grouping is to use ________ relationships in your database.

Question 62

The ________ tool creates a blank report in Layout view.You can insert fields or other controls while you see the data.

Question 63

By default,a summary report also includes a detail area showing unsummarized fields at the record level.This level can be hidden in either Layout or Design view.

Question 64

The ________ shows the fields from the underlying record source.

Question 65

The ________ contains the information printed at the top of every page of a report.

Question 66

You can add and delete fields in either Layout view or Design view.

Question 67

The ________ guides you through creating a report by asking you questions.The report is created based upon your answers to the questions.

Question 68

The ________ contains the information printed at the beginning of every group of records.

Question 69

Conditional formatting formats a control based on one or more comparisons to a set rule set.

Question 70

Access has a Group & Sort feature that simplifies the addition of groups and totals.It can be used in Report view.

Question 71

When reports are built from parameter queries,running the report yields different results depending on the parameter value entered.

Question 72

If you want to change the fields on existing reports or add grouping,this is not possible once they are created.

Question 73

Reports have a(n)________ feature allowing records to be presented in sets.

Question 74

You can add labels to go with a calculated field,and then you can add lines and shapes to help bring attention to different parts of a report,like the totals.

Question 75

The Group,Sort,and Total pane lets you control how information is sorted and grouped in a report.

Question 76

The ________ contains the information printed once at the beginning of a report.

Question 77

When you change the grouping of a report,the field controls move automatically to represent how the data is grouped.

Question 78

To use subtotals,you need grouping.

Question 79

When Access adds a field to a report without a label,it is good practice to add a label manually.

Question 80

The ________ tool creates a blank report in Design view.You add fields or other controls to the design.