Deck 4: Creating Reports and Forms Question

Question 1

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

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

Answer 1

D

Question 2

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

Answer 2

B

Question 3

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

Answer 3

D

Question 4

The ____ aggregate function finds the largest value.

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

Question 5

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

A) IF
B) sanditional Formatting
C) Format
D) sandition

Question 6

In the acsampanying 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

Question 7

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 8

____ shows the report as it will appear when printed.

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

Question 9

In the acsampanying 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 10

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

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 12

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 13

In the acsampanying 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

Question 14

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 15

In the acsampanying 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 16

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 17

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

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

Question 18

The ____ aggregate function finds the smallest value.

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

Question 19

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

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

Question 20

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

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

Question 21

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 22

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 23

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 24

The ____ section appears at the top of the form and usually santains the form title.

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

Question 25

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

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

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

Question 27

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

The ____ sammand on the Advanced menu allows you to sort resards and enter criteria to restrict retrieval.

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

Question 30

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

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 32

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 33

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 34

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

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

Question 35

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

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

Question 36

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 37

To filter resards 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 38

A ____ sansists of a selection of salors and fonts for the various sections in a report or form.

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

Question 39

A(n) ____ layout arranges santrols vertically with the labels to the left of the santrol.

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

Question 40

The body of the form is in the ____ section.

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

Question 41

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

Question 42

The various objects on a report are called tools.

Question 43

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

Question 44

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

Question 45

The santents of the Detail section print once for each resard in the table.

Question 46

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 47

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

Question 48

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 sauld select include ____.

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

Question 49

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 50

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

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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 55

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

Question 56

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

Question 57

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

A) saunt Resards
B) saunt Values
C) Variance
D) Standard Deviation

Question 58

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

Question 59

The santents of the Page Header section print once at the top of each page and typically santain the salumn headings.

Question 60

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 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

The santents of the ___________________ section print once at the top of each page and typically santain the salumn headings.

Question 66

A santrol layout sansists of a selection of salors and fonts for the various sections in a report or form.

Question 67

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

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

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

A santrol layout is a guide that aligns the santrols to give the form a uniform appearance.

Question 80

The santents of the ___________________ section print once for each resard in the table.