Question 1

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 2

On a form, text box controls display data from an underlying record source.

Accepted Answer

A) True 
 B)False

Question 3

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

Accepted Answer

A) True 
 B)False

Question 4

To quickly remove all Lookup properties from a field, change the Display Control property to _____.

Accepted Answer

A)  Label 
B)  Combo Box 
C)  Text Box 
D)  List Box 
A)  Label 
B)  Combo Box 
C)  Text Box 
D)  List Box

Question 5

Keith wants to keep the records for each customer together in his custom report. Which of the following set of steps will organize the report the way he wants?

Accepted Answer

A)  Open the Group, Sort, and Total pane, click the Keep Together button, and then click CustomerName. 
B)  Open the Group, Sort, and Total pane, click the Add a group button, and then click CustomerName. 
C)  Right-click the CustomerName field in the report, click Layout, and then click Keep Together. 
D)  Click the CustomerName field in the report, click the Arrange tab, and then click Group. 
A)  Open the Group, Sort, and Total pane, click the Keep Together button, and then click CustomerName. 
B)  Open the Group, Sort, and Total pane, click the Add a group button, and then click CustomerName. 
C)  Right-click the CustomerName field in the report, click Layout, and then click Keep Together. 
D)  Click the CustomerName field in the report, click the Arrange tab, and then click Group.

Question 6

If you often sort on a field, you should set its_____ property to Yes.

Accepted Answer

A)  Required 
B)  Caption 
C)  Bound Column 
D)  Indexed 
A)  Required 
B)  Caption 
C)  Bound Column 
D)  Indexed

Question 7

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

Accepted Answer

A)  password 
B)  startup option 
C)  permission 
D)  share list 
A)  password 
B)  startup option 
C)  permission 
D)  share list

Question 8

Use Query Design view to display the results of a query.

Accepted Answer

A) True 
 B)False

Question 9

As you create a report, when might you want to work in Report Layout view?

Accepted Answer

A)  When you want to view the report as it will appear when printed. 
B)  When you want to hide the data and concentrate on the report design. 
C)  When you want to view the report without any formatting. 
D)  When you want to view the data as you change the report. 
A)  When you want to view the report as it will appear when printed. 
B)  When you want to hide the data and concentrate on the report design. 
C)  When you want to view the report without any formatting. 
D)  When you want to view the data as you change the report.

Question 10

A front-end database contains _____ to the tables in the back-end database.

Accepted Answer

A)  updates 
B)  links 
C)  relationships 
D)  maps 
A)  updates 
B)  links 
C)  relationships 
D)  maps

Question 11

When you _____ a database, you make more storage space available and enhance the performance of the database.

Accepted Answer

A)  back up 
B)  trust and verify 
C)  analyze 
D)  compact and repair 
A)  back up 
B)  trust and verify 
C)  analyze 
D)  compact and repair

Question 12

A _____ module is stored as a part of the form or report in which it was created.

Accepted Answer

A)  global 
B)  class 
C)  standard 
D)  sub 
A)  global 
B)  class 
C)  standard 
D)  sub

Question 13

To close a macro, you click the Run button.

Accepted Answer

A) True 
 B)False

Question 14

You can _____ an Access database into a back-end database and front-end database.

Accepted Answer

A)  split 
B)  convert 
C)  backup 
D)  reconfigure 
A)  split 
B)  convert 
C)  backup 
D)  reconfigure

Question 15

You can double-click a column heading in Report Layout view to edit the column heading text.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following types of forms displays records in Form view and Datasheet view at the same time?

Accepted Answer

A)  Navigation form 
B)  Split form 
C)  Dual form 
D)  Multiple Items form 
A)  Navigation form 
B)  Split form 
C)  Dual form 
D)  Multiple Items form

Question 17

To remove filter criteria from the Filter by Form grid, you _____.

Accepted Answer

A)  open a new form 
B)  click the Advanced button, and then click Clear All Filters 
C)  click the Toggle Filter button 
D)  click the Filter by Form button, and then click Clear 
A)  open a new form 
B)  click the Advanced button, and then click Clear All Filters 
C)  click the Toggle Filter button 
D)  click the Filter by Form button, and then click Clear

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which data type is used for sequential integers controlled by Access?

Accepted Answer

A)  Number 
B)  AutoNumber 
C)  SeqNumber 
D)  Integer 
A)  Number 
B)  AutoNumber 
C)  SeqNumber 
D)  Integer

Question 20

Run the steps in a saved export using the _____ button on the External Data tab.

Accepted Answer

A)  Saved Exports 
B)  More 
C)  Synchronize 
D)  Rerun 
A)  Saved Exports 
B)  More 
C)  Synchronize 
D)  Rerun

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

On a form, text box controls display data from an underlying record source.

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

To quickly remove all Lookup properties from a field, change the Display Control property to _____.

Keith wants to keep the records for each customer together in his custom report. Which of the following set of steps will organize the report the way he wants?

If you often sort on a field, you should set its_____ property to Yes.

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

Use Query Design view to display the results of a query.

As you create a report, when might you want to work in Report Layout view?

A front-end database contains _____ to the tables in the back-end database.

When you _____ a database, you make more storage space available and enhance the performance of the database.

A _____ module is stored as a part of the form or report in which it was created.

To close a macro, you click the Run button.

You can _____ an Access database into a back-end database and front-end database.

You can double-click a column heading in Report Layout view to edit the column heading text.

Which of the following types of forms displays records in Form view and Datasheet view at the same time?

To remove filter criteria from the Filter by Form grid, you _____.

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

Which data type is used for sequential integers controlled by Access?

Run the steps in a saved export using the _____ button on the External Data tab.

Excel 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 1: Access 2019

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

On a form, text box controls display data from an underlying record source.

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

To quickly remove all Lookup properties from a field, change the Display Control property to _____.

Keith wants to keep the records for each customer together in his custom report. Which of the following set of steps will organize the report the way he wants?

If you often sort on a field, you should set its_____ property to Yes.

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

Use Query Design view to display the results of a query.

As you create a report, when might you want to work in Report Layout view?

A front-end database contains _____ to the tables in the back-end database.

When you _____ a database, you make more storage space available and enhance the performance of the database.

A _____ module is stored as a part of the form or report in which it was created.

To close a macro, you click the Run button.

You can _____ an Access database into a back-end database and front-end database.

You can double-click a column heading in Report Layout view to edit the column heading text.

Which of the following types of forms displays records in Form view and Datasheet view at the same time?

To remove filter criteria from the Filter by Form grid, you _____.

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

Which data type is used for sequential integers controlled by Access?

Run the steps in a saved export using the _____ button on the External Data tab.

Excel 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters