Deck 5: Creating Reports and Forms

Question 1

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to choose the length of the value on which to group.

A) Length
B) Group Length
C) Value
D) Restrict

Answer 1

C

Question 2

_____ are used to display data that is calculated from other data, such as a total.

A) Unbound controls
B) Bound controls
C) Calculated controls
D) Aggregate controls

Answer 2

C

Question 3

_____ shows the report on the screen but also allows you to make changes to the report.

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

Answer 3

B

Question 4

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to choose values to be totaled and where they are to appear.

A) Aggregate
B) Totals
C) Group Totals
D) Sum

Question 5

To create a report in Layout view, click the _____ button on the Create tab.

A) Report Layout
B) Layout View
C) Simple Report
D) Blank Report

Question 6

To adjust the margins or change the page orientation of a report, open the report in Layout view and then click the _____ tab.

A) Arrange
B) Page Setup
C) Print Preview
D) Format

Question 7

In the accompanying figure, _____ are used to display data that comes for the database, such as the client number and name.

A) Bound controls
B) Unbound controls
C) Calculated controls
D) Aggregate controls

Question 8

To display the Conditional Formatting Rules Manager dialog box, click the _____ button on the Format tab.

A) IF
B) Conditional Formatting
C) Format
D) Condition

Question 9

The ____ aggregate function finds the smallest value.

A) Smallest
B) Min
C) TinyInt
D) Least

Question 10

_____ are not associated with data from the database and are used to display such things as the report's title.

A) Bound controls
B) Unbound controls
C) Title controls
D) Calculated controls

Question 11

The _____ aggregate function finds the largest value.

A) Most
B) Largest
C) Max
D) Grand

Question 12

To filter records in a report, use the filter buttons on the _____ tab.

A) Format
B) Create
C) Database Tools
D) Home

Question 13

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to customize the group title.

A) Customize
B) Header
C) Title
D) Label

Question 14

To use a field list to add a field to a report in Layout view, click the _____ button on the Design tab to display a field list.

A) Show Table
B) Add Existing Fields
C) Field List
D) Display Fields

Question 15

If you open a field list and the tables do not appear in the field list, click _____.

A) Open Tables
B) Show All Tables
C) Table
D) Datasheet

Question 16

To specify grouping and sorting for a report, click the _____ button on the Design tab in Layout view.

A) Group
B) Sort
C) Organize by Group
D) Group & Sort

Question 17

You use the _____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

A) More
B) Totals
C) Summary Options
D) Aggregate

Question 18

_____ shows the report as it will appear when printed.

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

Question 19

To add totals or other statistics to a report, use the _____ button on the Design tab.

A) Aggregate
B) Statistics
C) Sum
D) Totals

Question 20

In the accompanying figure, you can click the More button in the Group, Sort, and Total pane to specify additional options. The _____ option allows you to indicate whether Access is to attempt to keep portions of a group together on a page.

A) Same Page
B) Keep together
C) Page Group
D) No Orphans

Question 21

_____ allows you to make changes, but it does not show you the actual form.

A) Form view
B) Layout view
C) Design view
D) Screen view

Question 22

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, click the Create tab, and then click the _____ button.

A) Form Wizard
B) More Forms
C) Blank Form
D) Form

Question 23

The _____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

A) Advanced Filter/Sort
B) Apply Filter/Sort
C) Query/Sort
D) Filter by Form

Question 24

To add a title to a report, click Create on the Ribbon and then click the _____ button on the Design tab.

A) Add Title
B) Add Header
C) Title
D) Header

Question 25

The _____ section appears at the top of the form and usually contains the form title.

A) Title
B) Form Header
C) Group Header
D) Form Label

Question 26

To clear a current filter, click _____ on the Advanced menu.

A) Toggle Filters
B) Remove Filters
C) Delete Filters
D) Clear All Filters

Question 27

To create labels using the Label Wizard, click the _____ button on the Create tab.

A) Mailing Label
B) More Wizards
C) Mailing Label Wizard
D) Labels

Question 28

A(n) _____ layout arranges controls horizontally with the labels across the top, typically in the Form Header section..

A) arranged
B) horizontal
C) tabular
D) top aligned

Question 29

To filter records on a form, click the Advanced button on the _____ tab to display the Advanced menu.

A) Create
B) Format
C) Home
D) Database Tools

Question 30

The body of the form is in the _____ section.

A) Body
B) Main
C) Detail
D) Record

Question 31

To place controls on a form in a control layout, select all the controls and click the Stacked button on the _____ tab.

