Google Answers Logo
View Question
 
Q: Microsoft Access Project 1 of 2 (Basic Skills) ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: Microsoft Access Project 1 of 2 (Basic Skills)
Category: Computers > Software
Asked by: alwaysrelaxed-ga
List Price: $40.00
Posted: 14 Nov 2004 09:25 PST
Expires: 14 Dec 2004 09:25 PST
Question ID: 428799
Within about the next Six hours of posting this I am seeking someone
with the abilities to do an Basic difficulty Access project. The
project has 2 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=7937&vsubmit=Go

and download Project Files - Project 9 - Project9.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 9 - mcleod9e_pr09.ppt

The assignment and example of finished product is on the 33, 34, and
35 page of the slides at end.

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)

1) Make a form for the CLASS table. Place both the ClassNumb and
Enrollment fields in the form. For the Enrollment field form on the
form, create a validation rule that the value must be less than or
equal to 200. When the validation rule is violated a message should
appear stating ^Enrollment Must Be Less Than Or Equal To 200.^

2) Make a report of books used in each class. The finished report
should look similar to Figure P9.25. Note any changes in labels from
the default field names. Move the labels ^Sum^and ^Grand Total^to be
on the right-hand side of the totals. Make sure your fields are wide
enough to show the entire field value, that is, do not let the book
titles get truncated by fields that are too narrow. Make sure your
report design does not go past 6.5 inches wide which would cause blank
pages to appear.

I am posting another Access Project shortly which will be more difficult.
Answer  
Subject: Re: Microsoft Access Project 1 of 2 (Basic Skills)
Answered By: hammer-ga on 14 Nov 2004 11:32 PST
Rated:5 out of 5 stars
 
Alwaysrelaxed,

There is no SQL to post for this one, but your mdb file with the form
and report are at:
http://www.hammerdata.com/Google/Textbook.mdb

- Hammer

Request for Answer Clarification by alwaysrelaxed-ga on 07 Dec 2004 09:31 PST
Im sorry but if you still have this old one can you make this it
available from the link again? Thanks if you can.

Clarification of Answer by hammer-ga on 07 Dec 2004 11:13 PST
AlwaysRelaxed,

I'm sorry, but it was overwritten by a later version of the file. I
don't have the mdb in the state it was in when I answered this
question.

- 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