How to use Microsoft Access - Beginners Course (Deep Dive)

Dive deeper into how to use Microsoft Access in this beginner's course. This video builds on concepts from Microsoft Access Tutorial - Beginners Level. In this tutorial, you will learn how to set up and customize fields for your table in Microsoft Access, import data from an excel spreadsheet, create a 1 to many relationships with two tables, create a form with controllers and drop-drowns, get more specific with your queries in Microsoft Access, create a report based on a query and learn to export your data. Use the timestamps below to navigate the video.

0:00 Introduction
0:48 Why use Microsoft Access
2:44 Create a blank database
3:43 Create a table and add fields for students
8:06 Add a record to the student table
10:32 Import data from excel spreadsheet into a created table
13:19 Import data from excel spreadsheet into a new table
14:58 Create a relationship between tables (one to many)
22:56 Customize table fields in Microsoft Access
34:56 Create a form
37:05 Create a form with the form wizard
38:06 Customize the look of your form
45:47 Add a combo box to your form
49:55 Add an image to your form
51:05 Add command buttons to your form in Microsoft Access
56:16 Add a record with your form
57:30 Using Sort in your tables
58:59 Creating queries in Microsoft Access
1:03:33 Adding criteria to your query
1:07:06 How to use parameters and wildcards in your queries
1:10:50 Using the greater, less than or equal in the criteria
1:13:29 Create a report form a query
1:18:16 Export tables, forms queries, and reports

[nigelhopkinson]

After delivering L3 BTEC IT to a number of students over the past few years, I have to say the tutorials you have produced is helping in my delivery of content to my students. I have struggled to make the Pearson content less "dry", Thanks for the big assist!

[johnrhule]

Thank you Jamie that was great. It all came flooding back to when I did my ECDL Microsoft Access course in 2005.

[ywjcdbs]

Thank you for doing this tutorial vlog, It's easy to follow. Looking forward for another video regarding ms access part 3. More power.

[promise]

Wow. This tutorial was lit. It has highly improved my impression on this application. Thank you for the program.

[grahambrown]

This tutorial and the beginners, I found amazing. The subject areas covered and the clarity of the presenter made it easy to follow. I needed to go back and learn the basics, because I have a task to migrate an Access procurement system to Microsoft Dataverse. This tutorial provided helped me refresh my knowledge. Thank!!

[stephenbordenkircher]

Thank you for a job well done I have struggled with table relationships and you made if much clearer. Thanks Well done.

[shangyili]

Well organized and super pratical, thank you Jamie for the great videos. Looking forward to learning more advanced skills of Access from you.

[vmt]

wow this is the most amazing tutorials have come across it has open me up to alot

[dagspk]

The best Tutorial on Access you can ever come across, very fluent and basic examples. Amazing amazing 😍😍😍

[stardommansion]

0:00 Introduction
0:48 Why use Microsoft Access
2:44 Create a blank database
3:43 Create a table and add fields for students
8:06 Add a record to the student table
10:32 Import data from excel spreadsheet into a created table
13:19 Import data from excel spreadsheet into a new table
14:58 Create a relationship between tables (one to many)
22:56 Customize table fields in Microsoft Access
34:56 Create a form
37:05 Create a form with the form wizard
38:06 Customize the look of your form
45:47 Add a combo box to your form
49:55 Add an image to your form
51:05 Add command buttons to your form in Microsoft Access
56:16 Add a record with your form
57:30 Using Sort in your tables
58:59 Creating queries in Microsoft Access
1:03:33 Adding criteria to your query
1:07:06 How to use parameters and wildcards in your queries
1:10:50 Using the greater, less than or equal in the criteria
1:13:29 Create a report form a query
1:18:16 Export tables, forms queries, and reports

[samm]

Great thank you. Had a problem following along and linking the tables as shown but saw both need to be same former of long integer. Thanks

[belleame]

Thank you! I appreciate the knowledge provided!

[rudrapratapbasu]

Thank you so much for this deeper dive. Really appreciate it.

[sgit]

This is such a great refresher course for me - thanks so much!

[marcioalvarez]

Me gustó demasiado el video! ahora por las clases de excel 😎😎

[lonylony]

Thank you so much for this amazing course :)

[PlantBasedPietro]

Thank you for all your wonderful and informative training videos!!! Really love the Access training and looking forward to more advanced lessons. :)

[DemetriPanici]

I haven't used Access since my Information systems classes in college. Interesting video!

[annelias]

Hi Jamie - loved loved loved your videos on Access. Any chance there are any others beyond the Lesson 1 & Deep Dive? My head is spinning, but both videos were great. Also - maybe it would be helpful for viewers if you indexed each one. Like which one should be first, second, and so on. Especially if you're planning to add more to your portfolio.

[AkinAkinsanya]

Thank you so much for these videos. I haven't used access in a long time so I'm wanting to get back into it and your videos have been very helpful.