Question 1

How can you select all the labels in a report section when working in Report Design view?

Accepted Answer

A)  Double-click each control in the report section. 
B)  Drag in the horizontal ruler from the left to the right margin of the report. 
C)  Drag a selection box around the controls. 
D)  Double-click the report selector button. 
A)  Double-click each control in the report section. 
B)  Drag in the horizontal ruler from the left to the right margin of the report. 
C)  Drag a selection box around the controls. 
D)  Double-click the report selector button.

Question 2

A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Accepted Answer

A)  Click the Page Header section bar, and then press DELETE. 
B)  Drag the Page Header or Page Footer section bar to the Navigation Pane. 
C)  Click the Page Header or Page Footer section bar, and then click Remove on the Design tab. 
D)  Right-click the Page Footer section, and then click Page Header/Footer on the shortcut menu. 
A)  Click the Page Header section bar, and then press DELETE. 
B)  Drag the Page Header or Page Footer section bar to the Navigation Pane. 
C)  Click the Page Header or Page Footer section bar, and then click Remove on the Design tab. 
D)  Right-click the Page Footer section, and then click Page Header/Footer on the shortcut menu.

Question 4

Because the _____ section prints once for each record in the record source, you often shorten the section in Report Design view.

Accepted Answer

A)  Report Header 
B)  Detail 
C)  Group Footer 
D)  Summary 
A)  Report Header 
B)  Detail 
C)  Group Footer 
D)  Summary

Question 5

To close a form in Form Design view and keep Access running, you _____.

Accepted Answer

A)  right-click the form tab, and then click Close on the shortcut menu. 
B)  right-click the form in the Navigation Pane, and then click Close on the shortcut menu. 
C)  click the Close button on the title bar 
D)  drag the form tab to the Navigation Pane 
A)  right-click the form tab, and then click Close on the shortcut menu. 
B)  right-click the form in the Navigation Pane, and then click Close on the shortcut menu. 
C)  click the Close button on the title bar 
D)  drag the form tab to the Navigation Pane

Question 6

To which one of the following fields would you most likely apply the Percent format?

Accepted Answer

A)  DiscountRate 
B)  Price 
C)  Length 
D)  UnitsSold 
A)  DiscountRate 
B)  Price 
C)  Length 
D)  UnitsSold

Question 7

A(n) _____ is an individual step that a macro performs.

Accepted Answer

A)  action 
B)  argument 
C)  property 
D)  flow 
A)  action 
B)  argument 
C)  property 
D)  flow

Question 8

Which of the following join types select all the records from one table even if the related table does not have matching records? Select all the options that apply.

Accepted Answer

A)  self 
B)  left outer 
C)  inner 
D)  right outer 
A)  self 
B)  left outer 
C)  inner 
D)  right outer

Question 9

Michael wants to know if any records in the Clients table have no related records in the Projects table.Which query wizard should he use to find the answer?

Accepted Answer

A)  Simple Query Wizard 
B)  Find Duplicates Query Wizard 
C)  Find Unmatched Query Wizard 
D)  Find Unrelated Query Wizard. 
A)  Simple Query Wizard 
B)  Find Duplicates Query Wizard 
C)  Find Unmatched Query Wizard 
D)  Find Unrelated Query Wizard.

Question 10

Alan created a lookup field with two columns and wants to narrow the first column.Which property should he select on the Lookup tab in Table Design view?

Accepted Answer

A)  List Rows property 
B)  Column Heads property 
C)  Column Widths property 
D)  List Width property 
A)  List Rows property 
B)  Column Heads property 
C)  Column Widths property 
D)  List Width property

Question 11

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

Accepted Answer

A) True 
 B)False

Question 12

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

Accepted Answer

A)  Make-Table 
B)  Crosstab 
C)  Apply 
D)  Append 
A)  Make-Table 
B)  Crosstab 
C)  Apply 
D)  Append

Question 13

What happens when you apply a theme to a form?

Accepted Answer

