Learn Access -2.C- Planning (Mark Davis "Broken Ground") (cc) English and French

Planning a Database, part C. Plan fields and relationships for:
- People
- Categories
- Addresses
- Phones
- eMail
- Websites
- Types
- PAdr (cross-reference table between People and Addresses)

*** TRANSLATIONS ***
French: John Viescas (Microsoft MVP, Access) http://www.Viescas.com
Go to the link for great books by John Viescas!

*** CAPTIONS ***
turn Captions on or off:
mouse-over the triangle button in the lower right corner of the viewing window -- then CC or the icon for captions. To translate, mouse-over the left triangle from CC and click the language you desire.

~~~
original music:
"Broken Ground" by Microsoft MVP Mark Davis (cybercow)
http://www.garageband.com/song?|pe1|S...
Mark's website (great search tools here, a worthwhile place to visit):
http://www.endprod.com

~~~
more Access Tutorials
http://www.EverythingAccess.com/tutorials.asp

~~~
Access 2000 Reference Database with ZipCodes, Country Codes, State Abbreviations, Phone Codes, Airlines, and Airports
http://www.AccessMVP.com/strive4peace/Reference

~~~
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
• French
• Mark
• Davis
• Close-Caption
• Caption
• Microsoft
• Access2010
• Access2007
• Access2003
• 2010
• 2007
• 2003

[deviousoverdose]

These videos are really good, I hope you get the opportunity to finish up series 3.

[LearnAccessByCrystal]

@deviousoverdose. Thank you :) I absolutely plan to finish this series -- and now I have finally decided what I will call the main Name fields, which was initially stopping me from doing more; names are important. So far, it has not been an issue -- names always change in the planning stage as you get better ideas. Appreciate you taking time to make a comment..

Warm Regards,

Crystal * (: have an awesome day :) *

[upsfeup]

I really wished that you had continue with the series, The missing part is the most important, actually implementing the design and making the queries go together!

[LearnAccessByCrystal]

@upsfeup -- I do plan to continue, although it probably seems like I have stopped. Sorry. We moved and now we are moving again -- hopefully to a place we can plant ourselves for awhile :) It will be a few more months before I might be at a point to make more videos -- when I can, I will do it !

Thank you for your comment

Warm Regards,

Crystal * (: have an awesome day :) *

[sideshowmom]

Thank you for posting these Crystal! I'm redoing a database for my hobby and following your conventions and Access Basics!

[LearnAccessByCrystal]

@sideshowmom You're welcome, Vina -- beautiful horses :)  -- thanks back

Warm Regards,

Crystal * (: have an awesome day :) *

[azekry17]

Beautiful! Great info and great explainations. I can hardly wait for your next videos. Thank you very much.

[mareko48]

Gidday Crystal,

Thanks for the effort you put into "series 2". Your simple and comprehensive explanations are very helpful, and in my case very timely as I'm trying to develop my first Access database.

I look forward to the next in this series.

Mareko

[LearnAccessByCrystal]

Hi Robyn,

Are you are able to play other videos on Youtube? If so, mine should work too ... perhaps you need to try another time or reboot your computer. If you still have a problem, please describe what is happening. Thank you

Warm Regards,

Crystal * (: have an awesome day :) *

[RobynToles]

I cannot get this to play at all any ideas?

[LearnAccessByCrystal]

Thanks. You are absolutely right!  I am still not sure which way I will store websites for the video. Many:many is more complex and how I do it for myself (smile)

Warm Regards,

Crystal

*

(: have an awesome day :)

*

[mynoitidetube]

Hi Crystal,

You've got some great videos. I had a question about websites though. Would they also be a many to many in relation to people? For example, everyone I work with has the same work website.

Thanks!