Project Title: Student Information Database

Project Description:

You are tasked with designing and implementing a Microsoft Access database to manage student
information for a fictional school. The database should store and manage data related to students,
courses, and grades. Your goal is to create a functional database that allows for data entry, querying,
and reporting.

Requirements:

1. Student Information Table:

 Create a table named "Students" to store student data.

 Include fields such as StudentID (autonumber), FirstName, LastName, DateOfBirth,

Gender, Address, and ContactNumber.

2. Course Information Table:

 Create a table named "Courses" to store course information.

 Include fields such as CourseID (autonumber), CourseName, Instructor, and

CourseDescription.

3. Enrollment Table:

 Create a table named "Enrollments" to track student enrollments in courses.

 Include fields like EnrollmentID (autonumber), StudentID (foreign key), CourseID

(foreign key), and EnrollmentDate.

4. Grades Table:

 Create a table named "Grades" to store student grades for each course.

 Include fields such as GradeID (autonumber), EnrollmentID (foreign key), Grade (e.g., A,
B, C, D, F), and GradeDate.

5. Data Entry Forms:

 Create data entry forms for adding student information, course details, and recording
student enrollments and grades.

6. Queries:

 Develop queries to answer common questions, such as finding all students enrolled in a
particular course or calculating the average grade for a student.

7. Reports:

 Generate reports that display student information, course details, and grade reports for
each student.
Instructions:

 Use Microsoft Access to design and implement the database.

 Populate the database with sample data for at least five students, three courses, and their
corresponding enrollments and grades.

 Ensure data integrity by defining appropriate relationships between tables.

 Test your forms, queries, and reports to ensure they function correctly.

 Document the database structure, forms, queries, and reports in a project report.

Submission:

Submit your Microsoft Access database file (.accdb) along with your project report detailing the
database structure and explaining the functionality of forms, queries, and reports.

This project assignment allows students to practice various aspects of database design and management
using Microsoft Access, including table design, data entry, creating queries, generating reports, and
ensuring data integrity through relationships.

Project Title: Inventory Management System

Project Description:

You are responsible for designing and implementing an Inventory Management System using Microsoft
Access. The system should allow users to track and manage inventory for a small business, such as a
retail store or warehouse. Your goal is to create a functional database that facilitates inventory tracking,
reporting, and management.

Requirements:

1. Product Inventory Table:

 Create a table named "Products" to store information about the products in inventory.

 Include fields like ProductID (autonumber), ProductName, Category, Description,

UnitPrice, QuantityInStock, and ReorderLevel.

2. Supplier Information Table:

 Create a table named "Suppliers" to store supplier information.

 Include fields such as SupplierID (autonumber), SupplierName, ContactPerson, Phone,

and Email.

3. Purchase Orders Table:

 Design a table named "PurchaseOrders" to record purchase orders made to suppliers.

 Include fields like OrderID (autonumber), SupplierID (foreign key), OrderDate, and
TotalAmount.

4. Purchase Order Details Table:

 Create a table named "PurchaseOrderDetails" to store details of items ordered in

purchase orders.

 Include fields such as OrderDetailID (autonumber), OrderID (foreign key), ProductID

(foreign key), QuantityOrdered, and UnitPrice.

5. Sales Transactions Table:

 Develop a table named "SalesTransactions" to record customer sales.

 Include fields like TransactionID (autonumber), CustomerName, TransactionDate, and

TotalAmount.

6. Sales Transaction Details Table:

 Create a table named "SalesTransactionDetails" to store details of items sold in

transactions.

 Include fields such as TransactionDetailID (autonumber), TransactionID (foreign key),

ProductID (foreign key), QuantitySold, and UnitPrice.

7. Data Entry Forms:

  Create data entry forms for adding and updating product information, supplier details,
purchase orders, and sales transactions.

8. Queries:

 Develop queries to retrieve information like low-stock products, purchase history, and
sales reports.

9. Reports:

 Generate reports that display product inventory, purchase orders, sales transactions,
and supplier information.

Instructions:

 Utilize Microsoft Access to design and implement the database.

 Populate the database with sample data for products, suppliers, purchase orders, and sales
transactions.

 Ensure data accuracy and integrity by defining appropriate relationships between tables.

 Test your data entry forms, queries, and reports to ensure they function correctly.

 Document the database structure, forms, queries, and reports in a project report.

Submission:

Submit your Microsoft Access database file (.accdb) along with your project report detailing the
database structure and explaining the functionality of forms, queries, and reports.

This project assignment allows students to practice database design and management in the context of
an Inventory Management System. They will work on creating and maintaining product inventory,
handling purchase orders, tracking sales, and generating useful reports for decision-making.

Project Title: Event Management Database

Project Description:

Your task is to create an Event Management Database using Microsoft Access. The database should
enable users to organize and manage events, including tracking event details, attendees, schedules, and
expenses. Your goal is to design a functional database that streamlines event planning and
management.

Requirements:

1. Event Information Table:

 Create a table named "Events" to store information about different events.

 Include fields such as EventID (autonumber), EventName, EventDate, Location,

Organizer, and EventDescription.

2. Attendees Table:

 Create a table named "Attendees" to record details about individuals attending events.

 Include fields like AttendeeID (autonumber), FirstName, LastName, Email, Phone, and
Organization.

3. Event Schedule Table:

 Design a table named "EventSchedule" to manage the schedule of events, including

sessions, speakers, and timings.

 Include fields like ScheduleID (autonumber), EventID (foreign key), SessionName,

Speaker, StartTime, and EndTime.

4. Expenses Table:

 Create a table named "Expenses" to track event-related expenses.

 Include fields such as ExpenseID (autonumber), EventID (foreign key), ExpenseCategory,