A)  The formatting changes in that form only. 
B)  The formatting changes in all forms and reports. 
C)  The original formatting is applied when you close the form. 
D)  The formatting changes appear in Form Design view only. 
A)  The formatting changes in that form only. 
B)  The formatting changes in all forms and reports. 
C)  The original formatting is applied when you close the form. 
D)  The formatting changes appear in Form Design view only.

Question 14

What must you use in a macro that performs an action if an employee's salary is greater than $50,000 and the performance rating is greater than 5?

Accepted Answer

A)  the Concat operator 
B)  the And operator 
C)  the Or operator 
D)  the SetProperty action 
A)  the Concat operator 
B)  the And operator 
C)  the Or operator 
D)  the SetProperty action

Question 15

Which action query would you use if you wanted to add records from one table to a backup table?

Accepted Answer

A)  Append query 
B)  Delete query 
C)  Backup query 
D)  Update query 
A)  Append query 
B)  Delete query 
C)  Backup query 
D)  Update query

Question 16

A _____ is a saved object within the database, whereas a _____ is temporary.

Accepted Answer

A)  criterion; wildcard 
B)  field; record 
C)  query; filter 
D)  selection; form 
A)  criterion; wildcard 
B)  field; record 
C)  query; filter 
D)  selection; form

Question 17

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

Accepted Answer

A)  You can print the Database Documenter reports. 
B)  You can save the Database Documenter reports in the database. 
C)  You can set an option to include table relationships in the reports. 
D)  You can set an option to include field property values in the reports. 
A)  You can print the Database Documenter reports. 
B)  You can save the Database Documenter reports in the database. 
C)  You can set an option to include table relationships in the reports. 
D)  You can set an option to include field property values in the reports.

Question 18

When you convert a macro, you break it down, step by step, to observe the effect of each action.

Accepted Answer

A) True 
 B)False

Question 19

To add a field to a report in Report Design view, you use the report's property sheet.

Accepted Answer

A) True 
 B)False

Question 20

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

How can you select all the labels in a report section when working in Report Design view?

A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Because the _____ section prints once for each record in the record source, you often shorten the section in Report Design view.

To close a form in Form Design view and keep Access running, you _____.

To which one of the following fields would you most likely apply the Percent format?

A(n) _____ is an individual step that a macro performs.

Which of the following join types select all the records from one table even if the related table does not have matching records? Select all the options that apply.

Michael wants to know if any records in the Clients table have no related records in the Projects table.Which query wizard should he use to find the answer?

Alan created a lookup field with two columns and wants to narrow the first column.Which property should he select on the Lookup tab in Table Design view?

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

What happens when you apply a theme to a form?

What must you use in a macro that performs an action if an employee's salary is greater than $50,000 and the performance rating is greater than 5?

Which action query would you use if you wanted to add records from one table to a backup table?

A _ is a saved object within the database, whereas a _ is temporary.

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

When you convert a macro, you break it down, step by step, to observe the effect of each action.

To add a field to a report in Report Design view, you use the report's property sheet.

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

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

How can you select all the labels in a report section when working in Report Design view?

A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.

Which of the following steps removes the Page Header and Page Footer sections from a report in Report Design view?

Because the _____ section prints once for each record in the record source, you often shorten the section in Report Design view.

To close a form in Form Design view and keep Access running, you _____.

To which one of the following fields would you most likely apply the Percent format?

A(n) _____ is an individual step that a macro performs.

Which of the following join types select all the records from one table even if the related table does not have matching records? Select all the options that apply.

Michael wants to know if any records in the Clients table have no related records in the Projects table.Which query wizard should he use to find the answer?

Alan created a lookup field with two columns and wants to narrow the first column.Which property should he select on the Lookup tab in Table Design view?

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

What happens when you apply a theme to a form?

What must you use in a macro that performs an action if an employee's salary is greater than $50,000 and the performance rating is greater than 5?

Which action query would you use if you wanted to add records from one table to a backup table?

A _____ is a saved object within the database, whereas a _____ is temporary.

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

When you convert a macro, you break it down, step by step, to observe the effect of each action.

To add a field to a report in Report Design view, you use the report's property sheet.

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

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

A _ is a saved object within the database, whereas a _ is temporary.