Question 1

Filter by Selection displays only records that match a criterion that you select.

Accepted Answer

A) True 
 B)False

Question 2

Use ________ if you have a large amount of data and may need to group, sort, and total the data based on various parameters.

Accepted Answer

The answer of Use ________ if you have a large...

Question 3

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

Accepted Answer

A)  referential integrity key 
B)  relational database 
C)  foreign key 
D)  primary2 key

Question 4

Match between columns
                        Premises: Backstage view
Quick Access Toolbar
title bar
Ribbon
Dialog Box Launcher

Accepted Answer

The Answer of easy access to commonly executed tasks and is...

Question 5

A complete set of all fields about one person or event is called a field.

Accepted Answer

A) True 
 B)False

Question 6

A filter and a sort always produce the same results in an Access database.

Accepted Answer

A) True 
 B)False

Question 7

Enforcing referential integrity ensures that no data are duplicated.

Accepted Answer

A) True 
 B)False

Question 8

What is a foreign key? Provide an example.

Accepted Answer

The answer of What is a foreign key? Provide an...

Question 9

A(n) ________ system is a software system that offers tools needed to create, maintain, and use a database.

Accepted Answer

The answer of A(n) ________ system is a software system...

Question 10

Of the following, which is NOT a main object type in an Access database?

Accepted Answer

A)  Report 
B)  Form 
C)  Macro 
D)  Record

Question 11

Access can sort records by more than one field.

Accepted Answer

A) True 
 B)False

Question 12

Like Access, Excel can be used to manage large quantities of data.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is an object that adds functionality to a database and is written using VBA?

Accepted Answer

A)  Macro 
B)  Module 
C)  Query 
D)  Report

Question 14

A primary key may use a(n) ________ data type--a generated primary key that is automatically incremented each time a record is added.

Accepted Answer

The answer of A primary key may use a(n) ________...

Question 15

Access can create relationships between two tables; Excel cannot.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ________ is a collection of fields that describe something, such as a person, place, event, or idea.

Accepted Answer

The answer of A(n) ________ is a collection of fields...

Question 17

An Access database can MOST accurately be described as a structured collection of:

Accepted Answer

A)  tables. 
B)  objects. 
C)  records. 
D)  modules.

Question 18

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

Question 19

Offer three examples of interactions that you may have had with databases (knowingly or unknowingly) within the last week.

Accepted Answer

The answer of Offer three examples of interactions that you...

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 1: Introduction to Access: Finding Your Way Through an Access Database

Filter by Selection displays only records that match a criterion that you select.

Use ________ if you have a large amount of data and may need to group, sort, and total the data based on various parameters.

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

Match the following components of Office 2013 and their function:

A complete set of all fields about one person or event is called a field.

A filter and a sort always produce the same results in an Access database.

Enforcing referential integrity ensures that no data are duplicated.

What is a foreign key? Provide an example.

A(n) ________ system is a software system that offers tools needed to create, maintain, and use a database.

Of the following, which is NOT a main object type in an Access database?

Access can sort records by more than one field.

Like Access, Excel can be used to manage large quantities of data.

Which of the following is an object that adds functionality to a database and is written using VBA?

A primary key may use a(n) ________ data type--a generated primary key that is automatically incremented each time a record is added.

Access can create relationships between two tables; Excel cannot.

A(n) ________ is a collection of fields that describe something, such as a person, place, event, or idea.

An Access database can MOST accurately be described as a structured collection of:

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

Offer three examples of interactions that you may have had with databases (knowingly or unknowingly) within the last week.

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