A) Design
B) Format
C) Page Setup
D) Arrange

Question 32

A(n) _____ layout arranges controls vertically with the labels to the left of the control.

A) arranged
B) stacked
C) formatted
D) vertical

Question 33

A _____ consists of a selection of colors and fonts for the various sections in a report or form.

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

Question 34

To add an additional field to a form, click the _____ button to display a field list.

A) Show Tables
B) Field List
C) Add Existing Fields
D) Add Form Fields

Question 35

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a(n) _____ report.

A) summary
B) grouped
C) abstract
D) header/footer

Question 36

In _____ you cannot update the data, but you can make changes to the layout of the form.

A) Layout view
B) Form view
C) Design view
D) Screen view

Question 37

The _____ section appears at the bottom of the form and often is empty.

A) Form Footer
B) Totals
C) Page Footer
D) Grand Totals

Question 38

To add a date to a form, click the _____ button on the Design tab.

A) Date and Time
B) Date
C) Show Date
D) Add Date

Question 39

_____ shows the form on the screen and allows you to use the form to update data.

A) Layout view
B) Design view
C) Form view
D) Screen view

Question 40

To find themes that are not listed in Access but are available for download, click the _____ command.

A) Download Themes
B) Online Themes
C) Browse for Themes
D) Microsoft Access

Question 41

When the data in a report is grouped, there are four additional sections.

Question 42

When you view a report in Print Preview, you can make changes to the report.

Question 43

When you click the Group & Sort button on the Format tab, Access produces an 'Add a group and sort' button at the bottom of the screen.

Question 44

Modified Multiple Choice When working on a report in Layout view, you can make additional layout changes by using the _____ tab(s).

A) External Data
B) Arrange
C) Database Tools
D) Page Setup

Question 45

When you create an initial report using the Report Wizard, you can customize the report using either Layout view or Design view.

Question 46

To calculate the total of amount paid values, click the Totals button on the Format tab and then click Totals on the list of available calculations.

Question 47

The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.

Question 48

Modified Multiple Choice The three types of controls that can appear on a report are _____.

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

Question 49

To add more space between groups, enlarge the group header or group footer.

Question 50

The contents of the Report Header section print once at the beginning of the report.

Question 51

Modified Multiple Choice Available aggregate functions for use in a report include _____.

A) Count Records
B) Count Values
C) Variance
D) Standard Deviation

Question 52

Design view is most useful when the changes you need to make to a report are especially complex.

Question 53

The contents of the Page Header section print once at the top of each page and typically contain the column headings.

Question 54

Once you decide on a general report style, you should stick with it throughout your database.

Question 55

The contents of the Detail section print once for each record in the table.

Question 56

Modified Multiple Choice When working with a report in Access, the different ways you can view the report include _____.

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

Question 57

A form is the appropriate choice if it is necessary to print data.

Question 58

The various objects on a report are called tools.

Question 59

In Layout view of a report, you can specify both grouping and sorting.

Question 60

Modified Multiple Choice For both grouping and sorting, there is a More button that you can click if you need to specify additional options. The options you then could select include _____.

A) Additional Sort
B) Value
C) Title
D) Totals

Question 61

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a summary report.

Question 62

In Access, mailing labels are a special type of form.

Question 63

You cannot use the Report Wizard to create a report on multiple tables.

Question 64

The Form Header section appears at the top of the form and usually contains the form title.

Question 65

To add totals to the Amount Paid column in a report, click the Aggregate button on the Design tab.

Question 66

You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.

Question 67

The Page Setup tab is available for both forms and reports.

Question 68

To add a date to a form, use the Date and Time button in the Header/Footer group on the Design tab.

Question 69

The contents of the ___________________ section print once at the bottom of each page and often contain a date and page number.

Question 70

Themes are standardized across all Office applications.

Question 71

The contents of the ___________________ section print once at the end of the report.

Question 72

If you want to specify subtotals or other calculations within the Report Wizard, you use the Summary Options button.

Question 73

You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.

Question 74

To adjust margins or change the page orientation of a report, open the report in Layout view and click the Arrange tab.

Question 75

The contents of the ___________________ section print once at the top of each page and typically contain the column headings.

Question 76

A control layout is a guide that aligns the controls to give the form a uniform appearance.

Question 77

A control layout consists of a selection of colors and fonts for the various sections in a report or form.

Question 78

The contents of the ___________________ section print once for each record in the table.

Question 79

The contents of the ___________________ section print once at the beginning of the report.

Question 80

The Form Footer section appears at the bottom of the form and usually contains a date.