After using the look up wizard to look up fields on some tables from fields in others we go to the relationship tool to enforce the referential integrity of the joins. We arrange the tables on the relationship view so that it is easy to see these joins. We can now do some queries by selecting the tables that the query uses.
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.
