Deck 3: Access: Advanced Report Techniques

Question 1

If the primary key of the Seminar Offerings table contains the primary key for both the Customer table and Seminar table, there is a ____ relationship between customers and seminars.

A) one-to-one
B) many-to-many
C) one-to-many
D) many-to-one

Answer 1

B

Question 2

The contents of the ____ section are printed after the records in a particular group.

A) After Group
B) After Section
C) Subtotal Footer
D) Group Footer

Answer 2

D

Question 3

In the accompanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, tap or click the ____ button to display the property sheet.

A) Properties
B) Field Properties
C) Query Properties
D) Property Sheet

Answer 3

D

Question 4

To create a report from scratch, tap or click the CREATE tab, and then tap or click the ____ button.

A) Design View
B) Report Design
C) Blank Report
D) Report View

Question 5

You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS ____ tab.

A) ALIGN
B) CONTROLS
C) PAGE LAYOUT
D) ARRANGE

Question 6

To remove the Group, Sort, and Total pane when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

A) Remove Group Pane
B) Group & Sort
C) Ungroup
D) Show/Hide Group Pane

Question 7

The contents of the ____ section are printed before the records in a particular group.

A) Before Group
B) Before Section
C) Group Header
D) Detail

Question 8

To import a text file, tap or click the ____ button on the EXTERNAL DATA tab.

A) Text File
B) ASCII Text
C) ASCII File
D) More

Question 9

To ungroup controls, tap or click any of the controls in the group and tap or click the Ungroup button on the REPORT DESIGN TOOLS ____ tab.

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

Question 10

To display the Group, Sort, and Total pane, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

A) Grouping
B) Group Report
C) Group & Sort
D) Totals

Question 11

The SubReport Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subreport, make sure the ____ button is selected.

A) Wizard
B) Wizards & Tools
C) Select Wizard
D) Use Control Wizards

Question 12

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

A) Create Table
B) Design View
C) Table View
D) Table Design

Question 13

To periodically view a report to gauge how it will look containing data, tap or click _____ on the View menu.

A) Print
B) Data View
C) View
D) Print Preview

Question 14

To reverse the most recent change to a report, tap or click the ____ button on the Quick Access Toolbar.

A) Reverse
B) Cancel
C) Undo
D) Previous

Question 15

To remove the field list when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

A) Add Existing Fields
B) Remove Fields
C) Show Fields
D) Show Tables/Queries

Question 16

To add fields to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab to add a field list.

A) Field List
B) Report Fields
C) Add Existing Fields
D) Show Tables/Queries

Question 17

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

A) Query
B) Design View
C) Query Design
D) Select Query

Question 18

The SubReport Wizard displays in the accompanying figure. To add a subreport to a report, you use the ____ tool on the REPORT DESIGN TOOLS DESIGN tab.

A) Report
B) Subform/Subreport
C) Subreport
D) Bound Object

Question 19

The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.

A) Builder
B) Arithmetic
C) Calculation
D) Zoom

Question 20

In the accompanying figure, the Seminar Offerings table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

A) Add Table
B) Field List
C) Show Table
D) Select Table

Question 21

To cause each new group section to begin at the top of a page, change the value of the ____ property.

A) Top of Page
B) Force New Page
C) Begin New Page
D) Start New Page

Question 22

To extend a heading over two lines, tap or click in the appropriate position to produce an insertion point and then press the ____ key(s).

A) ALT+ENTER
B) CTRL+ENTER
C) CTRL+E
D) SHIFT+ENTER

Question 23

To assign a conditional value, use the ____ function.

A) CONDITION
B) DECISION
C) COMPARE
D) IIF

Question 24

To change the report margins, tap or click the Margins button on the REPORT DESIGN TOOLS ____ tab.

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

Question 25

To delete a control from a report, tap or click the control and then press the ____ key(s).

A) DELETE
B) CTRL+D
C) ALT+D
D) SHIFT+ENTER

Question 26

To spread data over two lines, change the value of the ____ property.

A) Can Distribute
B) Can Enlarge
C) Can Grow
D) Can Spread

Question 27

To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

A) COUNT
B) TOTAL
C) ADD
D) SUM

Question 28

To display a Report Footer section, press and hold or right-click any open area of the report and tap or click ____ on the shortcut menu.

A) Add a Section
B) Report Header/Footer
C) Add a Footer
D) Insert Report Footer

Question 29

The ____ aggregate function finds the largest value.

A) MAX VALUE
B) GRAND
C) LARGEST
D) MAX

Question 30

The SubReport Wizard displays in the accompanying figure. To open a subreport in Design view, press and hold or right-click the subreport in the Navigation Pane and tap or click ____ on the shortcut menu.

A) SubReport View
B) Design View
C) Modify SubReport
D) SubReport Design

Question 31

To add a title to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

A) Unbound Control
B) Page Header
C) Label
D) Title

Question 32

