6:30
Jim Dettman (EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Video Steps
1. Split up all multi-value fields into single values
2. Split up fields that belong to other things into separate tables
3. Make sure that all records will have the same “shape” (all fields can be filled in) and that there are no repeating fields
4. Make sure that all fields are independent of one another. No field should rely on another for it’s value
5. Assign primary keys
6. Add copies of primary keys to tables (called foreign keys)
0 Comments
Suggested Videos
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete…
- Microsoft Office
- Microsoft 365
- Microsoft Access
- Math / Science
- VBA
- Microsoft Excel
I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also prot…
Suggested Courses
Next Video:Shuffle - 2 - Totals Query