| Share this post! | Vote this! |
|
This article offers tips to developers to help them avoid some of the pitfalls when designing Access tables. This article applies to Microsoft Access databases (.mdb) and Microsoft Access projects (.adp).
Contents
Introduction
Understanding Your Data
What Data Do You Need?
What Are You Going to Do with the Data?
How Is Your Data Related to Each Other?
What Is Going to Happen to the Data Over Time?
Learn How to Use Queries
Database Normalization Concepts
Store Unique Information in One Place
Records are Free, New Fields are Expensive
Know When Data Needs to Be Duplicated
Use Meaningless Field for the Key Field
Use Referential Integrity
Conclusion
More...
Contents
Introduction
Understanding Your Data
What Data Do You Need?
What Are You Going to Do with the Data?
How Is Your Data Related to Each Other?
What Is Going to Happen to the Data Over Time?
Learn How to Use Queries
Database Normalization Concepts
Store Unique Information in One Place
Records are Free, New Fields are Expensive
Know When Data Needs to Be Duplicated
Use Meaningless Field for the Key Field
Use Referential Integrity
Conclusion
More...
0 comments:
Post a Comment