To use an item name that contains spaces, such as Amount Paid in a function, enclose the item name in ____.

A) parentheses ( )
B) percent symbols % %
C) curly braces { }
D) square brackets [ ]

Question 33

To copy a control, tap or click the Copy button on the ____ tab.

A) FILE
B) DESIGN
C) HOME
D) CREATE

Question 34

To remove blank lines that occur when a field is empty, change the value of the ____ property.

A) Can Reduce
B) Can Shrink
C) Can Decrease
D) Can Compress

Question 35

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

A) Date and Time
B) Page and Date
C) Insert Date
D) Unbound Control

Question 36

To add page numbers to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

A) Pagination
B) Pages & Dates
C) Page Numbers
D) Report Footer

Question 37

To add a text box to a report, tap or click the ____ tool in the Tools group on the REPORT DESIGN TOOLS DESIGN tab.

A) Add Box
B) Text Box
C) Unbound
D) Add Text

Question 38

To cause the contents of the Group Header section to appear at the top of each page, change the value of the ____ property.

A) Group on Page
B) Group Again
C) Group at Top
D) Repeat Section

Question 39

The ____ aggregate function finds the smallest value.

A) MIN
B) SMALLEST
C) TINY
D) LEAST

Question 40

To ensure that a calculated control displays as currency, change the ____ property.

A) Number
B) Format
C) Control Source
D) Text Box

Question 41

To display the Expression Builder dialog box, tap or click the Build Expression button on the QUERY TOOLS DESIGN tab.

Question 42

The process of combining two or more text data items into a single expression is called concatenation.

Question 43

The record source for a report is the table or query that will furnish the data for the report.

Question 44

If you link an Excel workbook to an Access database, you can edit the linked table in Access.

Question 45

A report contains three types of controls: bound controls, unbound controls, and formatted controls.

Question 46

To create a new query, tap or click the Query Design button on the CREATE tab.

Question 47

Modified Multiple Choice The aggregate functions available in Access are _____.

A) COUNT
B) SUM
C) TOTAL
D) AVG

Question 48

Modified Multiple Choice You can create a report using _____.

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

Question 49

To change the format for a control, press and hold or right-click the control and then tap or click Format on the shortcut menu.

Question 50

Modified Multiple Choice The property sheet includes the _____ tabs.

A) Data
B) All
C) Event
D) Format

Question 51

When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.

Question 52

Modified Multiple Choice The Header/Footer group on the Design tab includes the _____ buttons.

A) Page Numbers
B) Title
C) Tools
D) Date and Time

Question 53

You can use either Report view or Print Preview to get an accurate picture of how a final printed report will look.

Question 54

Modified Multiple Choice The Sizing & Ordering group on the Arrange tab includes the _____ buttons relevant to aligning and adjusting controls.

A) Size/Space
B) Align
C) Property Sheet
D) Adjust

Question 55

You can move a property sheet box but you cannot resize it.

Question 56

When you create a report in Design view, the initial report that displays in the Design window contains all the fields in the underlying table or query.

Question 57

To add a subreport to a report, use the Text Box tool on the REPORT DESIGN TOOLS DESIGN tab.

Question 58

To concatenate text data, you use the asterisk (*) operator.

Question 59

To ungroup controls, use the Ungroup button on the Size/Space button menu on the REPORT DESIGN TOOLS ARRANGE tab.

Question 60

The process of converting an unbound control to a bound control is called binding.

Question 61

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

Question 62

To cause the contents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

Question 63

To find the largest value, use the LARGE aggregate function.

Question 64

To sort records within a group, tap or click the ___________________ button in the Group, Sort, and Total pane.

Question 65

To create an initial report in Design view, tap or click the ____________________ button on the CREATE tab.

Question 66

To preview a report when you are working in Design view, click Print Preview on the Report button menu.

Question 67

To display the Group, Sort, and Total pane, click the Group Report button.

Question 68

The subreport appears as a separate report in the Navigation Pane.

Question 69

To specify a primary key consisting of more than one field, tap or click the row selector for the first field, hold down the ____________________ key while tapping or clicking the row selector for the second field, and then tap or click the Primary Key button.

Question 70

If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.

Question 71

If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.

Question 72

To add totals or other statistics to a footer, add a text box control.

Question 73

To add a page number to a report, use the Report Footer button.

Question 74

To select more than one control, click one of the controls and then hold the SHIFT key down while selecting the others.

Question 75

The row source for a report is the table or query that will furnish the data for the report.

Question 76

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

Question 77

When you combine two or more text data items into a single expression, the process is called concatenation .

Question 78

When working on a report in Design view, you can make adjustments to the alignment of the controls in your report by using the Adjustment button on the REPORT DESIGN TOOLS ARRANGE tab.

Question 79

If you move, rename, or modify linked tables, you can use the Linked Table Manager within the ____________________ tab to update the links.

Question 80

To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.