Question 1

You use a double quotation mark to begin a comment.

Accepted Answer

A) True 
 B)False

Question 2

You can use the _____ action to send the DOWN ARROW keystroke to a list box control.

Accepted Answer

A)  SendKeys 
B)  AutoKeystroke 
C)  KeyCombo 
D)  DownArrow

Question 3

You click the _____ button to close the Filter by Form grid.

Accepted Answer

A)  Delete 
B)  Advanced 
C)  Selection 
D)  Toggle Filter

Question 4

You can collapse all actions in a macro to hide its details.

Accepted Answer

A) True 
 B)False

Question 5

How can you display the indexes for a table?

Accepted Answer

A)  In Table Datasheet view, click the Show Hidden Properties button. 
B)  In Table Design view, click the Indexes button. 
C)  In Table Design view, click the Properties button. 
D)  In Table Datasheet view, click the Object Dependencies button.

Question 6

When you drag the column heading of a field to a new location in Table Datasheet view, what change are you making to the table?

Accepted Answer

A)  You are moving the field in the table structure. 
B)  You are removing the field from the table. 
C)  You are sorting the records in the table. 
D)  You are rearranging only the display of the fields in Table Datasheet view.

Question 7

You write VBA code in the Visual Basic Design Pane .

Accepted Answer

A) True 
 B)False

Question 8

Creating a table in Design view involves entering the field names and defining the _____ for the fields.

Accepted Answer

A)  properties 
B)  purpose 
C)  appearance 
D)  criteria

Question 9

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

Accepted Answer

A)  record selector 
B)  field list 
C)  field selector 
D)  Criteria row

Question 10

The Allow Zero Length property is set to Yes by default for fields of which data type?

Accepted Answer

A)  Short Text 
B)  Yes/No 
C)  AutoNumber 
D)  Date/Time

Question 11

A database in a trusted folder enables all database content, including all macros and VBA.

Accepted Answer

A) True 
 B)False

Question 12

Use the _____ Table Manager to manage a split database.

Accepted Answer

A)  Split 
B)  Datasheet 
C)  Linked 
D)  Front-End

Question 13

What should you do when you are finished working a database?

Accepted Answer

A)  Open and then save each object in the database. 
B)  Close the Navigation Pane. 
C)  Sign out so other people can use the database. 
D)  Close the database.

Question 14

Click the ____ button in Form Design view to remove an adjustment you don't want to keep.

Accepted Answer

A)  Delete 
B)  Compact 
C)  Redo 
D)  Undo

Question 15

What happens when you run a query from Query Design view?

Accepted Answer

A)  Access displays the query in Print Preview. 
B)  Access clears the query design grid. 
C)  Access creates a report based on the query. 
D)  Access displays a datasheet containing the query results.

Question 16

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

Accepted Answer

A)  A one-to-many relationship 
B)  A common field 
C)  Referential integrity 
D)  Data redundancy

Question 17

When you import Excel data, you create a link to the data in the Access database.

Accepted Answer

A) True 
 B)False

Question 18

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

Accepted Answer

A) True 
 B)False

Question 19

To show an amount such as 750.25 in a Number field, which of the following properties should you set?

Accepted Answer

A)  Caption 
B)  Field Size 
C)  Decimal Places 
D)  Default Value

Question 20

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

Exam 1: Access 2019

You use a double quotation mark to begin a comment.

You can use the _____ action to send the DOWN ARROW keystroke to a list box control.

You click the _____ button to close the Filter by Form grid.

You can collapse all actions in a macro to hide its details.

How can you display the indexes for a table?

When you drag the column heading of a field to a new location in Table Datasheet view, what change are you making to the table?

You write VBA code in the Visual Basic Design Pane .

Creating a table in Design view involves entering the field names and defining the _____ for the fields.

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

The Allow Zero Length property is set to Yes by default for fields of which data type?

A database in a trusted folder enables all database content, including all macros and VBA.

Use the _____ Table Manager to manage a split database.

What should you do when you are finished working a database?

Click the ____ button in Form Design view to remove an adjustment you don't want to keep.

What happens when you run a query from Query Design view?

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

When you import Excel data, you create a link to the data in the Access database.

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

To show an amount such as 750.25 in a Number field, which of the following properties should you set?

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