Learn Access -2.B- Planning a Database (Ken Gaines "Pool") - (cc)

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

~~~
Leszynski/Reddick Guidelines for Microsoft Access
http://www.MVPs.org/access/general/gen0012.htm

~~~
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

LearnAccessFromCrystal AT gmail.com

~~~
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)

Bill Mosca's site:
http://ThatllDoIT.com

Allen Browne's site:
http://www.AllenBrowne.com/casu-22.html

Utter Access:
http://www.UtterAccess.com/forums/showflat.php?Cat=&Board=68&Number=1...

Access MVP:
http://www.AccessMVP.com/strive4peace

~*~*~*~*~*~
Have an awesome day ~
~*~*~*~*~*~

Presentation -- Microsoft Office PowerPoint
Screen-shots -- Snagit
Drawings -- CorelDRAW
Audio -- GoldWave
Video production -- Camtasia

~

Category:

Science & Technology

Tags:

• Planning
• Database
• Crystal
• Learn
• Access
• strive4peace
• MVP
• Primary
• Key
• Ken
• Gaines
• Close-Caption
• Caption
• Access2010
• Access2007
• Access2003
• 2010
• 2007
• 2003

[zurriagazo71]

Crystal

We are two final year computing students and have done some voluntary work with Acces for some companies. Now we feelvery confident, we´d like to start a freelance database sevice aimed to small business in the area. We´d very much appreciate if you gave us some guidance before taking on this project.

Many thanks and look forward to your response.

Antonio

[LearnAccessByCrystal]

Hi Antonio,

thank you. Start by setting up good structures and relationships that are flexible enough to carry the project into the future. Click (more info) in the upper right and follow a link to 'Access Basics' and read it. Pay close attention to the sections on Normalization and Relationships. You don't have experience to build on -- but, if you study, you can be a success. Good luck with your projects.

Warm Regards,

Crystal * (: have an awesome day :)

[ozairkhalid]

Hi Crystal,

I appreciate your efforts, it is really great work you're doing.

Very Best Wishes.

Ozair.

[LearnAccessByCrystal]

thank you, Ozair!

[specialk1474]

WOW! This is Wonderful, you have been really busy! Thanks for sharing your vast knowledge!

[LearnAccessByCrystal]

thank you, Karen ... the reason your comment didn't post right away is because I need to approve them and I am not always looking. Download 'Access Basics' -- that will be a big help to you as well (smile) -- link in (more info) in the upper right

[specialk1474]

Hello Crystal! This is totally AWESOME! Now I can watch this over & over and maybe it will finally sink in for me to understand. I have really got to get my database working......Warm Regards

Karen

[LearnAccessByCrystal]

thank you, Karen! One of these days, I will make a video on how to download videos ... only my subscribers got this information -- y'all are very special to me!