Google Answers Logo
View Question
 
Q: Microsoft Access Project 2 of 2 (Advanced Skills) ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: Microsoft Access Project 2 of 2 (Advanced Skills)
Category: Computers > Software
Asked by: alwaysrelaxed-ga
List Price: $65.00
Posted: 14 Nov 2004 09:36 PST
Expires: 14 Dec 2004 09:36 PST
Question ID: 428808
Within about the next Six hours of posting this I am seeking someone
with the abilities to do an Medium to Advanced difficulty Access project. The
project has 10 steps to be built on from the file posted below.

To access the Access file please go to
http://myphlip.pearsoncmg.com/cw/mpchapter.cfm?vbcid=7939&vsubmit=Go

and download Project Files - Project 11 - Project11.zip  

To view the Assignment and Steps please go to the same page but
download the powerpoint slides titled .... PowerPoint Presentation by
Gene Mesher and Robert Jamieson - Project 11 - mcleod9e_pr11.ppt

The assignment has 10 steps and they can be found at the end of the slides.

Rules:
Please upload the file somewhere and provide the link so I may
download it directly or provide another way for me to download the
file AND post the SQL for each of the queries.

Steps: (They are at the end of the power point slides)
Answer  
Subject: Re: Microsoft Access Project 2 of 2 (Advanced Skills)
Answered By: hammer-ga on 14 Nov 2004 10:56 PST
Rated:5 out of 5 stars
 
Alwaysrelaxed,

The file is at
http://www.hammerdata.com/Google/ClassProjects.mdb

1.
SELECT [Code] & ", Project " & [Number] AS ProjectCode, PROJECT.Points
FROM PROJECT
WHERE (((PROJECT.Points)>40))
ORDER BY PROJECT.Points;

2.
SELECT [Code] & ", Project " & [Number] AS ProjectCode
FROM PROJECT
WHERE (((PROJECT.Points)>=30 And (PROJECT.Points)<=40));

3.
SELECT [Code] & ", Project " & [Number] AS ProjectCode
FROM PROJECT
WHERE (((PROJECT.Points)<30 Or (PROJECT.Points)>40));

4.
SELECT COURSE.Code
FROM COURSE
WHERE ((Left([Code],3)='MIS'))
ORDER BY COURSE.Code DESC;

5.
SELECT COURSE.Code
FROM COURSE
WHERE (((Mid([Code],4,1))='4'));

6.
SELECT COURSE.Description
FROM COURSE
WHERE (((COURSE.Code)=[Enter A Code]));

7.
SELECT COURSE.Code
FROM COURSE
WHERE (((COURSE.Abbreviation)='INT') AND ((Exists (SELECT * FROM
PROJECT WHERE Project.Code= Course.Code))=False));

8.
SELECT DEPARTMENT.Name, Count(COURSE.Description) AS [Count of Courses]
FROM DEPARTMENT LEFT JOIN COURSE ON DEPARTMENT.Abbreviation=COURSE.Abbreviation
GROUP BY DEPARTMENT.Name;

9.
SELECT DEPARTMENT.Name, Sum(Nz([Points],0)) AS [Sum of Points]
FROM (DEPARTMENT LEFT JOIN COURSE ON
DEPARTMENT.Abbreviation=COURSE.Abbreviation) LEFT JOIN PROJECT ON
COURSE.Code=PROJECT.Code
GROUP BY DEPARTMENT.Name
ORDER BY Sum(Nz([Points],0)) DESC;

10.
SELECT TOP 1 [Code] & ", Project " & [Number] AS ProjectCode,
PROJECT.Title, PROJECT.Due
FROM PROJECT
ORDER BY PROJECT.Due;

- Hammer

Request for Answer Clarification by alwaysrelaxed-ga on 22 Nov 2004 06:49 PST
another one up deadline extended. Let me know if any adjustments are needed

Clarification of Answer by hammer-ga on 22 Nov 2004 07:48 PST
AlwaysRelaxed,

I'm going out of town tomorrow, and I'm not sure if I'll be able to
get your current project. I'll try, but there's a lot going on today.

- Hammer

Request for Answer Clarification by alwaysrelaxed-ga on 22 Nov 2004 09:52 PST
Completely understand.  Ill raise the price on it to hopefully jump in
front of the que. Hope all is well with you and thanks whether it gets
answered or not!

Clarification of Answer by hammer-ga on 22 Nov 2004 13:24 PST
Thanks. Again, I'll try to get to it.

- Hammer
alwaysrelaxed-ga rated this answer:5 out of 5 stars and gave an additional tip of: $1.00

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy