<

MS Access – Basics of Designing Tables

Posted on
7,182 Points
382 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
6:32
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)

3
0 Comments

Featured Post

Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

“The Microsoft Jet Database engine stopped the process…” while working with a Microsoft Access database. The database may be saved as MDB or ACCDB file depending on the Access version that you used to create the database file.
Do you need a date time picker, how about just a time picker?  Would you like to use something other than the basic Access date picker which is available when you have a textbox which contains data formatted as a date? Give this date time picker a t…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month