This video describes the advantages of a relational database program such as Microsoft Access:
1. Each piece of information is only held once so, for example, if a student gets married and changes her name then we just change the last name field in the student table and all report and queries will show the new name automatically.
2. Queries and Reports automatically show any new data as the report and query design is seperate to the data.
3. To insert data in a table we can look it up in another table. This stops spelling errors.
4. Using a primary key index stops us entering duplicate data by mistake.
5. We can design the database to suit our needs and change it or add to it. We cannot do that if we buy “off the shelf” programs.
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.
