Assignment Help

[alexander]

Some people are still asking about this so I'm posting it again here:

A student in year 11 used her initiative and emailed me asking for help with the assignment.  Even though only section 1 is due at this stage, she was clever enough to realise that section 2 is dependant on section 1: eg your database won't work unless your survey makes sense...  Here's the email I sent her, I hope it helps the rest of you.

"My suggestion for a query would be;  go 'create query in design view'.  Include the table which contains your survey responses.  (If you have done this in excel you can easily import spreadsheets into access by going to file > get external data > data source? is your excel worksheet.) 

Let's say we create a database table with the following fields:

(Table name; Survey)

studentID
LastName
Firstname
Attendance (yes/no)
FoodChoice
EntertainmentChoice
VenueChoice
Cost

This is pretty much like the survey you made; right?  If it's organised like this, the queries should be simple.

e.g.  Create query (in design view) to calculate the total number attending:

Table to include: survey

Fields to include: LastName, FirstName, Attendance

This will show how many people have selected yes.

I think I'll let you work out the rest yourself.  All you need to do is enter a criteria under a given field and it will show how many people have selected that choice.  If the table structure is logical everything should fall into place.  I'm glad to see you've been thinking ahead because the data output requirements of the database obviously effect the design of the survey."

I hope the rest of you are using your initiative too...