Deck 8: Advanced Report Techniques

Full screen (f)
exit full mode
Question
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
Use Space or
up arrow
down arrow
to flip the card.
Question
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
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
<strong>  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.</strong> A) Add Table B) Field List C) Show Table D) Select Table <div style=padding-top: 35px> 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
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
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
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
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
Question
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
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
Question
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
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
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
<strong>  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.</strong> A) Wizard B) Wizards & Tools C) Select Wizard D) Use Control Wizards <div style=padding-top: 35px> 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
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
<strong>  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.</strong> A) Report B) Subform/Subreport C) Subreport D) Bound Object <div style=padding-top: 35px> 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
<strong>  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.</strong> A) Properties B) Field Properties C) Query Properties D) Property Sheet <div style=padding-top: 35px> 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
Question
<strong>  The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.</strong> A) Builder B) Arithmetic C) Calculation D) Zoom <div style=padding-top: 35px> 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
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
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
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
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
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
To copy a control, tap or click the Copy button on the ____ tab.

A) FILE
B) DESIGN
C) HOME
D) CREATE
Question
To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

A) COUNT
B) TOTAL
C) ADD
D) SUM
Question
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
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
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
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
To assign a conditional value, use the ____ function.

A) CONDITION
B) DECISION
C) COMPARE
D) IIF
Question
To ensure that a calculated control displays as currency, change the ____ property.

A) Number
B) Format
C) Control Source
D) Text Box
Question
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
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
The ____ aggregate function finds the largest value.

A) MAX VALUE
B) GRAND
C) LARGEST
D) MAX
Question
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
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
The ____ aggregate function finds the smallest value.

A) MIN
B) SMALLEST
C) TINY
D) LEAST
Question
<strong>  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.</strong> A) SubReport View B) Design View C) Modify SubReport D) SubReport Design <div style=padding-top: 35px> 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
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
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
The process of combining two or more text data items into a single expression is called concatenation.
Question
A report contains three types of controls: bound controls, unbound controls, and formatted controls.
Question
The record source for a report is the table or query that will furnish the data for the report.
Question
To create a new query, tap or click the Query Design button on the CREATE tab.
Question
Modified Multiple Choice The property sheet includes the _____ tabs.

A) Data
B) All
C) Event
D) Format
Question
You can use either Report view or Print Preview to get an accurate picture of how a final printed report will look.
Question
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
You can move a property sheet box but you cannot resize it.
Question
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
Modified Multiple Choice You can create a report using _____.

A) Design view
B) Report view
C) Report Wizard
D) Layout view
Question
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
To add a subreport to a report, use the Text Box tool on the REPORT DESIGN TOOLS DESIGN tab.
Question
To ungroup controls, use the Ungroup button on the Size/Space button menu on the REPORT DESIGN TOOLS ARRANGE tab.
Question
To concatenate text data, you use the asterisk (*) operator.
Question
To display the Expression Builder dialog box, tap or click the Build Expression button on the QUERY TOOLS DESIGN tab.
Question
The process of converting an unbound control to a bound control is called binding.
Question
If you link an Excel workbook to an Access database, you can edit the linked table in Access.
Question
Modified Multiple Choice The aggregate functions available in Access are _____.

A) COUNT
B) SUM
C) TOTAL
D) AVG
Question
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
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
To preview a report when you are working in Design view, click Print Preview on the Report button menu.
Question
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
To select more than one control, click one of the controls and then hold the SHIFT key down while selecting the others.
Question
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
When you combine two or more text data items into a single expression, the process is called concatenation .
Question
To add totals or other statistics to a footer, add a text box control.
Question
To display the Group, Sort, and Total pane, click the Group Report button.
Question
To sort records within a group, tap or click the ___________________ button in the Group, Sort, and Total pane.
Question
To add a page number to a report, use the Report Footer button.
Question
To create an initial report in Design view, tap or click the ____________________ button on the CREATE tab.
Question
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
To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.
Question
The row source for a report is the table or query that will furnish the data for the report.
Question
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
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
To find the largest value, use the LARGE aggregate function.
Question
If you move, rename, or modify linked tables, you can use the Linked Table Manager within the ____________________ tab to update the links.
Question
If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.
Question
To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.
Question
The subreport appears as a separate report in the Navigation Pane.
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/224
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 8: Advanced Report Techniques
1
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
C
2
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
C
3
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
C
4
<strong>  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.</strong> A) Add Table B) Field List C) Show Table D) Select Table 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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
5
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
7
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
8
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
9
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
10
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
11
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
12
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
13
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
14
<strong>  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.</strong> A) Wizard B) Wizards & Tools C) Select Wizard D) Use Control Wizards 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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
16
<strong>  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.</strong> A) Report B) Subform/Subreport C) Subreport D) Bound Object 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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
17
<strong>  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.</strong> A) Properties B) Field Properties C) Query Properties D) Property Sheet 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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
18
<strong>  The Expression Builder dialog box displays in the accompanying figure. You also can display the ____ dialog box to type an expression.</strong> A) Builder B) Arithmetic C) Calculation D) Zoom 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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
19
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
20
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
21
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
22
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
23
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
24
To copy a control, tap or click the Copy button on the ____ tab.

