Question 1

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

Accepted Answer

A)  Option Compare Database 
B)  On Text GoTo 
C)  Select Case 
D)  Option Sort Text 
A)  Option Compare Database 
B)  On Text GoTo 
C)  Select Case 
D)  Option Sort Text

Question 2

How can you list the records in a query datasheet in A-Z order by CustomerName?

Accepted Answer

A)  Click a value in the CustomerName field, and then click the Descending button. 
B)  Click a value in the CustomerName field, and then click the Ascending button. 
C)  Click the Advanced button, and then click Filter By Form. 
D)  Click the CustomerName column heading. 
A)  Click a value in the CustomerName field, and then click the Descending button. 
B)  Click a value in the CustomerName field, and then click the Ascending button. 
C)  Click the Advanced button, and then click Filter By Form. 
D)  Click the CustomerName column heading.

Question 3

To export query data to Excel, you _____.

Accepted Answer

A)  save the query as an XLSX file 
B)  click the Create tab, and then click the Excel Query button in the Queries group 
C)  click the External Data tab, and then click the Excel button in the Export group 
D)  select Excel as the destination when you run the query 
A)  save the query as an XLSX file 
B)  click the Create tab, and then click the Excel Query button in the Queries group 
C)  click the External Data tab, and then click the Excel button in the Export group 
D)  select Excel as the destination when you run the query

Question 4

_____ change depending on the macro action you choose.

Accepted Answer

A)  Events 
B)  Arguments 
C)  Expressions 
D)  Properties 
A)  Events 
B)  Arguments 
C)  Expressions 
D)  Properties

Question 5

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 6

Which of the following is a comment you could add to a VBA procedure?

Accepted Answer

A)  'The Discount function has two arguments. 
B)  COM The Discount function has two arguments. 
C)  "The Discount function has two arguments. 
D)  //The Discount function has two arguments. 
A)  'The Discount function has two arguments. 
B)  COM The Discount function has two arguments. 
C)  "The Discount function has two arguments. 
D)  //The Discount function has two arguments.

Question 7

Trusting a database means to verify the authenticity of a database with a digital signature.

Accepted Answer

A) True 
 B)False

Question 8

To center the text in a selected form control in Form Layout view, you _____.

Accepted Answer

A)  click the Align button on the Home tab, and then click Align Center 
B)  click the Arrange Center button on the Form Tools Layout Arrange tab 
C)  click the Formatting arrow on the Home tab, and then click Align Center 
D)  click the Center button on the Home tab 
A)  click the Align button on the Home tab, and then click Align Center 
B)  click the Arrange Center button on the Form Tools Layout Arrange tab 
C)  click the Formatting arrow on the Home tab, and then click Align Center 
D)  click the Center button on the Home tab

Question 9

What data type should you assign to a WeeklySalary field?

Accepted Answer

A)  Currency 
B)  Salary 
C)  Number 
D)  Date/Time 
A)  Currency 
B)  Salary 
C)  Number 
D)  Date/Time

Question 10

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

Accepted Answer

A)  field 
B)  record 
C)  data type 
D)  property 
A)  field 
B)  record 
C)  data type 
D)  property

Question 11

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 12

To have form users select one of three options, add a(n) _____ to the form.

Accepted Answer

A)  text box 
B)  toggle button 
C)  option group 
D)  tab control 
A)  text box 
B)  toggle button 
C)  option group 
D)  tab control

Question 13

When you add a field to a table in Table Design view, entering the field name is optional.

Accepted Answer

A) True 
 B)False

Question 14

Which data type stores email addresses?

Accepted Answer

A)  Web 
B)  URL 
C)  HTML 
D)  Hyperlink 
A)  Web 
B)  URL 
C)  HTML 
D)  Hyperlink

Question 15

The Performance Analyzer recommends how you can improve database performance.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following commands aligns text in the center of a label control?

Accepted Answer

A)  Center 
B)  Align to Grid 
C)  Align Middle 
D)  Stretch Across 
A)  Center 
B)  Align to Grid 
C)  Align Middle 
D)  Stretch Across

Question 17

Where can you set a field's Default Value in Table Design view?

Accepted Answer

A)  in the Description column 
B)  in the Validation dialog box 
C)  on the Lookup tab 
D)  in the Field Properties pane 
A)  in the Description column 
B)  in the Validation dialog box 
C)  on the Lookup tab 
D)  in the Field Properties pane

Question 18

OpenReport is an Access macro _____.

Accepted Answer

A)  event 
B)  condition 
C)  action 
D)  group 
A)  event 
B)  condition 
C)  action 
D)  group

Question 19

The Record Source property for a form identifies the fields and records to display on the form.

Accepted Answer

A) True 
 B)False

Question 20

You use the _____ to organize controls in a three-dimensional or layered presentation on a form.

Accepted Answer

A)  Combo Box 
B)  Tab Control 
C)  Text Box 
D)  Command Button 
A)  Combo Box 
B)  Tab Control 
C)  Text Box 
D)  Command Button

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

How can you list the records in a query datasheet in A-Z order by CustomerName?

To export query data to Excel, you _____.

_____ change depending on the macro action you choose.

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

Which of the following is a comment you could add to a VBA procedure?

Trusting a database means to verify the authenticity of a database with a digital signature.

To center the text in a selected form control in Form Layout view, you _____.

What data type should you assign to a WeeklySalary field?

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

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

To have form users select one of three options, add a(n) _____ to the form.

When you add a field to a table in Table Design view, entering the field name is optional.

Which data type stores email addresses?

The Performance Analyzer recommends how you can improve database performance.

Which of the following commands aligns text in the center of a label control?

Where can you set a field's Default Value in Table Design view?

OpenReport is an Access macro _____.

The Record Source property for a form identifies the fields and records to display on the form.

You use the _____ to organize controls in a three-dimensional or layered presentation on a form.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

Which of the following VBA keywords is a declaration statement that determines the way string values (text) will be sorted?

How can you list the records in a query datasheet in A-Z order by CustomerName?

To export query data to Excel, you _____.

_____ change depending on the macro action you choose.

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

Which of the following is a comment you could add to a VBA procedure?

Trusting a database means to verify the authenticity of a database with a digital signature.

To center the text in a selected form control in Form Layout view, you _____.

What data type should you assign to a WeeklySalary field?

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

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

To have form users select one of three options, add a(n) _____ to the form.

When you add a field to a table in Table Design view, entering the field name is optional.

Which data type stores email addresses?

The Performance Analyzer recommends how you can improve database performance.

Which of the following commands aligns text in the center of a label control?

Where can you set a field's Default Value in Table Design view?

OpenReport is an Access macro _____.

The Record Source property for a form identifies the fields and records to display on the form.

You use the _____ to organize controls in a three-dimensional or layered presentation on a form.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters