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

store data. manage data. use collections of data. All of the above

Question 2.2. (TCO 1) You should use Access over Excel when (Points : 5)

you have a large amount of data. you need to create complex charts. you have only one worksheet to handle all of your data. you have extensive subtotals and totals in your worksheet.

Question 3.3. (TCO 1) A filter is best described as (Points : 5)

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.4. (TCO 1) To locate the tool to compact an Access database, click on the (Points : 5)

File tab, Options, Current Database, and select Compact and Repair Database Tools. Home tab, Advanced, and select Compact and Repair Database Tools. Database Tools tab, and select Compact and Repair Database Tools. External Data tab, and select Compact and Repair Database Tools.

Question 5.5. (TCO 1) On which tab is the Sort and Filter group found? (Points : 5)

File Home Create External Data

Question 6.6. (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 (Points : 5)

server setup. presentation task. client browsing. systems application.

Question 7.7. (TCO 2) When building a database, you should first (Points : 5)

create and input the design of the table and reports at the same time. determine the input and then design the tables. determine the output and then design the tables. input the data and then design the reports.

Question 8.8. (TCO 1) Excel should be used instead of Access when (Points : 5)

you have a small amount of data. your data needs to be regrouped in various views. your data needs connectivity to external databases. your data requires a relational database.