Question 1

You can freeze one or more fields in a datasheet so they remain visible at all times.

Accepted Answer

A) True 
 B)False

Question 2

When do most class modules run?

Accepted Answer

A)   When you double-click a module in the Navigation Pane
B)   After all the standard modules finish running
C)   When you double-click a macro in the Navigation Pane
D)   In response to an event such as clicking a command button

Question 3

Objects you add to custom groups in the Navigation Pane are _____.

Accepted Answer

A)   displayed temporarily
B)   shortcuts to the actual objects
C)   displayed with a custom (*)  icon
D)   copies of the objects

Question 4

_____ is the default name for a new table in an Access database.

Accepted Answer

A)   Table1
B)   NewTable
C)   Table
D)   TableA

Question 5

In a macro, a Group component lets you sort macro arguments.

Accepted Answer

A) True 
 B)False

Question 6

A field with the Currency data type contains values such as quantities, measurements, and scores.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

When you remove a control layout from a report, Access _____.

Accepted Answer

A)   removes the controls from the report
B)   changes the arrangement of the controls
C)   displays an error message
D)   no longer groups the controls together in the report

Question 9

Compacting a database has the same result as backing up a database.

Accepted Answer

A) True 
 B)False

Question 10

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

Accepted Answer

A) True 
 B)False

Question 11

A(n)  _____ procedure manipulates controls and objects.

Accepted Answer

A)   class
B)   action
C)   sub
D)   method

Question 12

To set a validation rule for an entire table, you _____.

Accepted Answer

A)   use the Field Properties pane in Table Design view
B)   use the Conditional Formatting Rules Manager dialog box
C)   open the property sheet for the field list in the Relationships window
D)   open the property sheet for the table

Question 13

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

Question 14

To back up a database, you use the _____ command.

Accepted Answer

A)   Make a Backup
B)   Back Up Database
C)   Package and Sign
D)   Compact & Repair

Question 15

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

Accepted Answer

A) True 
 B)False

Question 16

To select records from the Customers table that have no related records in the Sales table, create a(n)  _____ join.

Accepted Answer

A)   inner
B)   outer
C)   self
D)   referential

Question 17

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

Accepted Answer

A) True 
 B)False

Question 18

To close a macro, you click the Run button.

Accepted Answer

A) True 
 B)False

Question 19

You use the _____ to organize controls in a three-dimensional or layered presentation on a form.

Accepted Answer

A)   Combo Box
B)   Tab Control
C)   Text Box
D)   Command Button

Question 20

When you add a field to a table in Table Design view, entering the field name is optional.

Accepted Answer

A) True 
 B)False

Exam 1: Access-2019

To set a validation rule for an entire table, you _____.

Correct AnswerverifiedShow Answer

_____ is the default name for a new table in an Access database.

Correct AnswerverifiedShow Answer

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

Correct AnswerverifiedShow Answer

To back up a database, you use the _____ command.

Correct AnswerverifiedShow Answer

A field with the Currency data type contains values such as quantities, measurements, and scores.

Correct AnswerverifiedShow Answer

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

Correct AnswerverifiedShow Answer

A(n) _____ procedure manipulates controls and objects.

Correct AnswerverifiedShow Answer

In a macro, a Group component lets you sort macro arguments.

Correct AnswerverifiedShow Answer

To close a macro, you click the Run button.

Correct AnswerverifiedShow Answer

When do most class modules run?

Correct AnswerverifiedShow Answer

You can freeze one or more fields in a datasheet so they remain visible at all times.

Correct AnswerverifiedShow Answer

When you add a field to a table in Table Design view, entering the field name is optional.

Correct AnswerverifiedShow Answer

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

Correct AnswerverifiedShow Answer

When you remove a control layout from a report, Access _____.

Correct AnswerverifiedShow Answer

Compacting a database has the same result as backing up a database.

Correct AnswerverifiedShow Answer

Objects you add to custom groups in the Navigation Pane are _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

Correct AnswerverifiedShow Answer

You use the _____ to organize controls in a three-dimensional or layered presentation on a form.

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