Access 2010 Tutorial - A Comprehensive Guide to Access - Access Made Easy

The concepts learned here apply also to other versions.

1:00 Database Components
7:48 Creating a Database with one table in Microsoft Access
18:40 Importing data from other systems to create tables in Microsoft Access
27:50 Linking tables in a database in Microsoft Access
40:40 Designing queries using one or more tables in Microsoft Access
48:40 Designing a query in using the design view in Microsoft Access
54:10 Sorting and applying filtering in a query in Microsoft Access
1:00:03 Advanced queries and creating a calculated field in Microsoft Access
1:10:10 Simple and compound forms in Microsoft Access
1:24:45 Designing and modifying reports in Access in Microsoft Access
1:32:40 Creating a Mail Merge and exporting data to Excel in Microsoft Access

This video covers:
- General concepts on databases and components of a database
- Creating a database from scratch with one table
- Importing data from other systems to populate tables
- Linking tables in Access
- Designing queries using the design view
- Sorting and filtering data
- Advanced queries
- Simple and compound forms
- Designing and modifying reports
- Creating a mailmerge from access

Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

[baileyj]

Sali, you are the first person I have commented on in YouTube. This video is the best tutorial I have seen. You are very thorough in your description of Access. Your presentation is clear, your information is pertinent and you remain focused on the objective of teaching access. I have been looking for over 10 years for a program to help me consolidate and organize my restaurant inventory, prices and menu. I have used Excel with minimal results. Access is my saving Grace and you have made it so very simple. Thank You. I was about to spend over $300 to purchase a program on line that almost does everything I want. I began to look at the program and found out it was an Access file. So here I am watching your video. You saved me $300. Thank You.

[butonatorix]

It really is impressive, how someone can teach you in less than 2 hours something a teacher tried in a few weeks. Thank you for your work!

[KaceliTechTraining]

Here is a link to my full video on using Microsoft Access 2013. It covers concepts on creating a database from scratch, importing content, creating new tables, linking the tables, creating queries, forms and reports. Feel free to embed and share it with your friends. 

[koagyeman]

The video was great and I enjoyed following it. It was concise, simple and had no difficulty spending more than an hour watching it. Thank you for sharing.

[laoluthomas]

The presentation is explicit and makes contents to be easily absorbed. You're great!

[seancox]

Thank you for the simplicity of the video. Each step was explained and the reason for each step.

[katialiakopoulou]

A very comprehensive tutorial for all the basics of Access and an excellent presentation from Mr Kaceli.

[kekidk]

Your SO good at explaining this!! Lovely voice to listen to!! Fab. Thank you so much you do not understand how much you have helped me! Now I can pass. So really this video was life changing!! Thank you Sali!! Have good day, thanks again!

[Orielle]

Excellent! This is just what I need since I am starting to build a Personnel DBMS for our college. Thank you Sali!

[simoneholladay]

Thank you so much Sali! Your calm voice and simple language help it make sense.

[Luca_Bo]

Mr Kaceli you are a natural teacher, excellent. grazie mille

[HumblePepper]

I just want to leave a comment to thank you for your awesome video. I've tried to learn access for so long and through your video I finally get it.

[reymundopanaguiton]

That's a very nice tutorial on Microsoft Access. I'm trying to put a small business now that I may be needing this program. I learned a lot in this video. It's extensively discussed and well explained. Thank you very much for sharing.

[padovanov]

Very easy to understand and clear explaination of Access basics. Thanks.

[sivanamoah]

very helpful, from this video, i've recovered what i learn't long tym ago and gain more experience. no need to go to school again...

[TalhaStudios]

The Best Video so far on Youtube that explains easily and in depth!

[fiona]

Very clear explanation. All important details were explicitly pointed out. Thank you very much! :)

[abubakarhalima]

what a lovely , well explained and very educated video, you are the best

[stevenyates]

Excellent video! Very informative and far more interesting than reading a book! Thank you.

[GeeGollySwell]

Thank you for making this. I had to learn this quickly for a deadline and this helped me jump right in.