Note: These problems should be completed with a database software package such as Access...

Note: These problems should be completed with a database software package such as Access. For Problems 6-3 and 6-4, you may use data that you (or your instructor) have downloaded from an accounting database. Problem 6-5 demonstrates the interaction between an application software system and the database.

Note: This problem is a continuation of Problem 6-3 but requires use of a spreadsheet package that is capable of reading data from your database package (e.g., Excel can import data from an Access database).

a. Using your spreadsheet package, construct SQL queries (or use the software’s menu generation for queries) to import the billing information for Fleet Services.

b. Develop a report format for using the information from your queries to generate a nice-looking report in your spreadsheet package.

c. Document the queries used in your spreadsheet package to access the data and explain what each step of the queries does.

REF PRB:

P 6-3 Using the information from Figures 6.12 (pg. 206) and 6.13 create the database in the software package of your choice. This will require three steps:

• Implement the relations from Figure 6.13.

• Insert the data from Figure 6.13 into the relational tables.

• Print the data from each of the relations to test for successful implementation.