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 
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

A foreign key is a field in one table th

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 
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 
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. 
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 
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

Students answers will vary. Some example

Question 20

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

Accepted Answer

A) True 
 B)False

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.

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.

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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.

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.

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters