How to build an access databas?
Probably the wrong topic, but here goes. For one of my classes we are to create a microsoft access database. Unfortunately, the professor never showed us how to use access in any way, shape, or form. The database isn't too complicated, it's just that I have no idea how to do anything in access. Basically, he wants us to create a gradebook that he can use to enter in students grades. What he wants is a gradebook where he can enter in the students grades while also entering in information on what tasks and objectives of each assignment were completed by the student for optimal feedback. He briefly explained what tables we are suppose to use. Actually, we're not supposed to use them, but he just gave an example. 1) A students table with fields of SSN, First and Last Name, and Email Address. 2) An assignments table with the assignment ID and name. 3) Tasks with fields of id description and instructions (tasks are just the different parts of each assignment) 4) Objectives with fields of ID, Description, and Point Value. The objectives are just the course objectives given in the syllabus. For example, each assignment includes many different tasks and each task fills numerous course objectives. There is also a table of student_assignment, assignment_task, and task_objective. Somehow we're suppose to link two tables together to form the last three? I'm sure this is making absolutely no sense to anyone, but I'd really appreciate it if someone with access could help me out a bit, this is really stressing me out. This database requires no real bells or whistles, just the basics. THanks in advanced and if you need any clarifications (i'm sure you do), let me know.
|