Question 1

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 2

When you add actions to a Group program flow, the macro does not perform the actions.

Accepted Answer

A) True 
 B)False

Question 3

Why would you create a function in a standard module?

Accepted Answer

A)  To embed the function in the open form 
B)  To use the function in any query, form, or report in the database 
C)  To prepare for converting the function to a macro 
D)  To avoid having to use VBA syntax 
A)  To embed the function in the open form 
B)  To use the function in any query, form, or report in the database 
C)  To prepare for converting the function to a macro 
D)  To avoid having to use VBA syntax

Question 4

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

Accepted Answer

A)  AutoNumber 
B)  Short Text 
C)  Hours 
D)  Number 
A)  AutoNumber 
B)  Short Text 
C)  Hours 
D)  Number

Question 5

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

Accepted Answer

A) True 
 B)False

Question 6

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Accepted Answer

A)  You create a new module for the form. 
B)  Any modules attached to the form begin to run. 
C)  You display the VBA code for the form. 
D)  You add a standard module to the form. 
A)  You create a new module for the form. 
B)  Any modules attached to the form begin to run. 
C)  You display the VBA code for the form. 
D)  You add a standard module to the form.

Question 7

Access displays your user account information in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 8

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Accepted Answer

A) True 
 B)False

Question 9

After creating a report with the Report Wizard, you cannot add a sort to the report.

Accepted Answer

A) True 
 B)False

Question 10

In Report Design view, you add a field to a report using the _____.

Accepted Answer

A)  Navigation Pane 
B)  Report Setup dialog box 
C)  Group, Sort, and Total pane 
D)  Field List 
A)  Navigation Pane 
B)  Report Setup dialog box 
C)  Group, Sort, and Total pane 
D)  Field List

Question 11

You can right-click the status bar to display the _____.

Accepted Answer

A)  number of records in a table 
B)  Quick Access Toolbar shortcut menu 
C)  Database Views shortcut menu 
D)  Customize Status Bar shortcut menu 
A)  number of records in a table 
B)  Quick Access Toolbar shortcut menu 
C)  Database Views shortcut menu 
D)  Customize Status Bar shortcut menu

Question 12

An Append query adds selected records to an existing table.

Accepted Answer

A) True 
 B)False

Question 13

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

Accepted Answer

A)  index 
B)  blank string 
C)  validation text 
D)  zero-length string 
A)  index 
B)  blank string 
C)  validation text 
D)  zero-length string

Question 14

How can you send an Access object as an email attachment when you are working in an Access database ?

Accepted Answer

A)  Click the Email button on the External Data tab. 
B)  Click the File tab and then click Send. 
C)  Drag the form tab to an open email message. 
D)  Click the Attachment button on the Create tab. 
A)  Click the Email button on the External Data tab. 
B)  Click the File tab and then click Send. 
C)  Drag the form tab to an open email message. 
D)  Click the Attachment button on the Create tab.

Question 15

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

Accepted Answer

A)  NY; Default Value 
B)  State; Default Value 
C)  NY; Input Mask 
D)  State; Field Size 
A)  NY; Default Value 
B)  State; Default Value 
C)  NY; Input Mask 
D)  State; Field Size

Question 16

After editing a procedure, click the Reset button to execute the procedure.

Accepted Answer

A) True 
 B)False

Question 17

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

Accepted Answer

A)  Picture 
B)  Logo 
C)  Graphics 
D)  Image 
A)  Picture 
B)  Logo 
C)  Graphics 
D)  Image

Question 18

When you single step a macro, you _____.

Accepted Answer

A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument 
A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument

Question 19

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 20

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

Accepted Answer

A) True 
 B)False

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

When you add actions to a Group program flow, the macro does not perform the actions.

Why would you create a function in a standard module?

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Access displays your user account information in the Navigation Pane.

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

After creating a report with the Report Wizard, you cannot add a sort to the report.

In Report Design view, you add a field to a report using the _____.

You can right-click the status bar to display the _____.

An Append query adds selected records to an existing table.

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

How can you send an Access object as an email attachment when you are working in an Access database ?

If most records will contain "NY" in the State field, enter _ as the _ property for the State field.

After editing a procedure, click the Reset button to execute the procedure.

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

When you single step a macro, you _____.

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

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

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

When you add actions to a Group program flow, the macro does not perform the actions.

Why would you create a function in a standard module?

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

What happens if you display a form in Form Design View, and then click the Visual Basic button on the Database Tools tab?

Access displays your user account information in the Navigation Pane.

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

After creating a report with the Report Wizard, you cannot add a sort to the report.

In Report Design view, you add a field to a report using the _____.

You can right-click the status bar to display the _____.

An Append query adds selected records to an existing table.

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

How can you send an Access object as an email attachment when you are working in an Access database ?

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

After editing a procedure, click the Reset button to execute the procedure.

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

When you single step a macro, you _____.

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

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

If most records will contain "NY" in the State field, enter _ as the _ property for the State field.