acces lab 5

CS1100: Access Lab 5

Building Reports

To complete this assignment you must submit an electronic copy to Blackboard by the due date. In this lab you are asked to construct two reports, one that will generate an inventory report for a given product when the user specifies a particular Product ID, and one that will generate a report about the orders placed by a given contact.

Report 1 An inventory report is a printed sheet that details where and how often a particular product was sold. Here is an example of this report for ProductID 4.

Your task is to create this exact report with the additional requirement that Access prompt for the Product id so that you can create a report for any product.

Your report must contain all of the above information on the particular product it represents. The report should show the current date on the bottom left.

The report must be based upon a query, which selects out of the tables the information necessary for the report. As you can see from the above example, you will need information about the

LabA5 CS1100

2 of 3

product and information about where it was ordered and how many units were ordered. The query must prompt the user for the Product ID of the product whose report is to be printed. This is a query with a parameter.

When you have constructed and tested the query, save it as Query1. Then design the report and test it, viewing its output on the screen. When the report does everything required of it, save it as InventoryReport.

Report 2 Suppose you are the owner of the computer store and want to see the orders by date for any given customer. This means that you want to see the order cost for each order that a contact has made grouped by date. Construct a report which will answer this question. Here’s an example of the report:

The pages of the report must be numbered and the title and headings must appear on each page. The report should show the current date on the bottom left. Your report must come from a query that will provide all required information.

Name your query Query2, and save it as a part of the database. Save the report as CustomerOrdersByDate.

LabA5 CS1100

3 of 3

Grading Rubric This rubric is intended to guide graders in their evaluation of the students’ submissions.

Criterion Discussion Grading

Reports are formatted correctly

Bands, shading, italics, Currency symbols

-5% for each incorrect format

The reports are correct The reports must contain the correct data and calculations

-5% if information is missing (each time)

-10% if quantity or totals are not correct

Address must be concatenated

The address in report 2 must be displayed using concatenated strings

-10% if address display is not formatted correctly

Reports do not prompt for ID

-10% if a parameterized query is not used (each report)