Question 1

The _____ aggregate function finds the largest value.

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The Business Analyst Master List shown in the accompanying figure includes an unbound control. To place this control on a report, click the ____________________ tool on the Design tab.

Accepted Answer

The answer of   
 The Business Analyst Master...

Question 5

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

Accepted Answer

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

Question 6

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

Accepted Answer

Click the Margins button on th

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

To group controls, select the controls to group, and click the Size/Space button on the ____________________ tab.

Accepted Answer

The answer of To group controls, select the controls to...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

To ungroup controls, use the Ungroup button on the Size/Space button menu on the Arrange tab.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The Business Analyst Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

Accepted Answer

The answer of   
 The Business Analyst Master...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of To create an initial report in Design...

Question 20

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

Accepted Answer

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

The _____ aggregate function finds the largest value.

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

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

The Business Analyst Master List shown in the accompanying figure includes an unbound control. To place this control on a report, click the ____________________ tool on the Design tab.

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

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

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

To group controls, select the controls to group, and click the Size/Space button on the ____________________ tab.

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

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

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

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

To ungroup controls, use the Ungroup button on the Size/Space button menu on the Arrange tab.

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

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

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

The Business Analyst Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

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

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

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

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters

Exam 7: Advanced Report Techniques

The _____ aggregate function finds the largest value.

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

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

The Business Analyst Master List shown in the accompanying figure includes an unbound control. To place this control on a report, click the ____________________ tool on the Design tab.

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

The employee has decided to select the pre-defined option, Narrow, to reduce the size of the margins for the report. How does she change to the Narrow margin option?

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

To group controls, select the controls to group, and click the Size/Space button on the ____________________ tab.

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

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

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

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

To ungroup controls, use the Ungroup button on the Size/Space button menu on the Arrange tab.

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

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

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

The Business Analyst Master List shown in the accompanying figure includes an unbound control. You could enter an expression in this control to combine two or more text data items. The process of combining these items is called ____________________.

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

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

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

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters