Question 1

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

Accepted Answer

A)  Report Design view 
B)  Report view 
C)  Print Preview 
D)  Report Layout view 
A)  Report Design view 
B)  Report view 
C)  Print Preview 
D)  Report Layout view

Question 2

ToWhat tool do you use to set the sort orders for records in a report?

Accepted Answer

A)  Sort cell in the report design grid 
B)  Group, Sort, and Total pane 
C)  Tab Order dialog box 
D)  Ascending or Descending button on the Page Setup tab 
A)  Sort cell in the report design grid 
B)  Group, Sort, and Total pane 
C)  Tab Order dialog box 
D)  Ascending or Descending button on the Page Setup tab

Question 3

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Accepted Answer

A)  Null OR Not "New York" 
B)  Is Not Null OR "New York" 
C)  Not "New York" 
D)  Is Null OR Not "New York" 
A)  Null OR Not "New York" 
B)  Is Not Null OR "New York" 
C)  Not "New York" 
D)  Is Null OR Not "New York"

Question 4

Mail fields are codes that Word replaces with field values when processing a mail merge.

Accepted Answer

A) True 
 B)False

Question 5

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

Accepted Answer

A) True 
 B)False

Question 6

The report's _____ property identifies the table or query that provides the fields and records for a report.

Accepted Answer

A)  Group and Sort 
B)  Conditional Formatting 
C)  Format 
D)  Record Source 
A)  Group and Sort 
B)  Conditional Formatting 
C)  Format 
D)  Record Source

Question 7

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 8

Which argument of the MessageBox macro action determines the text in the message dialog box?

Accepted Answer

A)  Message 
B)  View 
C)  Title 
D)  Type 
A)  Message 
B)  View 
C)  Title 
D)  Type

Question 9

How do you display the results of a query listed in the Navigation Pane?

Accepted Answer

A)  Right-click the query, and then click Design View on the shortcut menu. 
B)  Right-click the query, and then click Run on the shortcut menu. 
C)  Double-click the query. 
D)  Click the query, and then click the Open button in the Navigation Pane. 
A)  Right-click the query, and then click Design View on the shortcut menu. 
B)  Right-click the query, and then click Run on the shortcut menu. 
C)  Double-click the query. 
D)  Click the query, and then click the Open button in the Navigation Pane.

Question 10

In Query Design view, how can you add a field to the query design grid?

Accepted Answer

A)  Right-click the query design grid, and then click the field's name. 
B)  Double-click the field in the field list. 
C)  Click the field in the field list, and then click the Add to Grid button. 
D)  Double-click the first available field in the query design grid. 
A)  Right-click the query design grid, and then click the field's name. 
B)  Double-click the field in the field list. 
C)  Click the field in the field list, and then click the Add to Grid button. 
D)  Double-click the first available field in the query design grid.

Question 11

Use the Default field property to specify that an entry is required for the field.

Accepted Answer

A) True 
 B)False

Question 12

You can remove a control layout from a form in Form Design view or Form Layout view.

Accepted Answer

A) True 
 B)False

Question 13

Conditional formatting can change the appearance of a report control based on criteria you specify.

Accepted Answer

A) True 
 B)False

Question 14

Before using the Chart Wizard, you should plan which fields you want the chart to display.

Accepted Answer

A) True 
 B)False

Question 15

Where do you paste a copied query?

Accepted Answer

A)  at the end of a query datasheet 
B)  in the Navigation Pane 
C)  in Query Design view 
D)  on an object tab for any query 
A)  at the end of a query datasheet 
B)  in the Navigation Pane 
C)  in Query Design view 
D)  on an object tab for any query

Question 16

When does Access save changes you make to a record?

Accepted Answer

A)  when you click the Save button 
B)  when you close the table 
C)  when you move to a different record 
D)  when you select the record 
A)  when you click the Save button 
B)  when you close the table 
C)  when you move to a different record 
D)  when you select the record

Question 17

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

Accepted Answer

A)  XSD 
B)  XLSX 
C)  XP 
D)  HTML 
A)  XSD 
B)  XLSX 
C)  XP 
D)  HTML

Question 18

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

Accepted Answer

A)  click a control in the layout 
B)  click the Selection button on the Home tab 
C)  click the vertical ruler next to the layout 
D)  switch to Form view 
A)  click a control in the layout 
B)  click the Selection button on the Home tab 
C)  click the vertical ruler next to the layout 
D)  switch to Form view

Question 19

To change the background color of a form control in Form Design view, you use the _____ button.

Accepted Answer

A)  Shape Outline 
B)  Shape Fill 
C)  Row Color 
D)  Form Color 
A)  Shape Outline 
B)  Shape Fill 
C)  Row Color 
D)  Form Color

Question 20

One reason to split a database is to improve performance .

Accepted Answer

A) True 
 B)False

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

ToWhat tool do you use to set the sort orders for records in a report?

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Mail fields are codes that Word replaces with field values when processing a mail merge.

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

The report's _____ property identifies the table or query that provides the fields and records for a report.

What is the result of using the Database Documenter?

Which argument of the MessageBox macro action determines the text in the message dialog box?

How do you display the results of a query listed in the Navigation Pane?

In Query Design view, how can you add a field to the query design grid?

Use the Default field property to specify that an entry is required for the field.

You can remove a control layout from a form in Form Design view or Form Layout view.

Conditional formatting can change the appearance of a report control based on criteria you specify.

Before using the Chart Wizard, you should plan which fields you want the chart to display.

Where do you paste a copied query?

When does Access save changes you make to a record?

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

To change the background color of a form control in Form Design view, you use the _____ button.

One reason to split a database is to improve performance .

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

ToWhat tool do you use to set the sort orders for records in a report?

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Mail fields are codes that Word replaces with field values when processing a mail merge.

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

The report's _____ property identifies the table or query that provides the fields and records for a report.

What is the result of using the Database Documenter?

Which argument of the MessageBox macro action determines the text in the message dialog box?

How do you display the results of a query listed in the Navigation Pane?

In Query Design view, how can you add a field to the query design grid?

Use the Default field property to specify that an entry is required for the field.

You can remove a control layout from a form in Form Design view or Form Layout view.

Conditional formatting can change the appearance of a report control based on criteria you specify.

Before using the Chart Wizard, you should plan which fields you want the chart to display.

Where do you paste a copied query?

When does Access save changes you make to a record?

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

To change the background color of a form control in Form Design view, you use the _____ button.

One reason to split a database is to improve performance .

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters