Here we set the property of many of the fields in the different tables so that the field is required. This makes sure that the user enters data in them. The date of birth field in the students table is date/time format as we might want to do calculations on this date. With the phone number we are just using text because it may not be a complete number – for example might have dashes in it.
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.
