Creating school databases with Microsoft Access



Microsoft Access is a standard part of Microsoft Office that is often not used by schools.  It can however, be used to create databases that hold information, offer an easy to use ‘front-end’ screen, can analyses, sort, subtotal etc., and can then print reports, letters, labels, emails etc., very easily.


Perhaps you would like to create your own Inventory? Or a lettings system? Or something that records laptops on loan or bookings of equipment? Parent helpers or Peripatetics?


The aim of this course, is to enable schools to create their own databases with data entry screens, analysis tools and reporting options.

his course is designed for any school staff who would like to do learn how to create databases. No prior knowledge is required.


he sessions are delivered live over the internet –4 x 1 hour sessions over successive weeks. Each session has accompanying notes and an assignment to complete.  Attendees can ask questions and interact with the trainer.   We also offer the course as a pre-recorded online training option, where users can login at ANY TIME to follow the course. Notes, assignments and videos are provided on the online platform.  A printed certificate will be issued on successful completion of all assignments.



Session 1

  • Tables – creating tables, fields, data types, views

  • Data entry into tables – manual and import from Excel

  • Forms – creating data entry screens

  • Adding fields, layout, colour, titles, images

  • Using forms to enter data, find, filter, sort


Session 2

  • Queries – creating queries to select certain data

  • Append and Update queries

  • Reports – creating reports, letters, labels etc.

  • Report design, fields, layout, images, page numbers

  • Letters, labels and emails


Session 3

  • Buttons – adding buttons, operators, formatting, aligning & resizing

  • Macros – create and amend macros, adding actions

  • Assign macros to buttons



Session 4

  • Creating a switchboard

  • Automation & start up processes

  • Sharing & Security


The 4-session course costs £99 per school and multiple staff can attend from each school for this price.  

To follow this course at your own date/time using downloadable notes, video recordings and session assignments please complete the form below

Your details were sent successfully!