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.
*****
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 ~
Subscriptions
(5)
Channel Comments
(17)






Looking forward to the next installment.
Joe
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/bj
Bill also has a free interactive message board where you can post questions.
http://www.mrExcel.com/forum
~
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
Warm Regards,
Crystal
*
(: have an awesome day :)
*
Billiam
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.
Sincerely Grateful, Tony, Australia
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
There are lots of other topics too ... do you want to know about SharePoint?
~
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!
~