Question

1. Question : (TCO 1) A database management system (DBMS) is a collection of programs that

store data.

manage data.

use collections of data.

All of the above

Question 2. Question : (TCO 1) Which database object would you use to find customers who are located in the same state?

Criteria

Form

Query

Report

Question 3. Question : (TCO 1) A filter is best described as

a subset of records from an object based on specified criteria.

a sorted list of records in an object.

a record list from a table.

another name for a query.

Question 4. Question : (TCO 1) Access should be used instead of Excel when

a nonrelational view of the data is needed.

you need to run various comparisons of statistical and comparative data.

you need to sort, group, and total data in various views.

you only need a smaller, manageable amount of data.

Question 5. Question : (TCO 1) Which view best describes the image below?

Datasheet

Design

Form

Report

Question 6. Question : (TCO 2) In using a web search engine, typing the website address in the proper place in the brower and then hitting enter is called

server setup.

presentation task.

client browsing.

systems application.

Question 7. Question : (TCO 2) Types of relationships between tables do NOT include

one-to-one.

many-to-many.

primary-to-foreign.

many-to-one.

Question 8. Question : (TCO 1) You should use Excel over Access when

you have a large amount of data.

you need to group, sort, and total data based on various parameters.

you need multiple related tables to store data.

you require a series of What-if scenarios on your data.