Making a subform for bookings
Channel: Andy Dolinski
Date: 2014-01-31

A video I have made showing students how to create subforms in Microsoft Access 2013.  This video is specifically aimed at those students studying OCR ICT A-Level, unit G064.

The database is based on a bike hire system.  Each booking can have multiple items.  The problem that needed to be solved was that the system needed to dynamically calculate the sub-totals for the items and then calculate the final total.

This was solved by creating a query for the booking, using it to create a form with a subform, adding a new field to the query and then adding a new text box that calculated the final total.