Databases (Year 9)

Searching Databases Using Queries

You need to be logged in to view and download these files.

Creating a database for a school using Microsoft Access

We will be making a database for a school. The database will contain records of students, teachers, and classes. Download the files below. (Grade 8 Databases- School Database.zip)

1. Importing Students - Instructions - http://bit.ly/KS3dbSCHOOL1

2. Importing Teachers- Instructions- http://bit.ly/DBteachersIMPORT

3. Creating a Form to show the teachers- http://bit.ly/DBteachersFORM

4. Adding Navigation Buttons http://bit.ly/DBnavButtons

5. Creating queries to help find student records http://bit.ly/Y9dbQRY

6. Importing the classes (follow Importing Students - Instructions but for the Classes table.

7. Joining the tables http://bit.ly/DBjoinTABLES

8. Creating the main menu form http://bit.ly/DBmainmenu

9. Changing the student form to show students' classes. http://bit.ly/DBaddFIELDS

10. Creating a report to list the students in each tutor group http://bit.ly/DBreport1

11. Add some more functionality to your database. Design, record navigation buttons, form navigation, add more queries (search on class, date of birth)

12 . Check your marks- Database mark rubric