Deck 1: Access: Creating Reports and Forms

Question 1

The ____ aggregate function finds the largest value.

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

Answer 1

C

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

B

Question 3

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 3

C

Question 4

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 5

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 6

____ shows the report as it will appear when printed.

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

Question 7

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 8

The ____ aggregate function finds the smallest value.

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

Question 9

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

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

Question 10

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 11

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

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 13

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 14

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 15

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

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

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 18

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 19

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 20

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 21

The body of the form is in the ____ section.

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

Question 22

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

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

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 26

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 27

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 28

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 29

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 30

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 31

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

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

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 35

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 36

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 37

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 38

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

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

Question 39

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 40

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 41

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

Question 42

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 43

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

Question 44

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

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

Question 45

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

Question 46

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

Question 47

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 48

The various objects on a report are called tools.

Question 49

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

Question 50

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 51

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

Question 52

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 53

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 54

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

Question 55

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

Question 56

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 57

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 58

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

Question 59

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

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

Question 60

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

Question 61

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 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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