<

Go Premium for a chance to win a PS4. Enter to Win

x

MS Access – Basics of Designing Tables

Posted on
7,149 Points
351 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
6:32
Jim Dettman (Microsoft MVP/ 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)

3
Comment
0 Comments

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month