IENG 482 - Engineering Information Systems (Spring 2000)
In-Class Assignment #3
 (10 points)
Microsoft Access - Using Forms and Reports
Consider the same customer billing information system.  We have three (3) tables of information: People (SSN, LastName, FirstName, Phone, Zip), Items (Description, Cost, InStock), and Purchases (Purchase_No, Date, SSN, ItemDescription, Quantity).
In this exercise, we want to utilize several of the functions offered through forms and reports.  So, let's start with the above tables and developing appropriate forms and reports.  Save each form or report separately.  Although not as useful as in queries, you can use an existing form or report as a starting point for the next one.  Work with the wizards, and customize your forms and reports in design view.

The following is a summary of the steps covered in this in-class assignment:
  1. Create a "columnar" form for the People table.  It will default to single form view.
  2. Create a "justified" form for the Items table.  It will default to single form view.
  3. Use the above form for Items and show it as a continuous form.  Cut and paste the field labels into the header.  (What you just completed could be automatically done from the "tabular" form view wizard.)
  4. Create a form that lists all purchases made by all customers.  Base it on the tables, and include the following fields:  Date, SSN, LastName, Phone, ItemDescription, Cost, and Quantity.  Use a "justified" or "columnar" layout.
    • Include a calculated control for "TotalCost" by combining Cost and Quantity in the form.
    • Now base your form on the purchases query and use the calculated field "TotalCost" instead.
  5. Now create a form that only is used for entering new purchases.  This is done by setting the Data Entry property to YES.  Include the same fields from the previous form.  LastName, Phone, and Cost should be entered automatically as you enter the other necessary information.  The "TotalCost" field should also calculate once you enter a quantity. (HINT:  Base this off the previous form.)
  6. Create a form and subform that shows the cost per customer for all purchases.  Place customer information on the main form, and place individual purchases on the subform.  Then add the customer total to the main form.  (Remember the difference betwen a calculated control and an existing calculated field from a query.)
  7. Create a form that shows only the current inventory levels of each item.  Show in datasheet view or continuous form view.
  8. Create a report that includes the following:  Date, SSN, LastName, Phone, ItemDescription, Cost, Quantity, and TotalCost.
    • Group the purchases by customer.
    • Sort the purchases by date within the customer grouping.
  9. Create a similar report that lists all purchases made by all customers between any two dates.
  10. Create a pie chart that shows the total purchases of each type of item.
  11. Create a column chart that shows the total purchases by customer.
IENG 482 Assignments

IENG 482 Home Page