Continuing from the previous video we take the sum of the cost of the classes and sum of the amount paid for the classes for each student then create an expression which will deduct the amount paid from the cost of the classes. This is shown using separate queries or just one query to do everything.
Free Database Tutorials From VTC:
Access 2010
Access 2007
Access 2003
Access 2002
Access 2000
Access 97
Database Optimization
Data Modeling
Visual Basic for Access
For more free database, programming or software tutorials click here and do a search or click one of the categories.
