Question 1

Why would you use Expression Builder to set a calculated field's property in Table Design view?

Accepted Answer

A)  To preview the results of the calculation 
B)  To create a macro that runs when the field is selected 
C)  To enter the expression as SQL code 
D)  To make sure you use the correct syntax in an expression 
A)  To preview the results of the calculation 
B)  To create a macro that runs when the field is selected 
C)  To enter the expression as SQL code 
D)  To make sure you use the correct syntax in an expression

Question 2

In Form Layout view, you can edit labels but not data.

Accepted Answer

A) True 
 B)False

Question 3

To close a report in Report Design view while keeping the database open, you _____.

Accepted Answer

A)  click the Close button on the Page Setup tab 
B)  click the Close button on the Access title bar 
C)  right-click the report tab and then click Close 
D)  right-click the status bar and then click Close 
A)  click the Close button on the Page Setup tab 
B)  click the Close button on the Access title bar 
C)  right-click the report tab and then click Close 
D)  right-click the status bar and then click Close

Question 4

What is the result of using the Database Documenter?

Accepted Answer

A)  A list of recommendations and tips for improving performance 
B)  A report providing details on the objects and properties of the database 
C)  A list of orphan records 
D)  A report on how to make the database more secure 
A)  A list of recommendations and tips for improving performance 
B)  A report providing details on the objects and properties of the database 
C)  A list of orphan records 
D)  A report on how to make the database more secure

Question 5

To resize the form header in Form Layout view, you use the _____ property.

Accepted Answer

A)  Visible 
B)  Height 
C)  Special Effect 
D)  Keep Together 
A)  Visible 
B)  Height 
C)  Special Effect 
D)  Keep Together

Question 6

If you create a blank form, you must set the _____ property to display data on the form.

Accepted Answer

A)  Control Data 
B)  Record Source 
C)  Row Values 
D)  Hyperlink Address 
A)  Control Data 
B)  Record Source 
C)  Row Values 
D)  Hyperlink Address

Question 7

Press CTRL+S to select all the records in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following controls would you add to a form to print the current record?

Accepted Answer

A)  toggle button 
B)  command button 
C)  check box 
D)  option button 
A)  toggle button 
B)  command button 
C)  check box 
D)  option button

Question 9

If you move a text box in Form Design view, you _____.+

Accepted Answer

A)  move the other text boxes in the column 
B)  move the label associated with that text box 
C)  must reset the margins of the form 
D)  change the tab order of the text box 
A)  move the other text boxes in the column 
B)  move the label associated with that text box 
C)  must reset the margins of the form 
D)  change the tab order of the text box

Question 10

A check box control usually displays a "yes" or "no" answer for a field.

Accepted Answer

A) True 
 B)False

Question 11

In Table Datasheet view, you can press CTRL+A to select all the table's records.

Accepted Answer

A) True 
 B)False

Question 12

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

Accepted Answer

A) True 
 B)False

Question 13

To right-align the text in a text box, you use the Align Right button on the Home tab.

Accepted Answer

A) True 
 B)False

Question 14

A report that contains a subreport is called the main report.

Accepted Answer

A) True 
 B)False

Question 15

When you select a control in Form Design view and then press an arrow key, you _____ the control.

Accepted Answer

A)  resize 
B)  anchor 
C)  move 
D)  lock 
A)  resize 
B)  anchor 
C)  move 
D)  lock

Question 16

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

Accepted Answer

A)  Linked Table Manager 
B)  Database Documenter 
C)  Performance Analyzer 
D)  Object Dependencies pane 
A)  Linked Table Manager 
B)  Database Documenter 
C)  Performance Analyzer 
D)  Object Dependencies pane

Question 17

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

Accepted Answer

A) True 
 B)False

Question 18

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

Accepted Answer

A)  Control 
B)  Form 
C)  Button 
D)  Field 
A)  Control 
B)  Form 
C)  Button 
D)  Field

Question 19

A combo box is a combination of a text box and command button.

Accepted Answer

A) True 
 B)False

Question 20

Tab order refers to the order you added tabbed pages to a tab control.

Accepted Answer

A) True 
 B)False

Why would you use Expression Builder to set a calculated field's property in Table Design view?

In Form Layout view, you can edit labels but not data.

To close a report in Report Design view while keeping the database open, you _____.

What is the result of using the Database Documenter?

To resize the form header in Form Layout view, you use the _____ property.

If you create a blank form, you must set the _____ property to display data on the form.

Press CTRL+S to select all the records in Table Datasheet view.

Which of the following controls would you add to a form to print the current record?

If you move a text box in Form Design view, you _____.+

A check box control usually displays a "yes" or "no" answer for a field.

In Table Datasheet view, you can press CTRL+A to select all the table's records.

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

To right-align the text in a text box, you use the Align Right button on the Home tab.

A report that contains a subreport is called the main report.

When you select a control in Form Design view and then press an arrow key, you _____ the control.

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

A combo box is a combination of a text box and command button.

Tab order refers to the order you added tabbed pages to a tab control.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 6: Managing Data With Data Tools

Why would you use Expression Builder to set a calculated field's property in Table Design view?

In Form Layout view, you can edit labels but not data.

To close a report in Report Design view while keeping the database open, you _____.

What is the result of using the Database Documenter?

To resize the form header in Form Layout view, you use the _____ property.

If you create a blank form, you must set the _____ property to display data on the form.

Press CTRL+S to select all the records in Table Datasheet view.

Which of the following controls would you add to a form to print the current record?

If you move a text box in Form Design view, you _____.+

A check box control usually displays a "yes" or "no" answer for a field.

In Table Datasheet view, you can press CTRL+A to select all the table's records.

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

To right-align the text in a text box, you use the Align Right button on the Home tab.

A report that contains a subreport is called the main report.

When you select a control in Form Design view and then press an arrow key, you _____ the control.

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

A combo box is a combination of a text box and command button.

Tab order refers to the order you added tabbed pages to a tab control.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters