Access Lesson #10

Objective: students will be able to make a proposal, create a relational database, and present it to the class.

Project Proposal - write a proposal outlining what type of relational database you will build. You will have four classes to build your database and you will present it to the class afterwards. Here is the criteria for the relational database.

Marking Criteria

· Proposal (includes purpose, what you will be doing each class, what information you will need in the database)   /10

· Less than 2.5 MB (picture files are small)  /5

· Tables (must have at least 5 fields per table, one field must have a pull down choice list, must have 2 tables, must have a primary key and a foreign key to show relationship between the tables)  /15

· Form (nicely laid out, at least 2 images, have a tab control, nice background colour)   /25

· Query (nicely laid out, must ask a specific question about the data in the database) /10

· Report (nicely laid out, include 1 image)  /10

· Switchboard (nicely laid out, nice background colour, include 1 image, all switches work)  /25

Total Marks -  /100