Learn Access -2.B- Planning Database Fields
Channel: LearnAccessByCrystal
Date: 2009-03-10

Learn Access ! Planning, part B: what to do *before* you create tables, queries, forms, reports, macros, and modules in Microsoft Access ...

* Naming Conventions
 - Leszynski/Reddick
* Questions
 - Why Addresses and Phones are stored in separate tables
* Field Names
* Key Fields 
 - Primary Keys and Foreign Keys
 - Natural Keys and Artificial Keys
* Relationships

click 'watch in high quality' below viewing window on right

* CAPTIONS*
turn Captions on or off:
click the triangle button in the lower right corner of the viewing window -- CC

~~~
original music:
"Pool" by Ken Gaines (Houston, Tex) from the "Catfish Moon" CD released in 2006
http://www.KenGaines.com

~~~
Problem names and reserved words in Access, by Allen Browne
http://AllenBrowne.com/Tips.html

~~~
Books by John Viescas
http://www.Viescas.com

~~~
more Access Tutorials
http://www.EverythingAccess.com/tutorials.asp

~~~
Learn Access. Enjoy! Grab a cup of your favorite beverage, relax and open your mind ... send me email for private training or custom programming 

~~~
Post comments!
I read everything and love hearing from you.

*****
FREE book on 'Access Basics'
(even if you are not a beginner, chances are you will discover something new)

Allen Browne's site:
http://www.AllenBrowne.com/casu-22.html
  
Access MVP:
http://www.accessmvp.com/strive4peace

~*~*~*~*~*~
Presentation -- Microsoft Office PowerPoint
Screen-shots -- Snagit
Drawings -- CorelDRAW
Audio -- GoldWave
Video production -- Camtasia

* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!

visit MsAccessGurus and contact me today!
http://msaccessgurus.com 

I look forward to hearing from you ~

warm regards,
crystal

Remote Programming & Training -- connect to me, let's built it together

~ have an awesome day ~