<

MS Access – Basics of Designing Tables

Posted on
7,180 Points
380 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
0 Comments

Featured Post

Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Generating random numbers is quite easy, but making them persistent to form updates, deletes, sorting, and filtering takes a little more work. Here we will show how to accomplish this with a few lines of code.
Generating sequential numbers is quite easy, but making them persistent to form updates, deletes, sorting, and filtering takes a little more. Here we will show how to accomplish this in several ways with either little or no code.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month