Question 1

Class modules are stored in an individual form or report.

Accepted Answer

A) True 
 B)False

Question 2

_____ a database means to identify the database file as safe to open.

Accepted Answer

A)  Securing 
B)  Enabling 
C)  Trusting 
D)  Splitting 
A)  Securing 
B)  Enabling 
C)  Trusting 
D)  Splitting

Question 3

To navigate records in Form view, you use the buttons on the _____.

Accepted Answer

A)  navigation bar 
B)  Navigation Pane 
C)  Home tab 
D)  record bar 
A)  navigation bar 
B)  Navigation Pane 
C)  Home tab 
D)  record bar

Question 4

The_____ Lookup property determines whether a lookup field accepts new values or only those in the lookup list.

Accepted Answer

A)  Limit to List 
B)  Display Control 
C)  Row Source 
D)  List Width 
A)  Limit to List 
B)  Display Control 
C)  Row Source 
D)  List Width

Question 5

A _____ allows you to work with records related to the record in the main form.

Accepted Answer

A)  subform 
B)  hyperlink 
C)  background form 
D)  related form 
A)  subform 
B)  hyperlink 
C)  background form 
D)  related form

Question 6

When does the After Update table event run?

Accepted Answer

A)  After you change the table design 
B)  After you insert a new record in the table 
C)  After you change an existing record 
D)  After you run an Update query 
A)  After you change the table design 
B)  After you insert a new record in the table 
C)  After you change an existing record 
D)  After you run an Update query

Question 7

How can you create a backup of a macro?

Accepted Answer

A)  Use the Backup command in Backstage View. 
B)  Use the Backup command in Action Catalog. 
C)  Convert it to a report in the Navigation Pane. 
D)  Copy and paste a macro in the Navigation Pane. 
A)  Use the Backup command in Backstage View. 
B)  Use the Backup command in Action Catalog. 
C)  Convert it to a report in the Navigation Pane. 
D)  Copy and paste a macro in the Navigation Pane.

Question 8

You can retain a history of changes to a _____ field.

Accepted Answer

A)  Date/Time 
B)  Yes/No 
C)  Long Text 
D)  Number 
A)  Date/Time 
B)  Yes/No 
C)  Long Text 
D)  Number

Question 9

How do you select a row in a control layout in Report Layout view?

Accepted Answer

A)  Click the row selector. 
B)  Click to the left of the row. 
C)  Drag to select the controls in the row. 
D)  Press and hold the SHIFT key, and then click a control in the row. 
A)  Click the row selector. 
B)  Click to the left of the row. 
C)  Drag to select the controls in the row. 
D)  Press and hold the SHIFT key, and then click a control in the row.

Question 10

Which of the following are properties you can set for a field? Select all the options that apply.

Accepted Answer

A)  Font Color 
B)  Field Name 
C)  Field Size 
D)  Data Type 
A)  Font Color 
B)  Field Name 
C)  Field Size 
D)  Data Type

Question 11

Which of the following is a valid entry for the Tab Stop property of a form control?

Accepted Answer

A)  1 
B)  First 
C)  Auto 
D)  Yes 
A)  1 
B)  First 
C)  Auto 
D)  Yes

Question 12

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

Accepted Answer

A) True 
 B)False

Question 13

If you want to manage lists of data about customers and the products they order, use _____ software.

Accepted Answer

A)  spreadsheet 
B)  relational database 
C)  tabular 
D)  communication 
A)  spreadsheet 
B)  relational database 
C)  tabular 
D)  communication

Question 14

Which of the following are Access objects?

Accepted Answer

A)  forms 
B)  spreadsheets 
C)  reports 
D)  queries 
A)  forms 
B)  spreadsheets 
C)  reports 
D)  queries

Question 15

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

Accepted Answer

A) True 
 B)False

Question 16

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

Accepted Answer

A) True 
 B)False

Question 17

You modify the Default View property to change the form layout.

Accepted Answer

A) True 
 B)False

Question 18

To resize a selected control in Report Design view, you can use the _____.

Accepted Answer

A)  horizontal resize pointer 
B)  Width box on the Format tab 
C)  default white arrow mouse pointer 
D)  Control Size button on the Arrange tab 
A)  horizontal resize pointer 
B)  Width box on the Format tab 
C)  default white arrow mouse pointer 
D)  Control Size button on the Arrange tab

Question 19

Which of the following does NOT save changes made to a record?

Accepted Answer

A)  When you click the Save button 
B)  When you close the datasheet 
C)  When you move to another record 
D)  As you move from field to field in the same record 
A)  When you click the Save button 
B)  When you close the datasheet 
C)  When you move to another record 
D)  As you move from field to field in the same record

Question 20

Where do you manage data macros in Access?

Accepted Answer

A)  In the Navigation Pane 
B)  In Table Design View or Table Datasheet View 
C)  In Macro Design View 
D)  On the Database Tools tab of the ribbon 
A)  In the Navigation Pane 
B)  In Table Design View or Table Datasheet View 
C)  In Macro Design View 
D)  On the Database Tools tab of the ribbon

Class modules are stored in an individual form or report.

_____ a database means to identify the database file as safe to open.

To navigate records in Form view, you use the buttons on the _____.

The_____ Lookup property determines whether a lookup field accepts new values or only those in the lookup list.

A _____ allows you to work with records related to the record in the main form.

When does the After Update table event run?

How can you create a backup of a macro?

You can retain a history of changes to a _____ field.

How do you select a row in a control layout in Report Layout view?

Which of the following are properties you can set for a field? Select all the options that apply.

Which of the following is a valid entry for the Tab Stop property of a form control?

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

If you want to manage lists of data about customers and the products they order, use _____ software.

Which of the following are Access objects?

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

You modify the Default View property to change the form layout.

To resize a selected control in Report Design view, you can use the _____.

Which of the following does NOT save changes made to a record?

Where do you manage data macros in Access?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

Class modules are stored in an individual form or report.

_____ a database means to identify the database file as safe to open.

To navigate records in Form view, you use the buttons on the _____.

The_____ Lookup property determines whether a lookup field accepts new values or only those in the lookup list.

A _____ allows you to work with records related to the record in the main form.

When does the After Update table event run?

How can you create a backup of a macro?

You can retain a history of changes to a _____ field.

How do you select a row in a control layout in Report Layout view?

Which of the following are properties you can set for a field? Select all the options that apply.

Which of the following is a valid entry for the Tab Stop property of a form control?

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

If you want to manage lists of data about customers and the products they order, use _____ software.

Which of the following are Access objects?

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

You modify the Default View property to change the form layout.

To resize a selected control in Report Design view, you can use the _____.

Which of the following does NOT save changes made to a record?

Where do you manage data macros in Access?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters