Learn Access -2.A- Planning (Jubal Lee Young "I Don't Know What I Want") English French Portugese

Planning a database takes time. A good design is everything when it comes to Access; structuring data is the most important thing to do well. This foundation tutorial is the first of 3 parts on Planning -- what to do BEFORE you create Access objects ...

- Prepare
- Visualize
- Organize
- Design for Flexibility
- Naming Guidelines

*** TRANSLATIONS ***
French: John Viescas (Microsoft MVP, Access) http://www.viescas.com -- be sure to check out John's books!
Portugese: Luiz Cláudio (Microsoft MVP, Office)

*** 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:
"I Don't Know What I Want" by Jubal Lee Young from the "Jubal Lee Young" CD released in 2007
http://www.JubalLeeYoung.com
http://www.MySpace.com/JubalLee

~~~
Look up reserved words on Allen Browne's site:

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/AppIssueBadWord.html

~~~
Calendar screenshot from Time Pieces, by Mark Davis
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=1...

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

~~~
Enjoy while you learn Access ! Make a nice pot of hot tea or coffee, get comfy in your favorite chair and just absorb ... Email me for custom programming and private training:

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
Drawings -- CorelDRAW
Screen-shots -- Snag-It
Audio clips -- GoldWave
Video tutorial produced with Camtasia

~

Category:

Science & Technology

Tags:

• Learn
• Access
• Planning
• Database
• Crystal
• strive4peace
• Portugese
• Jubal
• Lee
• Young
• Close-Caption
• Caption
• Access2010
• Access2007
• Access2003
• 2010
• 2007
• 2003

[Amocabana]

Good presentation of material, but the relatively long music interludes along with family photos just get in the way.

[LearnAccessByCrystal]

Hi Amocabana (what is your name?)

Thank you -- I do have more music here than my other videos as pictures tell a better story than I can say ... meanwhile, why not listen to a great song?

We have so much to organize! The first structures I will introduce in Access, as it turns out, do not include photos .. not because they are not important, but because you need to walk before you run.

I want to teach you to structure with flexibility ...

Warm Regards, Crystal

have an awesome day

[luvfsh]

I printed your 100 page book, Thanks so so much for taking the time.

[LearnAccessByCrystal]

you are welcome, and thank you! For those of you who want 'Access Basics', click (more info) in upper right for a link

I like the videos you make for your children -- it is great that you do such creative things for them!

[compdinosaur]

Hi Crystal, I'm becoming more adept at using YouTube videos. We have the advantage of pausing and replaying so we don't need long pauses. We can "freeze" a screen of interest then go on when ready.

[LearnAccessByCrystal]

ooh, I am so glad! Thank you, Barbara -- as you can see in 2B, I wasn't very good about slowing it down!

[compdinosaur]

Great graphics, music and use of color to highlight organization. Would like more pauses (to take a breath) between main sections before screen changes. A lot of important organizational concepts concisely presented. Great job!

[dmalle]

Thank you for the crystal clear illustration that make the explanation easy to understand.

[tcnewkirk]

Love it! I am keeping it to help me organize a database of music-related information I've been gathering. Have you heard Jubal's newest CD ("Take It Home")?

[Amocabana]

Wow, Crystal! You take the time to answer! A real teacher by heart you show!

[LearnAccessByCrystal]

Wonderful!!!!

[RockslideProject]

Family is always the harshest critic. You get a great rating from your oldest brother, who went to college when there were no PC's, no hand held calculators (well, there was one, it was only 4-function, inaccurate, and cost almost 600 times minimum wage--and he had it only because his father was a senator--that was cutting edge).

Years later, when PC's arrived (Radio Shack) the general advice was "Don't waste your time, personal computers are a short term fad". I listened, now trying to learn.