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
Windows Explorer lets you open archive (tar and tgz) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Handling passwords.
