Question 1

You can copy and paste any object in Access except for tables.

Accepted Answer

A) True 
 B)False

Question 2

A(n)  _____ chart best illustrates the contribution of three products to total company sales in a year.

Accepted Answer

A)   pie
B)   area
C)   line
D)   column

Question 3

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 layout

Question 4

A _____ chart typically shows trends over time.

Accepted Answer

A)   bar
B)   line
C)   column
D)   pie

Question 5

You use the Insert Rows button on the Query Tools Design tab to _____.

Accepted Answer

A)   insert a row in the query design grid
B)   insert a row in the selected field list
C)   insert a row in the query datasheet
D)   insert a new query design grid

Question 6

If the _____ property for a form control is set to No, the control cannot have the focus in Form view.

Accepted Answer

A)   Tab Order
B)   Enabled
C)   Visible
D)   Focus

Question 7

Create a(n)  _____ query to change the name of a supervisor in an Employee table.

Accepted Answer

A)   Make-Table
B)   Update
C)   Self-Join
D)   Target

Question 8

Where do you set the Allow Multiple Values property of a field in Table Design view?

Accepted Answer

A)   in the Data Type column of the upper pane
B)   on the Lookup tab of the Field Properties pane
C)   in the property sheet for the table
D)   in the Description column of the upper pane

Question 9

A mail merge combines data from an Access table or form into a Word form letter.

Accepted Answer

A) True 
 B)False

Question 10

The purpose of a Delete query is to _____.

Accepted Answer

A)   delete fields from a table
B)   correct errors in table records
C)   delete records from a table
D)   move records to a backup table

Question 11

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

Accepted Answer

A) True 
 B)False

Question 12

To create a report in Report Layout view, click the Blank Report button on the Create tab.

Accepted Answer

A) True 
 B)False

Question 13

What can you add to a query datasheet to display statistics for a group of records?

Accepted Answer

A)   Statistics row
B)   grouping field
C)   Total row
D)   calculated field

Question 14

The upper pane of _____ view shows field names and data types.

Accepted Answer

A)   Table Datasheet
B)   Query Design
C)   Table Tools
D)   Table Design

Question 15

You click the _____ button to execute the selected Access macro.

Accepted Answer

A)   Single Step
B)   Run
C)   Expand All
D)   Trigger

Question 16

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 17

The _____ property controls how many characters can be entered into the field.

Accepted Answer

A)   Format
B)   Required
C)   Input Mask
D)   Field Size

Question 18

When you create a table with a Make-Table query, you can store the new table _____.

Accepted Answer

A)   in the current database or another Access database
B)   in the current database only
C)   in another Access database only
D)   in any Excel workbook

Question 19

In a calculated control, expressions must start with what character?

Accepted Answer

A)   : colon
B)   [ left square bracket
C)   ( left parenthesis
D)   '= equal sign

Question 20

The report's _____ property identifies the table or query that provides the fields and records for a report.

Accepted Answer

A)   Group and Sort
B)   Conditional Formatting
C)   Format
D)   Record Source

Exam 1: Access 2019

In a calculated control, expressions must start with what character?

Correct AnswerverifiedShow Answer

The purpose of a Delete query is to _____.

Correct AnswerverifiedShow Answer

You can copy and paste any object in Access except for tables.

Correct AnswerverifiedShow Answer

You use the Insert Rows button on the Query Tools Design tab to _____.

Correct AnswerverifiedShow Answer

A _____ chart typically shows trends over time.

Correct AnswerverifiedShow Answer

Where do you set the Allow Multiple Values property of a field in Table Design view?

Correct AnswerverifiedShow Answer

To create a report in Report Layout view, click the Blank Report button on the Create tab.

Correct AnswerverifiedShow Answer

The report's _____ property identifies the table or query that provides the fields and records for a report.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Create a(n) _____ query to change the name of a supervisor in an Employee table.

Correct AnswerverifiedShow Answer

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

Correct AnswerverifiedShow Answer

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

Correct AnswerverifiedShow Answer

The upper pane of _____ view shows field names and data types.

Correct AnswerverifiedShow Answer

A mail merge combines data from an Access table or form into a Word form letter.

Correct AnswerverifiedShow Answer

What can you add to a query datasheet to display statistics for a group of records?

Correct AnswerverifiedShow Answer

The _____ property controls how many characters can be entered into the field.

Correct AnswerverifiedShow Answer

When you create a table with a Make-Table query, you can store the new table _____.

Correct AnswerverifiedShow Answer

If the _____ property for a form control is set to No, the control cannot have the focus in Form view.

Correct AnswerverifiedShow Answer

You click the _____ button to execute the selected Access macro.

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

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