MICROSOFT ACCESS 2007

Practical 1: Create a New Database

Steps

1. Start MS Access 2007.
2. Click Office Button → New.
3. Select Blank Database.
4. In the File Name box, type School.
5. Click Create.

Practical 2: Create a Student Table

Steps

1. Open the School database.
2. Click Create → Table Design.
3. Enter the field names and data types.
4. Set RollNo as the Primary Key.
5. Save the table as Students.

Practical 3: Enter Student Records

Steps

1. Open the Students table.
2. Enter the data in Datasheet View.
3. Move from one field to another using the Tab key.
4. Save the table.

Practical 4: Add a New Record

Steps

1. Open the Students table.
2. Go to the last blank row.
3. Enter the student's information.
4. Press Enter.

Practical 5: Edit a Record

Steps

1. Open the Students table.
2. Find Sohan's record.
3. Click in the Marks field.
4. Delete 78.
5. Type 82.

Practical 6: Delete a Record

Steps

1. Open the Students table.
2. Select Amit's row.
3. Click Home → Delete.
4. Confirm the deletion.

Practical 7: Sort Student Names

Steps

1. Open the Students table.
2. Click in the Name field.
3. Click Home → Sort & Filter → Ascending.

Now repeat the task using Descending order.

Practical 8: Filter Students

Steps

1. Open the Students table.
2. Click the drop-down arrow beside Marks.
3. Select Number Filters.
4. Select Greater Than.
5. Enter 80.
6. Click OK.

Practical 9: Create a Query

Steps

1. Click Create → Query Design.
2. Select the Students table.
3. Add the following fields:
   • Name
   • Marks
4. In the Criteria row under Marks, type >80.
5. Click Run (!).
6. Save the query as High Marks.

Practical 10: Create a Query for Class A

Steps

1. Click Create → Query Design.
2. Select the Students table.
3. Add:
   • Name
   • Class
   • Section
   • Marks
4. In the Criteria row under Section, type "A".
5. Click Run.
6. Save the query as Section A.

Practical 11: Create a Student Form

Steps

1. Select the Students table.
2. Click Create → Form.
3. Access automatically creates a form.
4. Save it as Student Form.

Use the form to:

• View a student's information.
• Move to the next record.
• Add a new student.
• Edit information.

Practical 12: Add a Student Using the Form

Steps

1. Open Student Form.
2. Go to a new record.
3. Enter the information.
4. Close the form.
5. Open the Students table and check whether the new record has been added.

Practical 13: Create a Student Report

Steps

1. Select the Students table.
2. Click Create → Report.
3. Access automatically creates a report.
4. Save it as Student Report.
5. Open the report in Print Preview.

Practical 14: Create a Report from a Query

Steps

1. Select the High Marks query.
2. Click Create → Report.
3. Access creates a report from the query.
4. Save it as High Marks Report.
5. Open it in Print Preview.

Practical 15: Understand Primary Key

What happens?

MS Access will not allow the same value to be entered twice in the Primary Key field.

Practical 16: Mini Project – Student Database

After completing the above activities, students can do a small project.

Create a table named Students with:

Students have to:

1. Create the database.
2. Create the table.
3. Set RollNo as Primary Key.
4. Enter at least 10 records.
5. Edit one record.
6. Delete one record.
7. Sort students by Name.
8. Filter students according to Section.
9. Create a query for students scoring more than 80 in Mathematics.
10. Create a Student Form.
11. Create a Student Report.
12. View the report in Print Preview.

One Simple Example: Four Main Objects

Suppose a teacher has information about 50 students.

This sequence makes a good first practical lesson on MS Access 2007, because students learn the concepts by actually creating one small database.