Question 1

A relational database has the ability to create relationships between two:

Accepted Answer

A)  forms. 
B)  fields. 
C)  files. 
D)  tables. 
A)  forms. 
B)  fields. 
C)  files. 
D)  tables. D

Question 2

Access differs from other Microsoft software because it:

Accepted Answer

A)  works primarily from memory. 
B)  works primarily from storage. 
C)  does not save your work as soon as changes are made. 
D)  does not allow more than one user to work on a file at a time. 
A)  works primarily from memory. 
B)  works primarily from storage. 
C)  does not save your work as soon as changes are made. 
D)  does not allow more than one user to work on a file at a time. B

Question 3

Match between columns
                        Premises: access Backstage view
tab that automatically displays when a file is opened
create a footer in Word
change the zoom level
change margins in Word

Accepted Answer

The Answer of File tab and View tab and Page is...

Question 4

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.

Question 5

Which of the following best describes information?

Accepted Answer

A)  Information is a converted into fields and records within a table in a database. 
B)  Information is converted into data that can be selected and sorted for business or personal use. 
C)  Information is what is entered into a database. 
D)  Information is the finished product that is produced by a database. 
A)  Information is a converted into fields and records within a table in a database. 
B)  Information is converted into data that can be selected and sorted for business or personal use. 
C)  Information is what is entered into a database. 
D)  Information is the finished product that is produced by a database.

Question 6

Clicking Undo will restore a deleted record.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan's requirements. He should use the Filter by Form ________ condition.

Accepted Answer

A)  query 
B)  sort 
C)  OR 
D)  AND 
A)  query 
B)  sort 
C)  OR 
D)  AND

Question 9

Describe comparison operators in Access.

Accepted Answer

A comparison operator is used to evaluat

Question 10

When forming relationships in a relational database, the ________ from one table must be joined to the foreign key of another table.

Accepted Answer

The answer of When forming relationships in a relational database,...

Question 11

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:

Accepted Answer

A)  Filter by Form. 
B)  Filter by Selection. 
C)  Sort Ascending. 
D)  Sort Descending. 
A)  Filter by Form. 
B)  Filter by Selection. 
C)  Sort Ascending. 
D)  Sort Descending.

Question 12

Which of the following is NOT a tab in Access 2013?

Accepted Answer

A)  Create 
B)  Home 
C)  Format 
D)  File 
A)  Create 
B)  Home 
C)  Format 
D)  File

Question 13

In relational databases, there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

Accepted Answer

referentia

Question 14

People use databases to store collections of data.

Accepted Answer

A) True 
 B)False

Question 15

Match the following terms to their meanings:
I. ascending
II. descending
III. field properties
IV. primary key
V. AutoNumber
A. field that is unique
B. define the characteristics for more detail
C. generated by Access and is automatically incremented each time a record is added
D. sorts a list of numeric data in lowest to highest order
E. sorts a list of text data in Z to A order

Accepted Answer

The answer of Match the following terms to their meanings:
I....

Question 16

Enforce referential integrity is one of only two options available when setting a database relationship with another database.

Accepted Answer

A) True 
 B)False

Question 17

The Undo button does not reverse the most recent change in Access 2013.

Accepted Answer

A) True 
 B)False

Question 18

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

Accepted Answer

A)  query 
B)  sort 
C)  OR 
D)  AND 
A)  query 
B)  sort 
C)  OR 
D)  AND

Question 19

Which of the following is NOT a main object type in an Access database?

Accepted Answer

A)  Template 
B)  Query 
C)  Table 
D)  Module 
A)  Template 
B)  Query 
C)  Table 
D)  Module

Question 20

Information is what is typically entered into a database. Data is the finished product of the database.

Accepted Answer

A) True 
 B)False

A relational database has the ability to create relationships between two:

Access differs from other Microsoft software because it:

The purpose of a database is to:

Which of the following best describes information?

Clicking Undo will restore a deleted record.

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

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan's requirements. He should use the Filter by Form ________ condition.

Describe comparison operators in Access.

When forming relationships in a relational database, the ________ from one table must be joined to the foreign key of another table.

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:

Which of the following is NOT a tab in Access 2013?

In relational databases, there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

People use databases to store collections of data.

Enforce referential integrity is one of only two options available when setting a database relationship with another database.

The Undo button does not reverse the most recent change in Access 2013.

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

Which of the following is NOT a main object type in an Access database?

Information is what is typically entered into a database. Data is the finished product of the database.

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

A relational database has the ability to create relationships between two:

Access differs from other Microsoft software because it:

The purpose of a database is to:

Which of the following best describes information?

Clicking Undo will restore a deleted record.

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

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan's requirements. He should use the Filter by Form ________ condition.

Describe comparison operators in Access.

When forming relationships in a relational database, the ________ from one table must be joined to the foreign key of another table.

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:

Which of the following is NOT a tab in Access 2013?

In relational databases, there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

People use databases to store collections of data.

Enforce referential integrity is one of only two options available when setting a database relationship with another database.

The Undo button does not reverse the most recent change in Access 2013.

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

Which of the following is NOT a main object type in an Access database?

Information is what is typically entered into a database. Data is the finished product of the database.

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