<

MS Access – Basics of Designing Tables

Posted on
7,178 Points
378 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month