Informations Systems For Access

Here is what I need help on, all the information is in the google doc

    

Database Access Information system

The person that originally did this did a horrible job. I need this in 4-6 hours

Create a database called
Volunteer
as shown in Chapter Extension 8 (Page: 398). Use the data (for tables Prospect and Work) as shown in page 400 (CE 8-2). Create the tables, relationships, Data Entry form, Queries and reports as explained in the Chapter Extension 8. Upload the database file to the drop box. Enter your name as one of the prospects in the “prospect” table replacing one of the names given.

Review the following material.

Review the following material.

Using Microsoft Access Tutorial

https://docs.google.com/presentation/d/1BDceLnaEkt0mxxx6C0BbX2vnt0rcIC8_S8UBlPns1FI/edit#slide=id.p58

http://web.usf.edu/blwarner/tips/accesspage.html

Please select the Access Topic on the web page and click to watch the presentation.

Here are the pages

ApplicationExercises: Question 37 (Page: 613), Tracking Systems Failures with Access. Answer all parts of the question (a to e).

37. Use Access to develop a failure-tracking database application. Use the data in Excel file Ex37 for this exercise. The file includes columns for the following:

FailureNumber
DataReported

FailureDescription
ReportedBy (the name of the PQA engineer reporting the failure)

ReportedBy_email (the email address of the PQA engineer reporting the failure)

FixedBy_email (the email address of the programmer assigned to fixe the failure)

DateFailureFixed

FixDescription

DateFixVerified

VerifiedBy (the name of the PQA engineer verifying the fix)

VerfiedBy_email (the email address of the PQA engineer verifying the fix)

A. The Data in the spreadsheet have not been normalized. Normalize the data by creating a Failure table, a PQA engineer table, and a programmer table. Add other appropriate columns to each table. Create appropriate relationships.

B. Create one or more forms that can be used to report a failure, to report a failure fix, and to report a failure verification. Create the form (s) so that the user can just pull down the name of a PQA engineer or programmer from the appropriate table to fil lin the ReportedBy FixedBy, and the VerfiedBy fields.

C. Construct a report that shows all failures sorted by ReportedBy and then by Date Reported.

D. Construct a report that shows only fixed and verified failures.

E. Construct a report that shows only fixed but unverified failures

Data File:

Ex37

“File is below”

https://docs.google.com/spreadsheet/ccc?key=0AtWNzikXvnTldHkzZFJFenUwd2hCaU9GNXFuX0RFT0E#gid=0

Access Tutorial –

Power Point file

Here is the link

https://docs.google.com/presentation/d/1Ck6YlJed2igSd78MIhXGbDy6KGAumHs0SlTYezlr7Ok/edit

General Access Tips: (Select the Access Topic and watch the presentation).