Wentworth Institute of Technology
Division of Professional and Continuing Studies
COMP112 Section 71 – Introduction to Computers and Programming - Fall, 2008
Homework 8 – Access
Instructor: Bob Goldstein (617) 912-2512
http://home.comcast.net/~goldsteinr/Courses/index.html
http://goldstein.eri.harvard.edu/courses/index.html
http://myweb.wit.edu/goldsteinr/Courses/index.html
Due Date: November 18, 2008. EMAIL The mdb FILE TO ME.
Purpose: This homework is intended to provide practice with Access
Description :
1. Download the “LargeEmployeeDatabase” from the course website
2. Make a query that prints out the names of all employees who work in a city that is input when you
run the query (use parameter entry). Name the query EmployeesByCity.
3. Make your own database, that will be small Inventory database, with the following three tables:
a. Supplier with fields:
SupplierID,SupplierName, AddressLine1, City, State, Zip
b. Parts with fields:
PartID, SupplierID, PartName, Price, AmountOnHand
c. Assemblies
AssemblyID, Assembly Name
d. AssemblyParts with fields (multiple lines. One line for each part an assembly needs):
AssemblyID, PartID, NumberNeeded
Screen shots of portions of these tables are on the back of this page:
4. Make data entry forms to populate the database:
Extra Credit
1. Make a report that Lists each part, the Supplier name next to the part, and the amount on Hand.
Here is a picture of what the report should look like:
2. Make a query or report that gives the total price of an Assembly by adding up the price of the parts
that go into the assembly.
3. For the large employee database, make a Pivot Table that .shows the Performance across the
column headings, the locations as the row headings, and the Count of Employees as the detail.
/app/work/qkd8pb-356987-2764986-homework8-doc.doc 1 12/2/2020 12/2/2020
