Lab Assignment 8: Simple Project Based on the Previous Assignments
Objective: Design and create a student database system in
Microsoft Access. This project will involve creating tables, relationships,
forms, queries, and reports for managing student information.
Steps:
Step 1: Project
Definition
·
Define the scope and
requirements of the student database system. For this example, let's consider
the following requirements:
·
Store student
information (ID, name, email, phone, and major).
·
Track courses enrolled
by students.
·
Generate a report to
display student information.
Step 2: Design the
Database Structure
·
Create a new database in
Microsoft Access and define the necessary tables. In this example, you might
create tables for:
·
Students
·
Courses
·
Enrollments (to
represent the relationship between students and courses)
Step 3: Define
Relationships
·
Establish relationships
between tables, ensuring referential integrity. Connect the Students and
Courses tables through the Enrollments table.
Step 4: Data Entry and
Validation
·
Populate the Students
and Courses tables with sample data.
·
Create data entry forms
for the Students and Courses tables. Add validation rules, if needed.
Step 5: Create Queries
·
Create queries to answer
questions or retrieve specific data, e.g., list all students in a specific
major, or list courses taken by a specific student.
Step 6: Create Forms
·
Develop a student
information form that allows users to search for and view student details.
·
Create a course
information form for a similar purpose.
Step 7: Generate Reports
·
Design a student
information report that provides an overview of each student's details.
·
Optionally, create other
reports like a list of enrolled students in a specific course.
Step 8: Finalize and
Test
·
Review and test the
entire database system for functionality and accuracy.
·
Ensure that data
validation rules work as expected.
Step 9: Presentation
·
Have each student
present their project to the class, explaining the project's purpose, features,
and how they implemented it in MS Access.
Solution:
In the solution, students will present their
completed student database system. Here's what you might expect in the final
project solution:
1.
A fully functional
student database system in Microsoft Access that meets the defined
requirements.
2.
The database should have
tables for Students, Courses, and Enrollments with established relationships.
3.
The system should
include data entry forms for student and course information.
4.
Queries to retrieve
specific data, such as student lists by major and course enrollments by
students.
5.
Forms for viewing and
searching student and course information.
6.
Well-designed reports
displaying student information and optionally, other relevant reports.
The project presentations should highlight how
students implemented the database system, including any specific design
considerations, validation rules, or custom features they incorporated.
This assignment allows students to demonstrate
their ability to apply MS Access skills and design a functional database
system. It's important to evaluate their projects based on the project's
objectives and how well they met them.