Further Links Contact Us Search Help

Syllabus | Exams | Assessment | Resources | Site reviews | Careers

Information Processes and Technology

Home > Information Processes and Technology > Information Systems and Databases > Enrolment database - practical task

Making Queries

1. Open the Database Yr 6 into 7.mdb click on the Query button on the left-hand side.
   
   
   
   
2. Click on Create query by using wizard.
   
   
   
   
3. Click on Sex and use the  button to move it across. Do the same with Class type and then Click Next.
   
   
   
   
4. Type in the name Mainstream Query and select Modify Query Design.
   
   
   
   
5. Type the following criteria
   
   Sex = “M” or “F”
   Class Type =”M”
   
   
   
   Close and Save the Mainstream Query.
   
   
6. Double Click on the Mainstream Query to view the results.
   
   
   
   Close the Mainstream Query.
   
   
7. You will need to create 3 more queries one each for Selective, Support Unit and Mainstream Gifted and Talented. Use the following Criteria.
   Type the following criteria
   
   Selective
   Sex Sex = "M" or "F"
   Class Type ="S"
   
   Support Unit
   Sex = "M" or "F"
   Class Type ="SU"
   
   Mainstream Gifted and Talented
   Sex = "M" or "F"
   Class Type ="MGT"
   
   
8. View all of your queries before proceeding.

Creating Reports

1. Click on Report on the Left-hand side, then click on Create report using wizard.
   
   
   
   
2. Select the Query: Mainstream Query from the drop box.
   
   
   
   
3. Select Sex and Class type and Move them to the Selected fields box using the  buttonand then Click Next.
   
   
   
   
4. Select Sex and promote it above Class Type using the  button and then click Next.
   
   
   
   
5. Select Class Type to Sort query by and then click Next.
   
   
   
   
6. Select Align Left 1 for the layout.
   
   
   
   
7. Choose a Style.
   
   
   
   
8. Name the Report Mainstream Report and click Modify the report’s design.
   
   
   
   
9. Using the Arrow in the Toolbox move Class Type from Detail and place it next to Class type in the Sex Header.
   
   
   
   
   
   
10. Using the Text Tool Aa from the Toolbox draw a text box and Label it Total and Type =Count(*) in the box to the right of caption Total. This will total the number of Males or females and display their total separately.
    
    
    
    
11. Add another Text box in the Report footer. Just click and drag the textbox tool over the grey report footer area and it will automatically expand the area. Call this textbox Total and type in =Count(*) in the other box. This will total all students for the Mainstream.
    
    
    
    Close and Save the Report
    
    
12. Open and view the report.