A) FILE
B) DESIGN
C) HOME
D) CREATE
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
25
To calculate the total of a field, such as Amount Paid, use the ____ aggregate function.

A) COUNT
B) TOTAL
C) ADD
D) SUM
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
27
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
28
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
29
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
30
To assign a conditional value, use the ____ function.

A) CONDITION
B) DECISION
C) COMPARE
D) IIF
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
31
To ensure that a calculated control displays as currency, change the ____ property.

A) Number
B) Format
C) Control Source
D) Text Box
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
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 [ ]
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
33
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
34
The ____ aggregate function finds the largest value.

A) MAX VALUE
B) GRAND
C) LARGEST
D) MAX
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
35
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
36
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
37
The ____ aggregate function finds the smallest value.

A) MIN
B) SMALLEST
C) TINY
D) LEAST
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
38
<strong>  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.</strong> A) SubReport View B) Design View C) Modify SubReport D) SubReport Design 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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
39
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
40
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
41
The process of combining two or more text data items into a single expression is called concatenation.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
42
A report contains three types of controls: bound controls, unbound controls, and formatted controls.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
43
The record source for a report is the table or query that will furnish the data for the report.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
44
To create a new query, tap or click the Query Design button on the CREATE tab.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
45
Modified Multiple Choice The property sheet includes the _____ tabs.

A) Data
B) All
C) Event
D) Format
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
46
You can use either Report view or Print Preview to get an accurate picture of how a final printed report will look.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
47
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
48
You can move a property sheet box but you cannot resize it.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
49
When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
50
Modified Multiple Choice You can create a report using _____.

A) Design view
B) Report view
C) Report Wizard
D) Layout view
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
51
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
52
To add a subreport to a report, use the Text Box tool on the REPORT DESIGN TOOLS DESIGN tab.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
53
To ungroup controls, use the Ungroup button on the Size/Space button menu on the REPORT DESIGN TOOLS ARRANGE tab.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
54
To concatenate text data, you use the asterisk (*) operator.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
55
To display the Expression Builder dialog box, tap or click the Build Expression button on the QUERY TOOLS DESIGN tab.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
56
The process of converting an unbound control to a bound control is called binding.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
57
If you link an Excel workbook to an Access database, you can edit the linked table in Access.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
58
Modified Multiple Choice The aggregate functions available in Access are _____.

A) COUNT
B) SUM
C) TOTAL
D) AVG
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
59
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
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
60
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
61
To preview a report when you are working in Design view, click Print Preview on the Report button menu.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
63
To select more than one control, click one of the controls and then hold the SHIFT key down while selecting the others.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
64
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
65
When you combine two or more text data items into a single expression, the process is called concatenation .
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
66
To add totals or other statistics to a footer, add a text box control.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
67
To display the Group, Sort, and Total pane, click the Group Report button.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
68
To sort records within a group, tap or click the ___________________ button in the Group, Sort, and Total pane.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
69
To add a page number to a report, use the Report Footer button.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
70
To create an initial report in Design view, tap or click the ____________________ button on the CREATE tab.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
71
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
72
To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
73
The row source for a report is the table or query that will furnish the data for the report.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
74
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
75
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.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
76
To find the largest value, use the LARGE aggregate function.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
77
If you move, rename, or modify linked tables, you can use the Linked Table Manager within the ____________________ tab to update the links.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
78
If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
79
To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
80
The subreport appears as a separate report in the Navigation Pane.
Unlock Deck
Unlock for access to all 224 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 224 flashcards in this deck.