Question 1

If you export a report as a PDF file, other people can edit the report.

Accepted Answer

A) True 
 B)False

Question 2

You can add fields to a form in Design view or _____.

Accepted Answer

A)  Layout view 
B)  Form view 
C)  Print Preview 
D)  Datasheet view 
A)  Layout view 
B)  Form view 
C)  Print Preview 
D)  Datasheet view

Question 3

An HTML document is a text file that uses _____ to mark up content stored in the file.

Accepted Answer

A)  rich text formatting 
B)  conditional formatting 
C)  XML tags 
D)  HTML tags 
A)  rich text formatting 
B)  conditional formatting 
C)  XML tags 
D)  HTML tags

Question 4

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a difference between Table Design view and Table Datasheet view?

Accepted Answer

A)  Table Datasheet view does not display data. 
B)  Table Design view displays table relationships. 
C)  Table Design view does not display data. 
D)  Table Datasheet view does not allow changes. 
A)  Table Datasheet view does not display data. 
B)  Table Design view displays table relationships. 
C)  Table Design view does not display data. 
D)  Table Datasheet view does not allow changes.

Question 6

When you display the Visual Basic window, one line is highlighted in yellow.What does that mean?

Accepted Answer

A)  The code cannot run successfully. 
B)  The yellow line will change data when you run the code. 
C)  A new section of the code starts after the yellow line. 
D)  An error has been corrected automatically. 
A)  The code cannot run successfully. 
B)  The yellow line will change data when you run the code. 
C)  A new section of the code starts after the yellow line. 
D)  An error has been corrected automatically.

Question 7

A(n) event is a procedure that returns a value.

Accepted Answer

A) True 
 B)False

Question 8

Which control provides consistent descriptive text as you navigate from record to record in a form?

Accepted Answer

A)  text box 
B)  label 
C)  combo box 
D)  tab control 
A)  text box 
B)  label 
C)  combo box 
D)  tab control

Question 9

You could use "Madison" as the criterion for a Yes/No field.

Accepted Answer

A) True 
 B)False

Question 10

When you split an Access database, what do you call the database containing all the tables?

Accepted Answer

A)  Front-end database 
B)  File-server database 
C)  Back-end database 
D)  Back-up database 
A)  Front-end database 
B)  File-server database 
C)  Back-end database 
D)  Back-up database

Question 11

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

Accepted Answer

A) True 
 B)False

Question 12

You primarily use the Form Wizard to create a form to _____.

Accepted Answer

A)  print but not edit database content, 
B)  enter and update data 
C)  answer questions about the information in the database 
D)  automate repetitive tasks 
A)  print but not edit database content, 
B)  enter and update data 
C)  answer questions about the information in the database 
D)  automate repetitive tasks

Question 13

Which of the following statements creates a function named Bonus with an argument named Salary?

Accepted Answer

A)  Bonus(Salary) = Function 
B)  Function Bonus(Salary) 
C)  Function (Bonus, Salary) 
D)  '=Function(Bonus, Salary) 
A)  Bonus(Salary) = Function 
B)  Function Bonus(Salary) 
C)  Function (Bonus, Salary) 
D)  '=Function(Bonus, Salary)

Question 14

Which of the following events would trigger a data macro?

Accepted Answer

A)  After Insert 
B)  On Got Focus 
C)  OpenReport 
D)  SetProperty 
A)  After Insert 
B)  On Got Focus 
C)  OpenReport 
D)  SetProperty

Question 15

To change the text displayed on the report tab, you set the _____ property of the report.

Accepted Answer

A)  Name 
B)  Record Source 
C)  Tab 
D)  Caption 
A)  Name 
B)  Record Source 
C)  Tab 
D)  Caption

Question 16

Set the Database Title property of a database to change the text displayed in the title bar.

Accepted Answer

A) True 
 B)False

Question 17

What must you do before renaming a table in the Navigation Pane?

Accepted Answer

A)  Refresh the Navigation Pane. 
B)  Close the table 
C)  Open the table. 
D)  Assign a primary key to the table. 
A)  Refresh the Navigation Pane. 
B)  Close the table 
C)  Open the table. 
D)  Assign a primary key to the table.

Question 18

Changing the title of a report in Report Layout view also changes the name of the report.

Accepted Answer

A) True 
 B)False

Question 19

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

Accepted Answer

A) True 
 B)False

Question 20

Field properties appear on the General tab in the lower half of _____ view.

Accepted Answer

A)  Table Datasheet 
B)  Form 
C)  Table Design 
D)  Query Datasheet 
A)  Table Datasheet 
B)  Form 
C)  Table Design 
D)  Query Datasheet

If you export a report as a PDF file, other people can edit the report.

You can add fields to a form in Design view or _____.

An HTML document is a text file that uses _____ to mark up content stored in the file.

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

Which of the following is a difference between Table Design view and Table Datasheet view?

When you display the Visual Basic window, one line is highlighted in yellow.What does that mean?

A(n) event is a procedure that returns a value.

Which control provides consistent descriptive text as you navigate from record to record in a form?

You could use "Madison" as the criterion for a Yes/No field.

When you split an Access database, what do you call the database containing all the tables?

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

You primarily use the Form Wizard to create a form to _____.

Which of the following statements creates a function named Bonus with an argument named Salary?

Which of the following events would trigger a data macro?

To change the text displayed on the report tab, you set the _____ property of the report.

Set the Database Title property of a database to change the text displayed in the title bar.

What must you do before renaming a table in the Navigation Pane?

Changing the title of a report in Report Layout view also changes the name of the report.

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

Field properties appear on the General tab in the lower half of _____ view.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

If you export a report as a PDF file, other people can edit the report.

You can add fields to a form in Design view or _____.

An HTML document is a text file that uses _____ to mark up content stored in the file.

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

Which of the following is a difference between Table Design view and Table Datasheet view?

When you display the Visual Basic window, one line is highlighted in yellow.What does that mean?

A(n) event is a procedure that returns a value.

Which control provides consistent descriptive text as you navigate from record to record in a form?

You could use "Madison" as the criterion for a Yes/No field.

When you split an Access database, what do you call the database containing all the tables?

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

You primarily use the Form Wizard to create a form to _____.

Which of the following statements creates a function named Bonus with an argument named Salary?

Which of the following events would trigger a data macro?

To change the text displayed on the report tab, you set the _____ property of the report.

Set the Database Title property of a database to change the text displayed in the title bar.

What must you do before renaming a table in the Navigation Pane?

Changing the title of a report in Report Layout view also changes the name of the report.

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

Field properties appear on the General tab in the lower half of _____ view.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters