Cite a real-world database situation in which the sensitivity of an aggregate is greater than that of its constituent values. Then, cite a database situation in which the sensitivity of an aggregate is less than that of its constituent values.
Question 1. A database management system (DBMS) is a collection of programs that:
a. Store data.
b. Manage data.
c. Use collections of data.
d. All of the above.
Question 2. You should use Access over Excel when:
a. You have a large amount of data.
b. You need to create complex charts.
c. You have only one worksheet to handle all of your data.
d. You have extensive subtotals and totals in your worksheet.
Question 3. A filter is best described as:
a. A subset of records from an object based on specified criteria.
b. A sorted list of records in an object.
c. A record list from a table.
d. Another name for a query.
Question 4. When building a database, you should first:
a. Create and input the design of the tables and reports at the same time.
b. Determine the input and then design the tables.
c. Determine the output and then design the tables.
d. Input the data and then design the reports.
Question 5. Excel should be used instead of Access when:
a. You have a small amount of data.
b. Your data needs to be regrouped in various views.
c. Your data needs connectivity to external databases.
d. Your data requires a relational database.
Order an Essay Now & Get These Homework Help Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
