Microsoft Access 2010 Tutorial Part 12 of 12 - Review

If you enjoyed Level 1, you can buy the complete Level 2 course for just $1 here: 599cd.com/XAC13B2YT - This is the perfect class for anyone who is new to Microsoft Access 2010. If you have little or no experience with databases, or you just want to get familiar with how Access 2010 works, this class is for you. You should have some basic knowledge of Windows beforehand, and a little bit of Microsoft Word or Excel helps (so you're familiar with some of the basic, common features), but we'll teach you everything you need to know to use Access to build a simple database.

[@user-bq3hj5es3e]

Only great teacher and expert can do great teaching. You are a greater one. Thank you for the entire tutorial. Salute

[@599CD]

You're very welcome. I appreciate all of the compliments, folks. :)

[@Darkshogun7584]

Easily the best tutorial around.. Your videos are informative and your in-depth explanation has provided great help to me who is completely new to Access. Great work!

[@jwduke1904]

In one evening, lying on my bed, I have created a database from scratch! Absolutely well structured, short enough to keep it interesting. Good Work. I'm off to your website...

[@599CD]

Glad you enjoyed!

[@599CD]

Thank you for the compliments. I taught in my own Computer Training Center here in Amherst, New York for about 10 years before I started online tutorials.

[@judzm]

I am a newbie in MS Access and I must say I have a strong foundation now after watching your videos from 1-12. Many thanks for your hard work and hope your business continue to prosper. Cheers!

[@CMaher-po7tl]

Thank you again for your thorough training on Access. I haven't used it in about ten years and now I am glad I checked out your training videos!

[@SimonJayes]

Thanks for the videos. I have since gone on to purchase the remaining beginner and expert videos and am learning at great speed. I particularly enjoy all the little handy tips you provide whilst actually showing how the software works

[@bijaymishra6774]

This is just too good... I have patiently gone though all the 12 videos of Access... Thank you for increasing my knowledge on MS Access.

[@philipmodelle6074]

Great series of videos. Thanks a lot for taking the time to publish these on KZbin, they provide a great foundation for future use of the program and are by far the best entry level videos that I've found yet. Bravo.

[@patrickverbeek6425]

Best online tutorial ever; and I've seen a lot of them!!! You saved my job, many thanks!!!!!!!!!!!!!!

[@599CD]

welcome!

[@barbarastirling5902]

Wow! You did it! You did what no one else could do - get me to learn Access! It's no small thing. I've been a computer instructor for over 16-years. I specialize in Photoshop and really wanted nothing to do with Access. I just couldn't put the pieces together for some reason. When I was a training manager, I had my other trainers take care of training the Access classes for me. Now I need to know it and you are the only one that has presented in such an easy-to-follow, logical and interesting format that I finally have it down. Looking forward to your other courses. Thank you! Thank you! Thank you!

[@599CD]

You're very welcome.

[@judyparker6435]

I've learn much more here in one day than I did taking the class at local college..thank you

[@Fifty-50]

Thanks for your quick reply? The tutorial gave me more than I asked for. So far I have all my data stored in spreadsheets and will now import it to access. I`ll keep following your tutorials on your website. I am grateful to you for this information.

[@599CD]

@Strategory76 Thanks for the compliments. Level 2 is coming. I had planned to have it ready shortly after posting Level 1, but then the holidays happened, and I came down with the flu, and just haven't been able to record video. I'm working on it now, and it should be finished soon.

[@LaurelChinn]

Thanks for a great, easy-to-follow program. I had taken a class in Access years ago, and this refreshed my memory and taught me new information.

[@qumarulislam4450]

Thank you alot. for all the dedication and hardwork. your help will really help those who could not afford to go to schools but need to learn Access. your help will not only help individuals to excel in their jobs and career, particularly in poor countries but also increse the shortage of capable labor/ staff in those economies. i count you among the people who change history.

[@599CD]

Thank you so much. :)

[@599CD]

@muscletrainer30 Thanks for the compliments. You would need to use a TEXT field to store values like "1-2012". However, if those represent dates, I'd recommend storing them in DATE fields and making the value "1/1/2012". You'll be able to better sort, search, and filter later on.

[@aguthrie8267]

This is wonderful, thank you so much! I've been learning Access at work, but more advanced functions, etc and I didn't even understand what a query was! This has help immensely

[@opheliaday4738]

Thank you for all of your help. You have easy to follow tutorials that have been well thought out.

[@599CD]

Sure am. Just follow the link in the description under the video.

[@MrGameplay2498]

I just found these videos. I've been wanting to get a better idea of how to build an Access database and these videos have been extremely helpful! Thank you for making these!

[@KeebasLife]

I've been working with Access...off/on for many years but this was a great refersher course! Thank you!!

[@Grow5ft]

You did a very good job with this entire tutorial. I really liked it, it was much better than any college lecture I've been to.

[@AnJoTVNOW]

Thanks so much for creating this series. It was very helpful and a great refresher course.

[@Twiflowers]

I am very happy to pay for your effort. really helpful and easy to learn. Thanks for teaching us in a very logical and considerate way!!

[@kieronmcgahan8617]

Just completed the beginner level 1 and looking to progress - very good

[@LaTostis]

Thank you! Thank you! Thank you! I've taken the whole series. The tutorials are great, one of the best I've seen. I look forward to continue taking more of your tutorials and I hope you offer Microsoft Project one day. You already have at least one student for that class :).

[@599CD]

My pleasure.

[@kumaresamanikaruppasamy9165]

I am really thankful to you to teach me the entire MS Office Access 2010, its very useful to me.Now i plan to study all your topics about MS Office. Thank you Sir.

[@599CD]

Welcome

[@llttrinh]

I'm very thankful for these tutorial videos. They were great.

[@bridgethemstreet8057]

Excellent lessons. Easy to follow along. I appreciate your straightforward approach while demonstrating with screen shots. I am a visual learner.....

[@599CD]

Thanks

[@TigerLIL-yo3gq]

A great way to continue your legacy as a teacher...thanks so much for these videos

[@599CD]

Oooh... I have a legacy? :)

[@UltimateUnknown]

This has been absolutely awesome. Thanks for the quick crash course :)

[@quad9363]

Thank you for these videos, really simple and easy to understand.

[@599CD]

Glad you enjoyed it.

[@manu053299]

Thank you so much for your beginner tutorial. It was very help for me to understand very basics of access.

[@randybueno2393]

Wow,thank you for this Access tutorial just a beginner. This will be a great help in my work. Looking for more tutorials.

[@599CD]

Welcome

[@kathychristian1783]

Thank you for your free tutorials. I am about to take an online assessment for an employment agency on Access, and I only used it briefly many years ago. I took their tutorial, but it seemed complicated. Yours was clear and easy to understand, and I appreciated your tips from your personal experience with Access. This 12-part tutorial (really Parts 1-11) was a great overview for beginners. I feel more confident now about getting a good score on the assessment. I like the way you have broken down the lessons into short segments so I could take breaks between them.

[@599CD]

Thank you. Make sure you check out the new version: 599cd.com/ACB1

[@Excel1949]

Enjoyed all of the videos I watched and being a beginner I am looking forward for the rest of all lessons Thank you, Ajayi

[@alfonsobarrero9685]

Thank you very much! great teaching, very complete information! looking forward for your next level 2!!

[@599CD]

Thank you. You can find Level 2 on my web site here: 599cd.com/XAC13B2YT

[@KraftyLu]

Your videos are great, nice teaching voice and easy to follow along, Thanks!

[@599CD]

welcome

[@legumtv858]

Thank you, Richard. Watched all 12. Want to learn more on Microsoft Access.

[@599CD]

Here ya go: 599cd.com/ACB2

[@alawnrunney7317]

Thanks for your free tutorials, that's very useful and helpful. Thanks again!!!

[@599CD]

Welcome

[@saitheja8714]

Thanks.tutorials were very useful. You explain really well, you are a great teacher.

[@coolzero89]

This is really awesome ive downloaded all of this tutorials... :) thanks a lot.

[@maheshchandpradhan6060]

THANK YOU VERY MUCH FOR GIVING A VERY BASIC CONCEPTS ALL THE COMPONENTS ON ACCESS DATABASE.

[@599CD]

You're welcome.

[@shaishman5318]

wow! By far the BEST training yet!! THANK YOU!!!

[@599CD]

welcome

[@th000111222]

Thank you for posting these tutorials. You are a great teacher.

[@599CD]

My pleasure

[@beyondblue2986]

Very well put together, thanks for your help.

[@2SHOTDAVE]

AWESOME VIDS!!!! I just watched all 12 vids!!! you did it perfect! not too fast or too slow!

[@RajanOA]

hi, Thanks a lot for the excellent lessons. I have seen almost every one of it and could make an application myself.

[@loubrian6256]

Marvellous piece of art. Peaceful!

[@599CD]

Thank you tremendously

[@pavanjadav6853]

Thanks for the free tutorials on access its very useful and you explained it very easily. Thanks for that

[@599CD]

welcome

[@allredhead]

Well Access was the last thing I had to learn for my competition... Maybe I will even get first place at the Skills USA state comp. because of your videos. They were very detailed and helped me a great deal. I wish I had more time to subscribe on your website, however, I just don't have the time. Thank you very much.

[@Scc52760]

Thank you for your teaching, it's very helpful and easy to understand.

[@599CD]

Welcome

[@599CD]

Each CLIENT will have their own ClientID. If you use an AutoNumber, then no two clients will have the same ClientID. Now if you want to track ORDERS for each client, then you need a second table. The OrderT table will have a unique OrderID plus it will link back to the Client by storing a ClientID as well. And yes, you can use a subform to display that if you want. I cover this in a lot more detail in my EXPERT classes (too much for beginners) and in my ACCESS RELATIONSHIP SEMINAR.

[@priyaelumalai9586]

The course was great!! Nicely explained. Thank you so much for the author.

[@hidayanour]

Thank you Very much . you are an EXCELLENT teacher , the lessons were great !

[@roniasatriawan4062]

I love your works. Thank you so much.

[@599CD]

welcome

[@599CD]

Yes, Access is definitely the right tool for the job. As far as "sending a signal to a sorting system," I'm not exactly sure what you're talking about here. If you want to actually have Access communicate with a machine, that would depend on the machine and what type of interface it has. Access can easily prepare a report you can print to show the sort order. As far a macros or VBA, that's up to you. I prefer VBA over macros myself. It's much more powerful.

[@sukirisam]

This is very good for beginners. thanks for your help.

[@pambo68]

Absolutely brilliant - thank you so much.

[@KingJarlaxle]

Fantastic videos. Great job.

[@599CD]

My pleasure

[@shawnvi7589]

I love this course it was really beneficial.

[@katahajnal3416]

Thanks so much for doing this, it was a real lifesaver!! Exactly what i was looking forb:)

[@599CD]

Welcome

[@599CD]

Relationships are beyond the scope of my beginner tutorials. I cover them in Expert Level 1 and my Relationship Seminar (available on my web site). In a nutshell, on your Invoice form you would set up a combo box to select a student from the list and that will save the StudentID in your Invoice table. No need to enter it yourself. No need to have the name stored twice.

[@robertnettey7424]

Your lesson was great, Thanks.

[@yrrebdus010]

Great Tutorials Thank You.

[@carbilledo]

thank you so much sir. i really learned a lot

[@user-uq5fe3yg5q]

Your videos were very helpfull. Thanks for the patience you had to make those.

[@599CD]

Welcome

[@SwishaMane420]

Man, this helped me a LOT

[@clairedaisy3576]

Thank you for providing good basic knowledge on MS Access. Looking for lessons on advance MS Access.

[@599CD]

Welcome. Lots more lessons on my web site 599cd.com

[@rebeccagobin8086]

Thank you so very much. This was a great help :)

[@TheHimalayanDiary]

thank you very much sir to make it easy to learn and understand access.

[@599CD]

My pleasure

[@OvidiuHerman]

Thank you !!!! Your tutorial was very useful !

[@599CD]

My pleasure

[@599CD]

@ConnectinPeople Yes, Level 2 is available on my web site. No, it's not free, but it's only $9.99... and for KZbin viewers you can get a 50% discount by clicking on the link above (in my Level 1 video notes). So it's really only $5. I'm actually working on Level 3 right now.

[@Fullcontact1992]

you really are great in teaching .

[@599CD]

Thanks

[@rashmikant1972]

great teaching - thank you

[@Samsinnify]

really great tutorial, thanks!

[@599CD]

Welcome

[@ibrahimabdullahi8414]

thank you very much you videos have been very helpful

[@599CD]

You are very welcome. Glad you enjoyed!

[@ramchandranepal9598]

Very nice tutorial, thank you.

[@599CD]

You are welcome!

[@Inquire98]

I Thank GOD 😇and I thank you VERY much Your presentations are FLAWLESS 😉

[@599CD]

Glad you like them!

[@cypressroll]

this was very helpful, thank you for the tutorial.

[@599CD]

Welcome

[@bradwelch6714]

Thank you for the beginner tutorials, now I know what I will be getting in to when I start my database management class, which maybe some time from now. I want to know can I go watch the SQL tutorials now or should I go watch the intermediate tutorials first? What is the difference between advanced tutorials and expect tutorials?

[@isheludko]

Great explanation!

[@599CD]

Thanks

[@mansoural-harbi7761]

Big big thanks bro really it's clearly explanation

[@bhagyajayarathne8205]

very helpful videos and you are great lecturer..

[@599CD]

Thanks

[@mylaylay18]

Excellent! Thank you!

[@599CD]

You're very welcome

[@599CD]

My SQL Seminar is a 3-part series. Part 1 is the basics and doesn't assume you know anything about SQL, however you would benefit from having finished my entire Beginner Series of lessons (1-9, part 1 is the only part here on KZbin) first.

[@arphedix]

thanks u did a great tut!

[@599CD]

@AReavesTHC Very soon... another week or two.

[@escapology7]

Thanks. i have idea of what Microsoft Access is from your youtube video. i have much of clarity to use access and apply in the future . thanks again .

[@599CD]

My pleasure

[@viewtoneachaga9144]

so helpful>>>>>>>>>>> thank you Richard

[@599CD]

Welcome

[@ayemyatsoe7595]

Thank you for learning basic things

[@599CD]

You're welcome.

[@abdullahalfanar]

Thank you so much for the videos. I will check your website later.

[@tamannasoni747]

Thanks a lot sir These lectures help me lot to learn access

[@599CD]

My pleasure.

[@lunaxenophilius6746]

thank you very much you did great job. this video helped me thanks again

[@599CD]

Welcome

[@abhiraja7173]

YOU ARE THE BEST!!

[@stansmw]

Excellent for Beginners!

[@599CD]

Thanks

[@marknasri1201]

great video, thank you

[@599CD]

My pleasure.