Scribd
Upload
5 views2 pages

Microsoft Access Student Database Lab

Air University is developing a database in Microsoft Access to manage student registrations, courses, and instructors. The assignment includes creating tables for students, instructors, courses, and registrations, inserting sample data, creating queries, data entry forms, and generating reports. Specific tasks include listing students by department, courses by credit hours, and creating forms for data entry and reports for registration and instructor course loads.

Uploaded by

hayatmoosa7
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

Microsoft Access Student Database Lab

Air University is developing a database in Microsoft Access to manage student registrations, courses, and instructors. The assignment includes creating tables for students, instructors, courses, and registrations, inserting sample data, creating queries, data entry forms, and generating reports. Specific tasks include listing students by department, courses by credit hours, and creating forms for data entry and reports for registration and instructor course loads.

Uploaded by

hayatmoosa7
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Microsoft Access Lab Assignment

Scenario
Air University wants to develop a small database to manage student
registrations, courses, and instructors. You will design this system in
Microsoft Access.

Lab Tasks
1. Task 1: Create a new database named [Link].
2. Task 2: Create the following tables:
Students

Field Name Data Type Description


StudentID AutoNumber (PK) Unique ID
StudentName Short Text Full name
Department Short Text CS / SE / EE
Semester Number e.g., 1–8

Instructors,

Field Name Data Type


InstructorID AutoNumber (PK)
InstructorName Short Text
Qualification Short Text
Department Short Text

Courses,

Field Name Data Type


CourseID Short Text (PK)
CourseTitle Short Text
CreditHours Number
InstructorID Number (FK → [Link])
Registration.

Field Name Data Type


RegID AutoNumber (PK)
StudentID Number (FK → [Link])
CourseID Short Text (FK → [Link])
Semester Number

3. Task 3: Insert sample data (minimum: 5 students, 5 courses, 3 instructors,


10 registrations).
4. Task 4: Create the required queries.
Create the following queries:

• List all students in the CS department.


• Show all courses with more than 3 credit hours.
• Find students registered in the course “Database Systems.

5. Task 5: Create data entry forms.


Create the following Access forms:
• Student Entry Form – to add new students
• Course Entry Form – to add new courses
• Registration Form – combo boxes for selecting students & courses
6. Task 6: Create reports.
Generate these reports:
• Student Registration Report
Show Student Name, Course Title, Semester
• Instructor Course Load Report
List instructors and their assigned courses

You might also like