Part 1

Create a table that contains grades. It should have three fields, the student identifier, the course identifier and the grade. Enter at least 22 records.

Part 2

Create a student table file. It should have a unique identifier, names and postal code. Create at least 20 records. Make sure my name and your name are in the file. My postal code is L8N 3T2, and I should be the first record in your file.

Use the MSAccess query program to create a query which lists the students, their postal code and their course code and their grades. Show the records in order of the 2nd character of the postal code (but show the entire postal code, not the 2^nd character). Save the query.

Rubric

Grade table 3 marks.

Student table 3 marks.

Correct query 4 marks.

FAQs:

Why are there different records in the two tables?

A: Yes, not all students will have grades, and some students might have grades in two different courses. Its a 1 to many relationship

Do I have to make a relationship?

A: Yes, you need to relate the identifier in the two tables. Ensure they are the same data type and the same data.

How do I get just the 2^nd character of the postal code?

A: Use the mid function. Look up the function in help to get the 3 parameters.