Deck 6: Advanced Report Techniques Question

Question 1

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

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

Answer 1

D

Question 2

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

Answer 2

A

Question 3

To ungroup santrols, tap or click any of the santrols 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

Answer 3

B

Question 4

The santents of the ____ section are printed before the resards in a particular group.

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

Question 5

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 6

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

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

Question 7

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 8

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 9

The santents of the ____ section are printed after the resards in a particular group.

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

Question 10

The SubReport Wizard displays in the acsampanying 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 11

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 12

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

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

Question 14

If the primary key of the Seminar Offerings table santains 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

Question 15

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 16

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 17

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

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

Question 18

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 19

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 20

The SubReport Wizard displays in the acsampanying 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 santrol Wizards

Question 21

The SubReport Wizard displays in the acsampanying 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 22

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 23

The ____ aggregate function finds the largest value.

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

Question 24

To sapy a santrol, tap or click the sapy button on the ____ tab.

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

Question 25

The ____ aggregate function finds the smallest value.

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

Question 26

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

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

Question 27

To assign a sanditional value, use the ____ function.

A) saNDITION
B) DECISION
C) saMPARE
D) IIF

Question 28

To use an item name that santains 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 29

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 30

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

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

Question 31

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 32

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 santrol

Question 33

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 34

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

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

Question 35

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 36

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

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

Question 37

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 sampress

Question 38

To cause the santents 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

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 40

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 41

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

Question 42

Modified Multiple Choice The property sheet includes the _____ tabs.

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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 48

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

Question 49

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

Question 50

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

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

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

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

Question 53

The process of sanverting an unbound santrol to a bound santrol is called binding.

Question 54

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

Question 55

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

Question 56

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

Question 57

A report santains three types of santrols: bound santrols, unbound santrols, and formatted santrols.

Question 58

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

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

Question 59

Modified Multiple Choice You can create a report using _____.

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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 67

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

Question 68

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

Question 69

To specify a primary key sansisting 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 sesand 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

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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