COMP112 Section 71 Homework 8 - Accessing Databases - Prof. Robert Goldstein, Assignments of Computer Science

Download COMP112 Section 71 Homework 8 - Accessing Databases - Prof. Robert Goldstein and more Assignments Computer Science in PDF only on Docsity! Wentworth Institute of Technology Division of Professional and Continuing Studies COMP112 Section 71 – Introduction to Computers and Programming - Spring, 2009 OPTIONAL Homework 8 – Access Instructor: Bob Goldstein (617) 912-2512 bobg@vision.eri.harvard.edu robert.goldstein@schepens.harvard.edu 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: April 27,2009 Purpose: This homework is intended to provide practice with Access 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. Send me a screen capture of the results of the query. CLOSE THE LargeEmployeeDatabase and MAKE A COMPLETELY NEW .mdb file. 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, and put in your own (made-up) data. 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/qkd2gv-379644-2765007-homework8-doc.doc 1 11/28/2020 11/28/2020