We realized that the relationship between the songs table and the party types table is a many to many because one song can be good for many types of party and one type of party would have many songs. We need to put a table in the middle of the two tables in the same way as we did between CDs and the songs. We make a query using five of the tables.
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.
