Question 1

Use the _____ to exit Access.

Accepted Answer

A)   Close button
B)   Exit command in Backstage view
C)   Exit & Repair button
D)   Save buttonE) A) and B)
F) None of the above

Question 2

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

Accepted Answer

A)   As the first action in the macro
B)   After the OpenForm action
C)   As the last action in the macro
D)   Before the OpenForm actionE) A) and B)
F) A) and C)

Question 3

Which Access object contains all of the data in the database?

Accepted Answer

A)   form
B)   macro
C)   table
D)   queryE) None of the above
F) C) and D)

Question 4

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Accepted Answer

A) True 
 B)False

Question 5

How do you create a macro in Access?

Accepted Answer

A)   Use the Macro Wizard to select a task to perform.
B)   Use the macro recorder to record your actions as you complete a task.
C)   In Macro Design View, add actions and arguments that perform a task.
D)   Use the single step recorder to record your actions as you complete a task.E) A) and D)
F) A) and B)

Question 6

Connor wants to display records for orders placed before January 1, 2020. Which of the following criteria should he use in the OrderDate field in Query Design view?

Accepted Answer

A)  
B)  
C)   
D)  E) All of the above
F) None of the above

Question 7

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

Accepted Answer

A)   Select query with a self join.
B)   Update query.
C)   Select query with an outer join.
D)   Append query.E) B) and C)
F) A) and C)

Question 8

If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.

Accepted Answer

A)   tab order
B)   sort order
C)   focus grouping
D)   form layoutE) B) and C)
F) B) and D)

Question 9

A(n)  _____ file contains field values separated by a common character such as a comma or tab.

Accepted Answer

A)   CSV
B)   ODBC
C)   XML
D)   RTFE) A) and B)
F) A) and C)

Question 10

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 11

When you delete a bound text box, you often also delete its label .

Accepted Answer

A) True 
 B)False

Question 12

In an If statement, the _____ follows the keyword Else.

Accepted Answer

A)   otherwise group
B)   true-statement group
C)   false-statement group
D)   null statement groupE) A) and B)
F) B) and C)

Question 13

An index is a list that relates field values to the records that contain those field values.

Accepted Answer

A) True 
 B)False

Question 14

One way to _____ a macro is to single step through the macro.

Accepted Answer

A)   modify
B)   rename
C)   program
D)   testE) C) and D)
F) B) and D)

Question 15

What should you do if you want to make a copy of a database in a secure location?

Accepted Answer

A)   Back up the database.
B)   Compact and repair the database
C)   Convert the database.
D)   Split the database.E) B) and D)
F) A) and C)

Question 16

In Table Datasheet view, a(n)  _____ shows related records from other tables in the datasheet.

Accepted Answer

A)   infinity symbol
B)   field list
C)   subdatasheet
D)   primary key symbolE) None of the above
F) A) and B)

Question 17

If you freeze the first field in a table datasheet, it remains displayed as you scroll to the right.

Accepted Answer

A) True 
 B)False

Question 18

_____ are statements in the code that document the code and do not affect how it runs.

Accepted Answer

A)   Methods
B)   Variables
C)   Comment lines
D)   Blue keywordsE) B) and C)
F) A) and B)

Question 19

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 20

Felicia wants to copy the formatting of the Address label to the City label. She clicks the Address label, clicks the _____ button, and then clicks the City label.

Accepted Answer

A)   Copy
B)   Format Painter
C)   Design
D)   Apply FormatsE) A) and D)
F) None of the above

Exam 1: Access 2019

When you delete a bound text box, you often also delete its label .

Correct AnswerverifiedShow Answer

Connor wants to display records for orders placed before January 1, 2020. Which of the following criteria should he use in the OrderDate field in Query Design view?

Correct AnswerverifiedShow Answer

One way to _____ a macro is to single step through the macro.

Correct AnswerverifiedShow Answer

If you freeze the first field in a table datasheet, it remains displayed as you scroll to the right.

Correct AnswerverifiedShow Answer

An index is a list that relates field values to the records that contain those field values.

Correct AnswerverifiedShow Answer

If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.

Correct AnswerverifiedShow Answer

Felicia wants to copy the formatting of the Address label to the City label. She clicks the Address label, clicks the _____ button, and then clicks the City label.

Correct AnswerverifiedShow Answer

In Table Datasheet view, a(n) _____ shows related records from other tables in the datasheet.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How do you create a macro in Access?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

_____ are statements in the code that document the code and do not affect how it runs.

Correct AnswerverifiedShow Answer

In an If statement, the _____ follows the keyword Else.

Correct AnswerverifiedShow Answer

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

Correct AnswerverifiedShow Answer

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

Correct AnswerverifiedShow Answer

Use the _____ to exit Access.

Correct AnswerverifiedShow Answer

A(n) _____ file contains field values separated by a common character such as a comma or tab.

Correct AnswerverifiedShow Answer

Which Access object contains all of the data in the database?

Correct AnswerverifiedShow Answer

What should you do if you want to make a copy of a database in a secure location?

Correct AnswerverifiedShow Answer

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified