MS-access Lab work School Nepali Curriculum(NEB) SEE

MS Access Database Management System Lab for school students involves designing practical tasks and exercises that allow students to understand and apply the key concepts of database management using MS Access. Here’s a detailed breakdown of a lab curriculum designed for a school:

---

Lab 1: Introduction to MS Access

Objective: Introduce students to the MS Access environment, navigation, and basic operations.

Details:

• Tasks:
  1. Opening MS Access and creating a new blank database.
  2. Understanding the MS Access interface: Ribbon, Navigation Pane, Tables, Queries, Forms, Reports, and Modules.
  3. Creating a simple table: Adding fields (text, number, date/time, etc.), setting primary key, data types, and properties.
  4. Saving the database and its components (tables, queries, forms).

Exercise:

• Create a table named "Students" with fields: StudentID (Primary Key), FirstName, LastName, DOB, Grade, Email.

---

Lab 2: Data Entry and Table Relationships

Objective: Learn how to enter data into tables and create relationships between them.

Details:

• Tasks:
  1. Entering data manually into a table (e.g., adding records in the "Students" table).
  2. Using Datasheet View for data entry.
  3. Creating multiple tables for different entities (e.g., a "Courses" table).
  4. Establishing relationships between tables (One-to-Many, Many-to-Many).
  5. Setting Referential Integrity to ensure data consistency.

Exercise:

• Create a table "Courses" with fields: CourseID (Primary Key), CourseName, TeacherName.
• Establish a relationship between "Students" and "Courses" with a "StudentCourses" junction table (many-to-many).

---

Lab 3: Querying Data (Select Queries)

Objective: Learn how to retrieve specific data using queries.

Details:

• Tasks:
  1. Creating a simple Select Query to retrieve data from a table.
  2. Filtering records using criteria (e.g., finding students in a specific grade).
  3. Sorting data (e.g., sorting by name or grade).
  4. Using Operators like AND, OR, LIKE, etc., in queries.

Exercise:

• Create a query to find all students who are in grade "A" and sort them by their last name.

---

Lab 4: Advanced Queries (Update, Delete, and Parameter Queries)

Objective: Learn advanced query techniques such as updating records, deleting records, and using parameters.

Details:

• Tasks:
  1. Update Query: Modify data in tables (e.g., updating the grade of a student).
  2. Delete Query: Remove records from a table.
  3. Parameter Query: Create queries that ask the user for input (e.g., asking for a student’s ID to retrieve their data).

Exercise:

• Create an Update Query to change the grade of a student based on their StudentID.
• Create a Delete Query to remove a course from the "Courses" table.
• Create a Parameter Query to find students who have a certain grade, based on user input.

---

Lab 5: Forms for Data Entry

Objective: Learn to create forms for easier data entry and display.

Details:

• Tasks:
  1. Creating a Form using the Form Wizard for data entry.
  2. Adding controls such as text boxes, combo boxes, and buttons.
  3. Using the Form View for interacting with data.
  4. Designing a user-friendly layout for the form.

Exercise:

• Create a Form for the "Students" table to allow easy data entry of student records (using a combo box for selecting courses).

---

Lab 6: Reports for Printing Data

Objective: Learn how to generate printable reports from tables and queries.

Details:

• Tasks:
  1. Creating a Report based on a table or query.
  2. Grouping and sorting data in the report.
  3. Designing the report layout: Adding headers, footers, and changing field placements.
  4. Previewing and printing the report.

Exercise:

• Create a report that displays all students and their enrolled courses (joined with the "StudentCourses" table).

---