Question: Design an Access database to maintain information about school staff and students satisfying the following properties: 1. The staff should have the following: ID#, name,

Design an Access database to maintain information about school staff and students satisfying the following properties:

1. The staff should have the following: ID#, name, and classes they are teaching

2. The student should have the following: ID#, name, section, class

3. Create a module containing the section, subject and teacher information

4. Create a module containing student fee information

5. Create a module containing the instructors salary

6. Create a module with the classroom assignments (be mindful that each class/lab should not have the same information as another class)

I need help creating in Microsoft access.

create an Access School Management System Database that can be used to store, retrieve update and delete the staff/student

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!