The purpose of this database is to record money spent so that we can see where the money goes. The initial fields are a description of where it is spent, the amount and a category plus an ID for the primary key. We don’t do a primary key on the description because we will probably have the same expenses, again and again.
In this first video, we create the transactions table and categories table and add some data to each.
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.
