Question 1

Which of the following are form events? Select all the options that apply.

Accepted Answer

A)   On Load
B)   On Close
C)   Before Print
D)   After Update

Question 2

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following types of files can Access import? Select all the options that apply.

Accepted Answer

A)   Excel (XLSX) 
B)   delimited text file (CSV) 
C)   portable document format (PDF) 
D)   Extensible Markup Language (XML)

Question 4

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

Accepted Answer

A)   Select the label and then click the Remove Layout button.
B)   Drag the label to a blank part of the form.
C)   Split the label horizontally or vertically.
D)   Snap the label to the grid.

Question 5

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 6

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

Accepted Answer

A)   linked tables
B)   object dependencies
C)   trusted folder
D)   Database Documenter report

Question 7

Access provides a single database template for creating a blank database.

Accepted Answer

A) True 
 B)False

Question 8

A customer has moved to a new address in the same city.What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Accepted Answer

A)   Simple Query Wizard
B)   Find and Replace
C)   Filter By Form
D)   query design grid

Question 9

In what part of the Access window do you rename a form?

Accepted Answer

A)   Navigation Pane
B)   Form view of the form
C)   Print preview of the form
D)   Backstage view

Question 10

Microsoft Access can best be described as ____ software.

Accepted Answer

A)   spreadsheet
B)   relationship
C)   utility
D)   database

Question 11

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

Accepted Answer

A)   Anchoring
B)   Size/Space
C)   Control Margins
D)   Align

Question 12

A category of data such as a customer's name, city, state, or phone number is called a _____.

Accepted Answer

A)   record
B)   table
C)   data type
D)   field

Question 13

Which of the following are steps in designing related tables in a relational database? Select all the options that apply.

Accepted Answer

A)   Design each table to contain fields that describe only one subject.
B)   Keep all data in one large table.
C)   Identify a primary key field for each table.
D)   Build one-to-many relationships between tables.

Question 14

You can assign most but not all data types to a field in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 15

You can use the Chart Wizard to add a chart to a form or query.

Accepted Answer

A) True 
 B)False

Question 16

In VBA, comments appear in _____ text.

Accepted Answer

A)   green
B)   red
C)   blue
D)   black

Question 17

When using the Form Wizard, you can select fields from tables and _____ in the database.

Accepted Answer

A)   other forms
B)   reports
C)   themes
D)   queries

Question 18

Which of the following controls can serve as hyperlink controls? Select all the options that apply.

Accepted Answer

A)   logo
B)   command button
C)   text box
D)   label

Question 19

You can display page numbers on a report in a "Page 1 of 2" format.

Accepted Answer

A) True 
 B)False

Question 20

Actions you take in Query Design view automatically update in _____.

Accepted Answer

A)   Table Design view
B)   SQL view
C)   VBA view
D)   Query Update view

Exam 8: Access

In what part of the Access window do you rename a form?

Correct AnswerverifiedShow Answer

Which of the following controls can serve as hyperlink controls? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following are steps in designing related tables in a relational database? Select all the options that apply.

Correct AnswerverifiedShow Answer

In VBA, comments appear in _____ text.

Correct AnswerverifiedShow Answer

You can use the Chart Wizard to add a chart to a form or query.

Correct AnswerverifiedShow Answer

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Correct AnswerverifiedShow Answer

A customer has moved to a new address in the same city.What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Correct AnswerverifiedShow Answer

When using the Form Wizard, you can select fields from tables and _____ in the database.

Correct AnswerverifiedShow Answer

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

Correct AnswerverifiedShow Answer

A category of data such as a customer's name, city, state, or phone number is called a _____.

Correct AnswerverifiedShow Answer

Access provides a single database template for creating a blank database.

Correct AnswerverifiedShow Answer

You can display page numbers on a report in a "Page 1 of 2" format.

Correct AnswerverifiedShow Answer

You can assign most but not all data types to a field in Table Datasheet view.

Correct AnswerverifiedShow Answer

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

Correct AnswerverifiedShow Answer

Which of the following are form events? Select all the options that apply.

Correct AnswerverifiedShow Answer

Actions you take in Query Design view automatically update in _____.

Correct AnswerverifiedShow Answer

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

Correct AnswerverifiedShow Answer

Microsoft Access can best be described as ____ software.

Correct AnswerverifiedShow Answer

The purpose of a Delete query is to _____.

Correct AnswerverifiedShow Answer

Which of the following types of files can Access import? Select all the options that apply.

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