Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Question 1. 1. (TCO 1) A database management system (DBMS) is a collection of pr

ID: 3675174 • Letter: Q

Question

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

Explanation / Answer

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

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote