Session Five: Database Reporting Exercise

Last week we learned how to create reports using the Report Wizard feature of MS ACCESS.

Here's a quick summary of the steps in our database reporting tutorial:

1. The database used in our exercise contained two tables called Product and Supplier. The fields in each table, plus the primary key for each table, are shown below.




2. Create a new report using the Report Wizard method.





3. Select the fields to be included in the report. From the Product table, choose Product Category, Product Name, Selling Price, Quantity on Hand and Reorder Level. From the Supplier table, choose Company Name - this is the name of the supplier for that product.





4. Group the report according to Product Category.





5. Sort the data in each product category by Product Name.





6. Choose a layout and page orientation for the report as shown below.





7. Give the report a name - "Inventory Status by Product Category".





8. Click "Finish" and you will see a preview of your report.





9. You may also produce another report - "Inventory Status by Supplier Name" - using the same steps, except the report should be grouped by "Company Name" (the name of the supplier).





10. Here's what the report (grouped by Company Name) would look like: