Question 1

If you are displaying values from two fields in a combo box, you can change the _____ property of the combo box control to display both values in the list.

Accepted Answer

A)  Column Count 
B)  Format 
C)  Display When 
D)  Layout 
A)  Column Count 
B)  Format 
C)  Display When 
D)  Layout

Question 2

Hiding a column in Table Datasheet view is that same as freezing the column.

Accepted Answer

A) True 
 B)False

Question 3

In which one of the following views can you edit the text in a label?

Accepted Answer

A)  Print Preview 
B)  Report Layout view 
C)  Report view 
D)  SQL view 
A)  Print Preview 
B)  Report Layout view 
C)  Report view 
D)  SQL view

Question 4

You use the _____ to create a query that finds records in one table that do not have related records in another table.

Accepted Answer

A)  Find Duplicates Query Wizard 
B)  Find Unmatched Query Wizard 
C)  Crosstab Query Wizard 
D)  Select Orphans Query Wizard 
A)  Find Duplicates Query Wizard 
B)  Find Unmatched Query Wizard 
C)  Crosstab Query Wizard 
D)  Select Orphans Query Wizard

Question 5

Conditional formatting can change the appearance of a report control based on criteria you specify.

Accepted Answer

A) True 
 B)False

Question 6

When you edit a record, pressing ESC once removes the changes to the field.What happens if you press ESC a second time?

Accepted Answer

A)  Access restores the changes to the field. 
B)  Access deletes the record. 
C)  Access deletes the field. 
D)  Access removes all changes to the record. 
A)  Access restores the changes to the field. 
B)  Access deletes the record. 
C)  Access deletes the field. 
D)  Access removes all changes to the record.

Question 7

Which of the following are valid table events for a data macro? Select all the options that apply.

Accepted Answer

A)  After Update 
B)  Before Delete 
C)  After Got Focus 
D)  After Insert 
A)  After Update 
B)  Before Delete 
C)  After Got Focus 
D)  After Insert

Question 8

Which of the following are sources Access can import data from? Select all the options that apply.

Accepted Answer

A)  dBase 
B)  Excel 
C)  PDF 
D)  HTML 
A)  dBase 
B)  Excel 
C)  PDF 
D)  HTML

Question 9

Which field property do you use to change a lookup field to a regular field?

Accepted Answer

A)  Display Control 
B)  Column Heads 
C)  Allow Multiple Values 
D)  Caption 
A)  Display Control 
B)  Column Heads 
C)  Allow Multiple Values 
D)  Caption

Question 10

When you enter new records, you add them to the end of the datasheet.

Accepted Answer

A) True 
 B)False

Question 11

How is the font set for a table in Table Datasheet view?

Accepted Answer

A)  Access controls the font automatically. 
B)  You use the Format box on the Table Tools Design tab. 
C)  Access prompts you for the font when you create the table. 
D)  You use the Font box on the Home tab. 
A)  Access controls the font automatically. 
B)  You use the Format box on the Table Tools Design tab. 
C)  Access prompts you for the font when you create the table. 
D)  You use the Font box on the Home tab.

Question 12

What can you do to hide the actions in a macro?

Accepted Answer

A)  Collapse all the actions in the macro. 
B)  Single step through the macro. 
C)  Set the macro's Visible property to No. 
D)  Add a Group program flow to the macro. 
A)  Collapse all the actions in the macro. 
B)  Single step through the macro. 
C)  Set the macro's Visible property to No. 
D)  Add a Group program flow to the macro.

Question 13

Which of the following changes makes a datasheet easier to read?

Accepted Answer

A)  Change the field sizes in Table Design view. 
B)  Increase the font size. 
C)  Add new records. 
D)  Reset table relationships. 
A)  Change the field sizes in Table Design view. 
B)  Increase the font size. 
C)  Add new records. 
D)  Reset table relationships.

Question 14

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

Accepted Answer

A) True 
 B)False

Question 15

What is the advantage of grouping controls on a form?

Accepted Answer

A)  They look more attractive on the form. 
B)  You automatically organize them into difference sections. 
C)  You can apply the same changes to the controls all at once. 
D)  You can sort the controls within the group. 
A)  They look more attractive on the form. 
B)  You automatically organize them into difference sections. 
C)  You can apply the same changes to the controls all at once. 
D)  You can sort the controls within the group.

Question 16

In a CSV text file, a comma often separates each field value from another field value.

Accepted Answer

A) True 
 B)False

Question 17

A join line is also called a _____ line.

Accepted Answer

A)  query 
B)  connection 
C)  link 
D)  property 
A)  query 
B)  connection 
C)  link 
D)  property

Question 18

For two tables that have a(n) _____ join, a query will select all the records in the "one" table even if they do not have matching records in the "many" table.

Accepted Answer

A)  inner 
B)  self 
C)  right outer 
D)  left outer 
A)  inner 
B)  self 
C)  right outer 
D)  left outer

Question 19

The Import Spreadsheet Wizard can help you import data from Excel into a new Access table.

Accepted Answer

A) True 
 B)False

Question 20

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Accepted Answer

A)  syntax 
B)  run-time 
C)  logic 
D)  compile-time 
A)  syntax 
B)  run-time 
C)  logic 
D)  compile-time

If you are displaying values from two fields in a combo box, you can change the _____ property of the combo box control to display both values in the list.

Hiding a column in Table Datasheet view is that same as freezing the column.

In which one of the following views can you edit the text in a label?

You use the _____ to create a query that finds records in one table that do not have related records in another table.

Conditional formatting can change the appearance of a report control based on criteria you specify.

When you edit a record, pressing ESC once removes the changes to the field.What happens if you press ESC a second time?

Which of the following are valid table events for a data macro? Select all the options that apply.

Which of the following are sources Access can import data from? Select all the options that apply.

Which field property do you use to change a lookup field to a regular field?

When you enter new records, you add them to the end of the datasheet.

How is the font set for a table in Table Datasheet view?

What can you do to hide the actions in a macro?

Which of the following changes makes a datasheet easier to read?

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

What is the advantage of grouping controls on a form?

In a CSV text file, a comma often separates each field value from another field value.

A join line is also called a _____ line.

For two tables that have a(n) _____ join, a query will select all the records in the "one" table even if they do not have matching records in the "many" table.

The Import Spreadsheet Wizard can help you import data from Excel into a new Access table.

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

If you are displaying values from two fields in a combo box, you can change the _____ property of the combo box control to display both values in the list.

Hiding a column in Table Datasheet view is that same as freezing the column.

In which one of the following views can you edit the text in a label?

You use the _____ to create a query that finds records in one table that do not have related records in another table.

Conditional formatting can change the appearance of a report control based on criteria you specify.

When you edit a record, pressing ESC once removes the changes to the field.What happens if you press ESC a second time?

Which of the following are valid table events for a data macro? Select all the options that apply.

Which of the following are sources Access can import data from? Select all the options that apply.

Which field property do you use to change a lookup field to a regular field?

When you enter new records, you add them to the end of the datasheet.

How is the font set for a table in Table Datasheet view?

What can you do to hide the actions in a macro?

Which of the following changes makes a datasheet easier to read?

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

What is the advantage of grouping controls on a form?

In a CSV text file, a comma often separates each field value from another field value.

A join line is also called a _____ line.

For two tables that have a(n) _____ join, a query will select all the records in the "one" table even if they do not have matching records in the "many" table.

The Import Spreadsheet Wizard can help you import data from Excel into a new Access table.

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters