Question 1

To select a smaller font size for a control, use the ____________________ property.

Accepted Answer

The answer of To select a smaller font size for...

Question 2

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.

Accepted Answer

The answer of To specify a primary key consisting of...

Question 3

Once you have formatted a control and its label the way you want, you can format other controls in exactly the same way by using the ____________________.

Accepted Answer

The answer of Once you have formatted a control and...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed after the records in a particular group.

Accepted Answer

The answer of   
 The Book Rep Master...

Question 6

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

Accepted Answer

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

Question 7

The Book Rep Master List shown in the accompanying figure displays in Design view. To view the report in Print Preview, tap or click the ____________________ button arrow and then click Print Preview on the menu.

Accepted Answer

The answer of   
 The Book Rep Master...

Question 8

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed before the records in a particular group.

Accepted Answer

The answer of   
 The Book Rep Master...

Question 9

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 10

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

Accepted Answer

The answer of If you move, rename, or modify linked...

Question 11

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Book Rep Master List. What is the result of this expression?

Accepted Answer

The expression will display th

Question 12

The ____ aggregate function finds the largest value.

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

To change the appearance of a control so that text in the control displays as semi-bold, change the ____ property for the control.

Accepted Answer

A)  Font 
B)  Format 
C)  Font Weight 
D)  Special Effect 
A)  Font 
B)  Format 
C)  Font Weight 
D)  Special Effect

Question 15

To copy a format to more than one control, hold the SHIFT key down when tapping or clicking the Format Painter button.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Calculation involving two text fields.

Accepted Answer

The Answer of rectangle and font color and code and is...

Question 17

To create a form in Design view, tap or click the CREATE tab, and then tap or click the ____ button.

Accepted Answer

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

Question 18

The report needs a title. How can the employee add a title?

Accepted Answer

Tap or click the Tit

Question 19

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

Accepted Answer

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

Question 20

The form in the accompanying figure has no title. If a form currently does not have a Form Header section, clicking the Title button on the FORM DESIGN TOOLS DESIGN tab will add both a Form Header section and a title.

Accepted Answer

A) True 
 B)False

To select a smaller font size for a control, use the ____________________ property.

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.

Once you have formatted a control and its label the way you want, you can format other controls in exactly the same way by using the ____________________.

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

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed after the records in a particular group.

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

The Book Rep Master List shown in the accompanying figure displays in Design view. To view the report in Print Preview, tap or click the ____________________ button arrow and then click Print Preview on the menu.

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed before the records in a particular group.

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

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

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Book Rep Master List. What is the result of this expression?

The ____ aggregate function finds the largest value.

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

To change the appearance of a control so that text in the control displays as semi-bold, change the ____ property for the control.

To copy a format to more than one control, hold the SHIFT key down when tapping or clicking the Format Painter button.

To create a form in Design view, tap or click the CREATE tab, and then tap or click the ____ button.

The report needs a title. How can the employee add a title?

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

The form in the accompanying figure has no title. If a form currently does not have a Form Header section, clicking the Title button on the FORM DESIGN TOOLS DESIGN tab will add both a Form Header section and a title.

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multiple-Table Forms

Filters

Exam 8: Advanced Report Techniques

To select a smaller font size for a control, use the ____________________ property.

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.

Once you have formatted a control and its label the way you want, you can format other controls in exactly the same way by using the ____________________.

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

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed after the records in a particular group.

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

The Book Rep Master List shown in the accompanying figure displays in Design view. To view the report in Print Preview, tap or click the ____________________ button arrow and then click Print Preview on the menu.

The Book Rep Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed before the records in a particular group.

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

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

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Book Rep Master List. What is the result of this expression?

The ____ aggregate function finds the largest value.

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

To change the appearance of a control so that text in the control displays as semi-bold, change the ____ property for the control.

To copy a format to more than one control, hold the SHIFT key down when tapping or clicking the Format Painter button.

To create a form in Design view, tap or click the CREATE tab, and then tap or click the ____ button.

The report needs a title. How can the employee add a title?

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

The form in the accompanying figure has no title. If a form currently does not have a Form Header section, clicking the Title button on the FORM DESIGN TOOLS DESIGN tab will add both a Form Header section and a title.

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multiple-Table Forms

Filters