Question 1

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Accepted Answer

A)  Input Mask 
B)  Format 
C)  Visual Guide 
D)  Caption 
A)  Input Mask 
B)  Format 
C)  Visual Guide 
D)  Caption

Question 2

What should you do before applying a new filter to a datasheet?

Accepted Answer

A)  Switch to Query Design view. 
B)  Change the sort order of the records. 
C)  Save the previous filters. 
D)  Clear all previous filters. 
A)  Switch to Query Design view. 
B)  Change the sort order of the records. 
C)  Save the previous filters. 
D)  Clear all previous filters.

Question 3

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

Accepted Answer

A) True 
 B)False

Question 4

In the criterion 8/*/2021, the asterisk (*) is called a wildcard.

Accepted Answer

A) True 
 B)False

Question 5

Caitlin wants to assign the Before Update property of a form to a procedure.She clicks the Build button in the Before Update property and then clicks Expression Builder.

Accepted Answer

A) True 
 B)False

Question 6

What can you add to a query datasheet to display statistics for a group of records?

Accepted Answer

A)  Statistics row 
B)  grouping field 
C)  Total row 
D)  calculated field 
A)  Statistics row 
B)  grouping field 
C)  Total row 
D)  calculated field

Question 7

Which of the following is a startup command-line option?

Accepted Answer

A)  /repair 
B)  /excl 
C)  /open 
D)  /trust 
A)  /repair 
B)  /excl 
C)  /open 
D)  /trust

Question 8

When you use the Combo Box Wizard, you can have the combo box list the values from a table or query or you can _____.

Accepted Answer

A)  retrieve the values from a website 
B)  set the combo box to list random values 
C)  enter the values for the combo box 
D)  retrieve the values from a report 
A)  retrieve the values from a website 
B)  set the combo box to list random values 
C)  enter the values for the combo box 
D)  retrieve the values from a report

Question 9

A common example of delimited text file is a PDF file.

Accepted Answer

A) True 
 B)False

Question 10

On Click is an example of a(n) _____.

Accepted Answer

A)  event property 
B)  bound control 
C)  macro action 
D)  Command Button Wizard option 
A)  event property 
B)  bound control 
C)  macro action 
D)  Command Button Wizard option

Question 11

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

Accepted Answer

A)  modify the report's design 
B)  continue by creating a second report 
C)  send the report to a colleague 
D)  print the report 
A)  modify the report's design 
B)  continue by creating a second report 
C)  send the report to a colleague 
D)  print the report

Question 12

How can you add an action to a macro? Select all the options that apply.

Accepted Answer

A)  Double-click an action in the Action Catalog. 
B)  Click the Add New Action arrow. 
C)  Click the appropriate action button on the Macro Tools Design tab. 
D)  Drag an action from the Action Catalog. 
A)  Double-click an action in the Action Catalog. 
B)  Click the Add New Action arrow. 
C)  Click the appropriate action button on the Macro Tools Design tab. 
D)  Drag an action from the Action Catalog.

Question 13

An Access template is a diagram showing the structure of a database.

Accepted Answer

A) True 
 B)False

Question 14

In Report Design view, you can remove a control from a control layout by selecting the control and then _____.

Accepted Answer

A)  clicking the Stacked button on the Arrange tab 
B)  clicking the Control Margins button on the Arrange tab 
C)  dragging it to a blank area of the report 
D)  clicking the Remove Layout button on the Arrange tab 
A)  clicking the Stacked button on the Arrange tab 
B)  clicking the Control Margins button on the Arrange tab 
C)  dragging it to a blank area of the report 
D)  clicking the Remove Layout button on the Arrange tab

Question 15

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

Accepted Answer

A)  select 
B)  grouped 
C)  crosstab 
D)  calculated 
A)  select 
B)  grouped 
C)  crosstab 
D)  calculated

Question 16

In a datasheet, you can find data, but not replace it.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following are examples of correct criteria syntax? Select all the options that apply.

Accepted Answer

A)  = #1/1/2021# 
C)  < "Anderson" 
D)  <= 33.50 
A)  = #1/1/2021# 
C)  < "Anderson" 
D)  <= 33.50

Question 18

A Make-Table query is a type of _____ query that creates a new table of data.

Accepted Answer

A)  action 
B)  select 
C)  structured 
D)  create 
A)  action 
B)  select 
C)  structured 
D)  create

Question 19

If users must enter data in a LastName field, what property should you set for the field?

Accepted Answer

A)  Short Text 
B)  Required 
C)  Referential Integrity 
D)  Indexed 
A)  Short Text 
B)  Required 
C)  Referential Integrity 
D)  Indexed

Question 20

When you copy data from an external file into an Access database, you are importing the data.

Accepted Answer

A) True 
 B)False

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

What should you do before applying a new filter to a datasheet?

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

In the criterion 8//2021, the asterisk () is called a wildcard.

Caitlin wants to assign the Before Update property of a form to a procedure.She clicks the Build button in the Before Update property and then clicks Expression Builder.

What can you add to a query datasheet to display statistics for a group of records?

Which of the following is a startup command-line option?

When you use the Combo Box Wizard, you can have the combo box list the values from a table or query or you can _____.

A common example of delimited text file is a PDF file.

On Click is an example of a(n) _____.

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

How can you add an action to a macro? Select all the options that apply.

An Access template is a diagram showing the structure of a database.

In Report Design view, you can remove a control from a control layout by selecting the control and then _____.

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

In a datasheet, you can find data, but not replace it.

Which of the following are examples of correct criteria syntax? Select all the options that apply.

A Make-Table query is a type of _____ query that creates a new table of data.

If users must enter data in a LastName field, what property should you set for the field?

When you copy data from an external file into an Access database, you are importing the data.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

What should you do before applying a new filter to a datasheet?

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

In the criterion 8/*/2021, the asterisk (*) is called a wildcard.

Caitlin wants to assign the Before Update property of a form to a procedure.She clicks the Build button in the Before Update property and then clicks Expression Builder.

What can you add to a query datasheet to display statistics for a group of records?

Which of the following is a startup command-line option?

When you use the Combo Box Wizard, you can have the combo box list the values from a table or query or you can _____.

A common example of delimited text file is a PDF file.

On Click is an example of a(n) _____.

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

How can you add an action to a macro? Select all the options that apply.

An Access template is a diagram showing the structure of a database.

In Report Design view, you can remove a control from a control layout by selecting the control and then _____.

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

In a datasheet, you can find data, but not replace it.

Which of the following are examples of correct criteria syntax? Select all the options that apply.

A Make-Table query is a type of _____ query that creates a new table of data.

If users must enter data in a LastName field, what property should you set for the field?

When you copy data from an external file into an Access database, you are importing the data.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

In the criterion 8//2021, the asterisk () is called a wildcard.