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) 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 www.JubalLeeYoung.com http ~~~ Look up reserved words on Allen Browne’s site: Problem names and reserved words in Access, by Allen Browne www.allenbrowne.com ~~~ Calendar screenshot from Time Pieces, by Mark Davis www.utteraccess.com ~~~ more Access Tutorials www.EverythingAccess.com ~~~ 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 …
Like this post? Post Comment, Download and Subscribe RSS
{ 15 comments… read them below or add one }
Wow, Crystal! You take the time to answer! A real teacher by heart you show!
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
Good presentation of material, but the relatively long music interludes along with family photos just get in the way.
ooh, I am so glad! Thank you, Barbara — as you can see in 2B, I wasn’t very good about slowing it down!
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!
I printed your 100 page book, Thanks so so much for taking the time.
Wonderful!!!!
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.
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.
thank you, Barbara! ..more pauses … yes, I will work on that! There is so much I want to teach you (have the next several lessons planned out), but I get limited by YouTube’s 10-minute requirement and have to start cutting.
thank you and you are welcome, Steve! I will be showing how to do things in Access 2007 and lower versions side-by-side … so nothing to be worried about! The 2007 interface just looks different, but still has the same functionality
Hey Crystal, Found you via group message by Bill Mosca and I subscribed immediately. I am a user of Access 2000, and so far, everything you’ve mentioned applies. I am always looking to learn new things, but I am scared to death of upgrading to the newest version.
I digress
Thanks for taking the time and effort to showcase your talents here. I truly appreciate it.
Sincerely,
Steve Freeman
thank you, dmalle! … spent countless hours making drawings, I am happy that you like them
Thank you for the crystal clear illustration that make the explanation easy to understand.
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!