Learn Access by Crystal -- click "Uploads" on right for video list if not showing
LearnAccessByCrystal's Channel
 
 
Hello, you either have JavaScript turned off or an old version of Adobe's Flash Player. Get the latest Flash player.
Learn Access -2C- Planning : English & French Captions
Learn Access -2B- Planning a Database - English Captions
VBA -- Winner by Random Draw
Learn Access -1- Perspective : English French Portugese Captions
LearnAccessByCrystal
Profile
 
Name:
Crystal
Channel Views:
7,506
Joined:
January 17, 2009
Subscribers:
218
~
PURPOSE
The "Learn Access" series takes an idea from concept to application. Since contact information (names, addresses, phone numbers, email addresses & websites) is the heart of most applications, this is where we start ...

We will build tables, forms, queries, reports, and do some coding along the way...

~
GUEST VIDEOS
You will also see great videos about Access created by others, such as Microsoft MVP Albert Kallal.

~
SUBSCRIBE (yellow button at the top) to be personally notified when I post new videos. I will send you a message, which will come to your user account on YouTube. If you (also) want an email notification, send me a message with your email address.


~
TRANSLATIONS!
thanks to John Viescas (French: 1, 2A, 2C) and Luiz Cláudio (Portugese: 1, 2A), a few of the LearnAccess videos now have caption translations! Read (more info) for instructions.

~
QUESTIONS and COMMENTS
I welcome your questions and comments! No question is silly. If you have it, then others do too. As hard as I try to cover all the bases, everything does not occur to me. I appreciate knowing what needs to be better explained. You can post a message to a video -- it will show up once I have read it, so don't worry when you don't see it right away.

~
NEED YOUR HELP
I am looking for an ORIGINAL SONG to use in the next LearnAccess tutorial. Oh there are still lots of great songs I have gotten permission to use -- am particularly looking for a song about "information" or "data" or "organizing" ... or maybe fish (sorry, but you will have to wait to find out why). If you are a musician and have something original recorded, or know someone, please email me.

~
WHAT's NEXT in LearnAccess?
How will you communicate with Access (interface)? What are the main objects you will work with? The next video will answer these questions for versions of Access from 2010 down to 97.

As we go along, I will show you how to do things in both new and old versions. By learning different versions of Access at the same time, you will be more comfortable when it comes time to upgrade.

If you are new to Access, you will learn, from the ground up, how to build an application that can satisfy your current needs with flexibility for growth in the future. We must always look down the road...

These videos focus on concepts you must know to become a master with Access. Most important is understanding how to set things up and what Access can do for you! Once you have this fundamental knowledge, it is simply a matter of becoming comfortable with where the options are for the version you are using.

~
SO FAR, what I have shown you, is just the tip of the iceberg! Now comes the critical part -- getting the structure and relationships right ... and I have made a few more changes. As you will soon find out, structuring is an iterative process.

I have a tendancy to break things down more than most -- this gives greater flexibility, but it does take more time. Oh no, I didn't pick something easy to use as examples to teach you! Once you get through my lessons (including the ones I haven't posted), world watch out!

I say one thing, and others say something different. Try to understand all the points of view -- especially those that oppose each other. No 2 experts even agree on everything! Use an approach that makes the best sense for your way of thinking -- you are the one who needs to be comfortable with the applications that you build.

I hope to give you understanding of tools ... hammer, saw, screw driver... what you do with them is up to you.

~
MORE INFO
Click (more info) for each video for detail and clickable links.

I especially encourage you to visit the sites of each musician that is featured ... it is usually difficult to make a living as an artist -- and we need their creativity in our world!

~
MUSIC
Learn Access videos spotlight original music. If you want to be featured, contact me.

~
SPONSOR
Want to be a sponsor? lets talk -- email me.

*****
About Me:
 
~
Microsoft MVP (Most Valuable Professional)

~
FREE HELP
Read 'Access Basics', a 100 page book with lots of screen shots :) For your free copy, go to my website.

If you want volunteer help for questions that don't relate to these tutorials, please post questions in a public forum -- check chapter 8 of 'Access Basics' or read Channel Comments for links. Thank you

~
CONSULTING
I do remote training and programming with great success. For information on what I can do to help you, send me email. Tell me who you are, your budget if you have one, and your goals.

Crystal@MsAccessGurus.com

~
Deep passion for creativity: art, music, singing, whistling, metal sculpture, carpentry, architecture, growing a garden, ... and the list goes on ... am a creative spirit who is also a bit (a lot?) geeky. Imagination, ingenuity, and appreciation inspire me.

