Question 1

A table can only be sorted on a single field.

Accepted Answer

A) True 
 B)False  False

Question 2

The purpose of a database is to:

Accepted Answer

A)  manage, store, sort, and query information. 
B)  help provide access to the internet. 
C)  compose e-mail messages. 
D)  create presentations. 
A)  manage, store, sort, and query information. 
B)  help provide access to the internet. 
C)  compose e-mail messages. 
D)  create presentations. A

Question 3

Where are the changes to an Access table saved as soon as you move the insertion point?

Accepted Answer

A)  To memory 
B)  To a storage location 
C)  To the cloud 
D)  To the desktop 
A)  To memory 
B)  To a storage location 
C)  To the cloud 
D)  To the desktop B

Question 4

The Filter by Selection returns:

Accepted Answer

A)  only records matching the set criteria. 
B)  results filtered from a selected range. 
C)  specific query results. 
D)  any data with a comparison operator. 
A)  only records matching the set criteria. 
B)  results filtered from a selected range. 
C)  specific query results. 
D)  any data with a comparison operator.

Question 5

You can use Access to create a Web app for sharing data with others through the Internet.

Accepted Answer

A) True 
 B)False

Question 6

How does the Getting Started page help learn about a database?

Accepted Answer

A)  The Getting Started page links you to introductory Access videos. 
B)  The Getting Started page details how to install software. 
C)  The Getting Stated page explains what to do if your system crashes. 
D)  The Getting Stated page shows how to create relationships between tables. 
A)  The Getting Started page links you to introductory Access videos. 
B)  The Getting Started page details how to install software. 
C)  The Getting Stated page explains what to do if your system crashes. 
D)  The Getting Stated page shows how to create relationships between tables.

Question 7

Why is there a need to filter records?

Accepted Answer

A)  Filters scan for viruses. 
B)  Filters hide records that do match the criteria. 
C)  Filters speed up the CPU. 
D)  Filters reduce the file size. 
A)  Filters scan for viruses. 
B)  Filters hide records that do match the criteria. 
C)  Filters speed up the CPU. 
D)  Filters reduce the file size.

Question 8

In the Relationships window,join lines indicate the relationships between tables.

Accepted Answer

A) True 
 B)False

Question 9

Clicking Undo will restore a deleted record.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is NOT a method for creating a new database?

Accepted Answer

A)  A blank desktop database 
B)  A database from a style 
C)  A custom Web app 
D)  A database from a template 
A)  A blank desktop database 
B)  A database from a style 
C)  A custom Web app 
D)  A database from a template

Question 11

Why would you enforce referential integrity?

Accepted Answer

A)  To avoid accidental deletion of macros 
B)  So data cannot be entered into a related table until the data is entered in the primary table 
C)  To confirm error free data 
D)  To determine which software to use Excel or Access 
A)  To avoid accidental deletion of macros 
B)  So data cannot be entered into a related table until the data is entered in the primary table 
C)  To confirm error free data 
D)  To determine which software to use Excel or Access

Question 12

Which of the following is NOT an Access comparison operator?

Accepted Answer

A)  = 
D)  = 
A)  = 
D)  =

Question 13

What is an advantage of using Filter by Form?

Accepted Answer

A)  There is no minimum number of records that can be filtered. 
B)  You can use the AND and OR operators. 
C)  The records are also sorted. 
D)  Access automatically saves the results to storage. 
A)  There is no minimum number of records that can be filtered. 
B)  You can use the AND and OR operators. 
C)  The records are also sorted. 
D)  Access automatically saves the results to storage.

Question 14

Enforcing referential integrity ensures that no data are duplicated.

Accepted Answer

A) True 
 B)False

Question 15

You can use the Compact and Repair utility to help improve the performance of a database.

Accepted Answer

A) True 
 B)False

Question 16

When performing a filter by selection,equals and contains produce the same result.

Accepted Answer

A) True 
 B)False

Question 17

A ________ key is the field in the related table that you would use to connect to the primary key in another table.

Accepted Answer

A)  secondary 
B)  foreign 
C)  composite 
D)  merged 
A)  secondary 
B)  foreign 
C)  composite 
D)  merged

Question 18

What is a relationship?

Accepted Answer

A)  Two Excel spreadsheets with similar data 
B)  A database and a spreadsheet with similar data 
C)  Similar queries applied to the same table 
D)  A connection between two tables with a common field 
A)  Two Excel spreadsheets with similar data 
B)  A database and a spreadsheet with similar data 
C)  Similar queries applied to the same table 
D)  A connection between two tables with a common field

Question 19

Creating a desktop database using a theme saves creation time.

Accepted Answer

A) True 
 B)False

Question 20

Which one of the following objects allows users to add data to the database?

Accepted Answer

A)  Table 
B)  Record 
C)  Query 
D)  Form 
A)  Table 
B)  Record 
C)  Query 
D)  Form

Exam 1: Introduction to Access: Hands-On-Exercise Videos

A table can only be sorted on a single field.

The purpose of a database is to:

Where are the changes to an Access table saved as soon as you move the insertion point?

The Filter by Selection returns:

You can use Access to create a Web app for sharing data with others through the Internet.

How does the Getting Started page help learn about a database?

Why is there a need to filter records?

In the Relationships window,join lines indicate the relationships between tables.

Clicking Undo will restore a deleted record.

Which of the following is NOT a method for creating a new database?

Why would you enforce referential integrity?

Which of the following is NOT an Access comparison operator?

What is an advantage of using Filter by Form?

Enforcing referential integrity ensures that no data are duplicated.

You can use the Compact and Repair utility to help improve the performance of a database.

When performing a filter by selection,equals and contains produce the same result.

A ________ key is the field in the related table that you would use to connect to the primary key in another table.

What is a relationship?

Creating a desktop database using a theme saves creation time.

Which one of the following objects allows users to add data to the database?

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters