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.