Above all, I wish each and every one of you peace and happiness.

Warm Regards,
Crystal

*
(: have an awesome day :)
*

~
Country:
United States
Occupation:
Mother of 2 boys that rock my world and keep life interesting! I also do Remote Programming and Training. If you want my help, just send me an email Crystal@MsAccessGurus.com
Hobbies:
Photography, Videography, Music, Singing, Swimming, Diving, Rapelling , Camping, Biking, Dancing, being Creative and Happy
Music:
~ anything original ~
Channel Comments (17)
gumpingit (1 month ago)
Thanks for all the work you're putting into this, Crystal. You're making my conversion from Excel far less painful.

Looking forward to the next installment.

Joe
LearnAccessByCrystal (4 months ago)
~
My Subscriptions

bjele123 is Bill "Mr Excel" Jelen ... and wow, has he been busy! Bill has over 500 videos posted on YouTube to teach Excel. The videos I have watched have been great!

http://www.youtube.com/user/bjele123

Bill also has a free interactive message board where you can post questions.

http://www.mrExcel.com/forum
~
nerenl (5 months ago)
Hi Crystal
Just wanted to let you know your training and presentation on Access is most brilliantly and fantastically presented than any of the others I have seen thus far!
Your really set high standards and you make neophytes like me really want to dive in and learn. Thank you :-) ... Regards Neren
LearnAccessByCrystal (5 months ago)
you're welcome, Billiam -- and thank you!

Warm Regards,
Crystal

*
(: have an awesome day :)
*
laurabillnelson (5 months ago)
Thank you, Crystal, for the new You tube video installment 2-c. This is such an important set of lessons, and i have struggled with this for some time, so I am looking forward to replaying them....over and over, LOL, until I get it! Especially cannot wait to see how you do the forms...Thank you so very much for your kindness in sharing these with us, and especially for taking the time to produce such a helpful tool for those of us trying to get "access'. I really hope something WONDERFUL happens for you....something you want or need. That's my prayer for you! Have a Fantastic week!
Billiam
LearnAccessByCrystal (7 months ago)
Thank you, Tony!  And thank you also for the very nice message you left in my Inbox. What you noted, "Nothing is left unexplained." is definitely my goal, happy that you noticed (smile).

I am sorry I have not had time to complete the next tutorial (about half done). Each LearnAccess video is taking about 100 hours -- so not a quick task. But don't worry, I am not giving up!

"You are truly gifted in your ability to deliver totally comprehensible online tutorials in what can be a very complex subject."

Thank you, I love making these tutorials, if I could do it all the time, I would! Your comments inspire me.
tonynkath (7 months ago)
With great respect to all the other excellent video tutorials on Utube your outstanding lessons Crystal are just that bit more refined and presented in a way that a cave man like myself can grasp and understand far more easily. Please Crystal, keep them coming, you're doing a fantastic job.

Sincerely Grateful, Tony, Australia
LearnAccessByCrystal (9 months ago)
~
My Subscriptions

DemoTrainer is Microsoft -- of course, I had to subscribe ... they are masters because they have awesome people with brilliant minds and heart (those I have met)... that is one reason Access is great. The DemoTrainer tutorials illuminate and transfer logic with correctness and captivating performances. There are only 3 Access tutorials on DemoTrainer (at this time -- more are on their website, link posted 4 days ago); definitely worth your time.

For anyone learning or using Access 2007, 'Meet the Navigation Pane' is outstanding and imparts essential knowledge.

http://www.youtube.com/watch?v=7GRii_sTa6M

There are lots of other topics too ... do you want to know about SharePoint?
~
LearnAccessByCrystal (9 months ago)
~
My Subscriptions

In Val's Art Diary, marvelous pools of color turn into beautiful and thought-provoking images. Glimpse a world with imagination as Val brings you on a journey through life as an artist; "dancing, dreaming, living, loving, and being".

She expresses her unique views of life through her wonderful paintings and, surprisingly open and sometimes heart-wrenching, words.

When designing a database, it is important to see what you are building from every angle. The inspiration to do this comes from many places. Insight is what distinguishes the master from the apprentice.

The ability to design and develop an intuitive application requires lots of thought and fresh perspectives. So enjoy some art!
~
LearnAccessByCrystal (9 months ago)
thank you, John ... not sure I deserve to be called a 'legend' -- but I appreciate the nice comment! Looking forward to having you as a subscriber :)
  1   2    Next