Within about the next five hours of posting this I am seeking someone
with the abilities to do an Medium to Advanced difficulty Access project. The
project has some 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=7940&vsubmit=Go

and download Project Files - Project 12 - Project12.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 12 - mcleod9e_pr12.ppt

The assignment has some 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)

---

Clarification of Question by alwaysrelaxed-ga on 22 Nov 2004 02:52 PST

Deadline extended for 24 Hrs within posting this clarification.

Alwaysrelaxed,

Your mdb is at:
http://www.hammerdata.com/Google/Textbook.mdb

It includes three reports based on three queries, per your
instructions. All new items are named with a GA_ prefix.

I can't post the actual reports, but here are the queries:

GA_Ask Class Number
SELECT BOOK.Title, [LastName] & ", " & [FirstName] AS Name,
INTERSECTION.ClassNumb, [What is the class number?] AS Class
FROM (BOOK INNER JOIN STUDENT ON BOOK.BookNumb = STUDENT.BookNumb)
LEFT JOIN INTERSECTION ON BOOK.BookNumb = INTERSECTION.BookNumb
WHERE (((INTERSECTION.ClassNumb)=[What is the class number?]));

GA_AskEnrollment
SELECT CLASS.ClassNumb, CLASS.Enrollment, [What is the minimum
enrollment?] AS MinEnrollment
FROM CLASS
WHERE (((CLASS.Enrollment)>=[What is the minimum enrollment?]));

GA_Classes Using Each Book
SELECT BOOK.Title, CLASS.ClassNumb
FROM CLASS RIGHT JOIN (BOOK LEFT JOIN INTERSECTION ON BOOK.BookNumb =
INTERSECTION.BookNumb) ON CLASS.ClassNumb = INTERSECTION.ClassNumb;

I'll be out of town for the next few days, so I'll have to take care
of any clarification you need when I get back.

- Hammer