Std 8 Practical Questions and answers

1. Create a simple database in MS Access. 

• Create a table with the following fields: Student ID, Student Name, Class, and Age. 
• Enter at least 5 records of students in the table.       

2. Use Query Wizard in MS Access to filter data.

• Use the Query Wizard to create a query that shows the students in Class 8. 
• Sort the results by `Age` in ascending order.              

3. Use Query Design to create a report. 

• Create a report using the Query Design feature, displaying students who are older than 12 years. 
• Make sure to format the report neatly.                       

4. Viva Questions 

Solutions for the above practical Questond          

 Here is a step-by-step solution for the practical questions and possible answers for the viva questions in the Class 8 Computer Practical Question Paper on MS Access.

Practical Questions: Step-by-Step Solution

Question 1: Create a simple database in MS Access

• Task:
• Create a table with the following fields: Student ID, Student Name, Class, and Age.
• Enter at least 5 records of students in the table.

Steps:

1. Open MS Access.
2. Create a New Database:

• Go to the File menu.
• Select New and then choose Blank Database.
• Name the database (e.g., “SchoolDB”) and click Create.

1. Create a Table:

• In the Table Design view, add the following fields:
  • Student ID (Data Type: AutoNumber or Number)
  • Student Name (Data Type: Short Text)
  • Class (Data Type: Number)
  • Age (Data Type: Number)

1. Set Primary Key:

• Right-click the Student ID field and set it as the Primary Key (this ensures each record is unique).

1. Save the Table:

• Press Ctrl + S to save the table and name it (e.g., “Students”).

1. Enter Records:

• Switch to Datasheet View and input at least 5 records like:
  • 001, John, 8, 13
  • 002, Maria, 8, 12
  • 003, Vibha, 8, 13
  • 004, Raj, 8, 12
  • 005, Priya, 8, 14

Question 2: Use Query Wizard to filter data

• Task:
• Use the Query Wizard to create a query that shows the students in Class 8 and sorts by Age in ascending order.

Steps:

1. Go to the Create Tab:

• On the Ribbon, click the Create tab.
• Click on Query Wizard.

1. Select Simple Query Wizard:

• Choose Simple Query Wizard and select the table (Students).

1. Select Fields:

• Select the fields you need in the query: Student Name, Class, and Age.
• Click Next.

1. Specify Criteria:

• After creating the query, switch to Design View.
• Under the Class field, enter the criteria: = 8 (this will only show students in Class 8).

1. Sort by Age:

• In the Sort row under the Age column, choose Ascending.

1. Run the Query:

• Click Run (in the Design tab) to see the filtered and sorted results.

Question 3: Use Query Design to create a report

• Task:
• Create a report using Query Design to display students older than 12 years.

Steps:

1. Create a New Query:

• Click on the Create tab and then Query Design.

1. Add Table:

• In the Query Design window, add the Students table.

1. Select Fields:

• Add the following fields to the query grid: Student Name, Age.

1. Specify Criteria:

• Under the Age column, in the Criteria row, type >12 (this will display students older than 12).

1. Save and Run the Query:

• Save the query and click Run to see the results.

1. Create Report:

• Go to the Create tab and select Report Wizard.
• Use the query you just designed to create the report.
• Format the report neatly and save it.