As in our previous examples we go the relationship tool and set referential integrity between the tables. We showed that when doing a query we must select all three tables to get a correct results. If we only select the classes table and the students table but not the enrollment table that joins them then we will get results that are not correct but are a combination of all classes together with all students.
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.
