Question 1

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Accepted Answer

A)  Apply conditional formatting to the CustomerType text box. 
B)  Change the font color of the text "New" the first time it appears in the form. 
C)  Move the CustomerType text box to the top of the form. 
D)  Use the Format Painter to apply a highlight to the CustomerType text box. 
A)  Apply conditional formatting to the CustomerType text box. 
B)  Change the font color of the text "New" the first time it appears in the form. 
C)  Move the CustomerType text box to the top of the form. 
D)  Use the Format Painter to apply a highlight to the CustomerType text box.

Question 2

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

Accepted Answer

A)  You can change the orientation of the report to landscape. 
B)  You can change the theme colors in the report. 
C)  You can switch to Report view. 
D)  You can change the report to a different type of object. 
A)  You can change the orientation of the report to landscape. 
B)  You can change the theme colors in the report. 
C)  You can switch to Report view. 
D)  You can change the report to a different type of object.

Question 3

You must specify arguments for each action in a macro.

Accepted Answer

A) True 
 B)False

Question 4

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

Accepted Answer

A)  question mark 
B)  red asterisk 
C)  exclamation point 
D)  red X 
A)  question mark 
B)  red asterisk 
C)  exclamation point 
D)  red X

Question 5

The Action Catalog lists all of the macro actions organized by category.

Accepted Answer

A) True 
 B)False

Question 6

The Import Spreadsheet Wizard helps you import Excel data into Access.

Accepted Answer

A) True 
 B)False

Question 7

A field's Required property determines whether users must enter a value in the field.

Accepted Answer

A) True 
 B)False

Question 8

Use a Size option when you want to specify the exact height and width of two selected controls.

Accepted Answer

A) True 
 B)False

Question 9

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

Accepted Answer

A) True 
 B)False

Question 10

You can convert a form label to a hyperlink using the control's Web property.

Accepted Answer

A) True 
 B)False

Question 11

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

Accepted Answer

A)  750.25 
B)  750.2 
C)  750 
D)  751 
A)  750.25 
B)  750.2 
C)  750 
D)  751

Question 12

Sam created a self join between two copies of the Employees table and then renamed one copy Managers. When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?

Accepted Answer

A)  The datasheet lists employees with no managers. 
B)  The datasheet lists managers with no employees. 
C)  Employee last names are repeated many times because many employees report to the same managers. 
D)  Manager last names are repeated many times because many employees report to the same managers. 
A)  The datasheet lists employees with no managers. 
B)  The datasheet lists managers with no employees. 
C)  Employee last names are repeated many times because many employees report to the same managers. 
D)  Manager last names are repeated many times because many employees report to the same managers.

Question 13

In Form view, how can you navigate to the previous record in the form?

Accepted Answer

A)  Click the Back button on the Home tab. 
B)  Click the left arrow button on the left side of the form. 
C)  Click the Previous record button on the navigation bar. 
D)  Click the Previous button in the status bar. 
A)  Click the Back button on the Home tab. 
B)  Click the left arrow button on the left side of the form. 
C)  Click the Previous record button on the navigation bar. 
D)  Click the Previous button in the status bar.

Question 14

You must use the correct _____, or rules, when creating a VBA statement.

Accepted Answer

A)  syntax 
B)  executors 
C)  procedures 
D)  rubrics 
A)  syntax 
B)  executors 
C)  procedures 
D)  rubrics

Question 15

An Access query can be the _____ for a mail merge in Word.

Accepted Answer

A)  main document 
B)  merge field source 
C)  data source 
D)  template 
A)  main document 
B)  merge field source 
C)  data source 
D)  template

Question 16

Phil created a report based on a query named NewClients. What report property should he use to add a calculated field to the query?

Accepted Answer

A)  Build property 
B)  Expression property 
C)  Source Query property 
D)  Record Source property 
A)  Build property 
B)  Expression property 
C)  Source Query property 
D)  Record Source property

Question 17

If you delete the text box for the State field on a report, Access removes _____.

Accepted Answer

A)  the State text box and label 
B)  the State names from the underlying record source 
C)  only the State text box 
D)  the State field from the Field List 
A)  the State text box and label 
B)  the State names from the underlying record source 
C)  only the State text box 
D)  the State field from the Field List

Question 18

When you double-click a field in a field list in Query Design view, you _____.

Accepted Answer

A)  add the field to the query design grid 
B)  delete the field from the query 
C)  sort the query based on that field 
D)  set the field as the primary key 
A)  add the field to the query design grid 
B)  delete the field from the query 
C)  sort the query based on that field 
D)  set the field as the primary key

Question 19

What can you use to find information about Access commands and features and instructions about how to use them?

Accepted Answer

A)  Query Wizard 
B)  Access Wizard 
C)  Command box 
D)  Tell Me box 
A)  Query Wizard 
B)  Access Wizard 
C)  Command box 
D)  Tell Me box

Question 20

To add totals to a report column in Report Design view, you create a calculated control.

Accepted Answer

A) True 
 B)False

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

You must specify arguments for each action in a macro.

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

The Action Catalog lists all of the macro actions organized by category.

The Import Spreadsheet Wizard helps you import Excel data into Access.

A field's Required property determines whether users must enter a value in the field.

Use a Size option when you want to specify the exact height and width of two selected controls.

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

You can convert a form label to a hyperlink using the control's Web property.

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

Sam created a self join between two copies of the Employees table and then renamed one copy Managers. When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?

In Form view, how can you navigate to the previous record in the form?

You must use the correct _____, or rules, when creating a VBA statement.

An Access query can be the _____ for a mail merge in Word.

Phil created a report based on a query named NewClients. What report property should he use to add a calculated field to the query?

If you delete the text box for the State field on a report, Access removes _____.

When you double-click a field in a field list in Query Design view, you _____.

What can you use to find information about Access commands and features and instructions about how to use them?

To add totals to a report column in Report Design view, you create a calculated control.

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 1: Access 2019

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

You must specify arguments for each action in a macro.

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

The Action Catalog lists all of the macro actions organized by category.

The Import Spreadsheet Wizard helps you import Excel data into Access.

A field's Required property determines whether users must enter a value in the field.

Use a Size option when you want to specify the exact height and width of two selected controls.

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

You can convert a form label to a hyperlink using the control's Web property.

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

Sam created a self join between two copies of the Employees table and then renamed one copy Managers. When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?

In Form view, how can you navigate to the previous record in the form?

You must use the correct _____, or rules, when creating a VBA statement.

An Access query can be the _____ for a mail merge in Word.

Phil created a report based on a query named NewClients. What report property should he use to add a calculated field to the query?

If you delete the text box for the State field on a report, Access removes _____.

When you double-click a field in a field list in Query Design view, you _____.

What can you use to find information about Access commands and features and instructions about how to use them?

To add totals to a report column in Report Design view, you create a calculated control.

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters