Deck 6: Creating Reports and Forms

Question 1

In the accompanying figure, you can tap or 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

Answer 1

B

Question 2

In the accompanying figure, you can tap or 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 2

C

Question 3

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

A) FORMAT
B) CREATE
C) DATABASE TOOLS
D) HOME

Answer 3

D

Question 4

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

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

Question 5

In the accompanying figure, you can tap or 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 6

____ 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

Question 7

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

To use a field list to add a field to a report in Layout view, tap or 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 9

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

A) ARRANGE
B) PAGE SETUP
C) PRINT PREVIEW
D) FORMAT

Question 10

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

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

Question 11

In the accompanying figure, you can tap or 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 12

The ____ aggregate function finds the largest value.

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

Question 13

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

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

Question 14

____ 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

Question 15

The ____ aggregate function finds the smallest value.

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

Question 16

To display the Conditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.

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

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

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 19

____ shows the report as it will appear when printed.

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

Question 20

To create a report in Layout view, tap or click the ____ button on the CREATE tab.

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

Question 21

The body of the form is in the ____ section.

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

Question 22

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

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

Question 23

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 24

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 25

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

To place controls on a form in a stacked layout, select all the controls and tap or click the Stacked button on the ____ tab.

A) DESIGN
B) FORMAT
C) PAGE SETUP
D) ARRANGE

Question 27

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 28

To clear a current filter, tap or click ____ on the Advanced menu.

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

Question 29

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

A) CREATE
B) FORMAT
C) HOME
D) DATABASE TOOLS

Question 30

To add a date to a form, tap or click the ____ button on the DESIGN tab.

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

Question 31

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 32

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

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

Question 33

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 34

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 35

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 36

To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ____ button on the DESIGN tab.

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

Question 37

To add an additional field to a form, tap or click the ____ button to display a field list.

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

Question 38

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

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.

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

Question 40

To create labels using the Label Wizard, tap or click the ____ button on the CREATE tab.

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

Question 41

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

Question 42

The various objects on a report are called tools.

Question 43

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

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

Question 44

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

Question 45

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

Question 46

When you click the Group & Sort button on the FORMAT tab, Access displays a Group, Sort, and Total pane at the top of the screen.

Question 47

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 48

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

Question 49

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

Question 50

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 51

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

Question 52

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

Question 53

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

Question 54

The data in a report can come from one or more tables but the data in a form only can come from one table.

Question 55

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

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

Question 56

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 57

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

Question 58

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 59

You can use forms to add records, delete records, or change records.

Question 60

Modified Multiple Choice For both grouping and sorting, there is a More button that you can tap or 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

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

The PAGE SETUP tab is available for both forms and reports.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

When you assign a theme to any object in the database, the theme immediately applies to all reports and forms in the same database, unless you specifically indicate otherwise.

Question 80

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