ExpenseDescription, Amount, and ExpenseDate.

5. Registrations Table:

 Develop a table named "Registrations" to record attendee registrations for specific

events.

 Include fields like RegistrationID (autonumber), EventID (foreign key), AttendeeID

(foreign key), RegistrationDate, and RegistrationFee.

6. Data Entry Forms:

 Create data entry forms for adding and updating event details, attendee information,
event schedules, expenses, and registrations.

7. Queries:
  Develop queries to retrieve information such as upcoming events, attendee lists,
expense summaries, and event schedules.

8. Reports:

 Generate reports that display event details, attendee lists, financial summaries, and
schedules for specific events.

Instructions:

 Use Microsoft Access to design and implement the database.

 Populate the database with sample data for events, attendees, event schedules, expenses, and
registrations.

 Ensure data accuracy and integrity by defining appropriate relationships between tables.

 Test your data entry forms, queries, and reports to ensure they function correctly.

 Document the database structure, forms, queries, and reports in a project report.

Submission:

Submit your Microsoft Access database file (.accdb) along with your project report, which should detail
the database structure and explain the functionality of forms, queries, and reports.

This project assignment allows students to practice database design and management while focusing on
event planning and management. They will create a database that can effectively organize event
information, manage attendees, track expenses, and produce event-related reports.

Project Title: Employee Management System

Project Description:
In this project, you will design and implement an Employee Management System using Microsoft Access.
The system should allow for the storage and management of employee records, including personal
details, employment history, and performance evaluations. Your goal is to create a comprehensive
database that streamlines HR processes.

Requirements:

1. Employee Information Table:

 Create a table named "Employees" to store employee details.

 Include fields such as EmployeeID (autonumber), FirstName, LastName, DateOfBirth,

Gender, Address, Phone, Email, and HireDate.

2. Employee Positions Table:

 Create a table named "Positions" to manage information about job positions within the
organization.

 Include fields like PositionID (autonumber), PositionName, Department, and

JobDescription.

3. Employment History Table:

 Design a table named "EmploymentHistory" to track employees' work history, including

promotions, transfers, and terminations.

 Include fields like HistoryID (autonumber), EmployeeID (foreign key), PositionID (foreign
key), StartDate, EndDate, and Notes.

4. Performance Evaluations Table:

 Create a table named "PerformanceEvaluations" to record employee performance

reviews.

 Include fields such as EvaluationID (autonumber), EmployeeID (foreign key),

EvaluationDate, Rating, Comments, and ReviewerName.

5. Data Entry Forms:

 Create data entry forms for adding and updating employee information, job positions,
employment history, and performance evaluations.

6. Queries:

 Develop queries to retrieve information like employee lists, employment history

summaries, performance evaluations, and department-specific data.

7. Reports:

 Generate reports that display employee records, performance evaluations,

organizational charts, and departmental reports.
Instructions:

 Utilize Microsoft Access to design and implement the database.

 Populate the database with sample data for employees, job positions, employment history, and
performance evaluations.

 Ensure data accuracy and integrity by defining appropriate relationships between tables.

 Test your data entry forms, queries, and reports to ensure they function correctly.

 Document the database structure, forms, queries, and reports in a project report.

Submission:

Submit your Microsoft Access database file (.accdb) along with your project report detailing the
database structure and explaining the functionality of forms, queries, and reports.

This project assignment allows students to practice database design and management in the context of
an Employee Management System, helping them gain hands-on experience in organizing and
maintaining employee records, performance evaluations, and employment history.

Project Title: Library Catalog Management System

Project Description:
In this project, you will create a Library Catalog Management System using Microsoft Access. The system
should facilitate the cataloging and tracking of books, patrons, and library transactions. Your goal is to
design a functional database that streamlines library operations.

Requirements:

1. Book Information Table:

 Create a table named "Books" to store book details.

 Include fields such as BookID (autonumber), Title, Author, Genre, PublicationDate, ISBN,
and AvailabilityStatus.

2. Patron Information Table:

 Create a table named "Patrons" to manage information about library patrons.

 Include fields like PatronID (autonumber), FirstName, LastName, DateOfBirth, Address,

Email, and Phone.

3. Library Transactions Table:

 Design a table named "LibraryTransactions" to record borrowing and returning of books

by patrons.

 Include fields such as TransactionID (autonumber), PatronID (foreign key), BookID

(foreign key), TransactionType (borrow or return), TransactionDate, and DueDate.

4. Late Fees Table:

 Create a table named "LateFees" to track late fees imposed on patrons for overdue
books.

 Include fields like FeeID (autonumber), PatronID (foreign key), BookID (foreign key),
DueDate, LateFeeAmount, and PaymentStatus.

5. Data Entry Forms:

 Create data entry forms for adding and updating book information, patron details,
library transactions, and late fees.

6. Queries:

 Develop queries to retrieve information like available books, borrowed books, patron
borrowing history, and late fee reports.

7. Reports:

 Generate reports that display book catalogs, patron records, transaction history, and
late fee summaries.

Instructions:

 Utilize Microsoft Access to design and implement the database.

  Populate the database with sample data for books, patrons, library transactions, and late fees.

 Ensure data accuracy and integrity by defining appropriate relationships between tables.

 Test your data entry forms, queries, and reports to ensure they function correctly.

 Document the database structure, forms, queries, and reports in a project report.

Submission:

Submit your Microsoft Access database file (.accdb) along with your project report detailing the
database structure and explaining the functionality of forms, queries, and reports.

This project assignment allows students to practice database design and management in the context of
a Library Catalog Management System, providing them with hands-on experience in cataloging books,
managing library transactions, and handling late fees.