Microsoft Access 2016 Tutorial for the Workplace and Students: Part 2 of 2 for by Sali Kaceli

This is part 2 of the comprehensive Microsoft Access 2016 tutorial focusing in-depth on forms, queries and reports in a database. For more info. please visit us at learn.kaceli.com.
THE DATA FILES FOR THE TUTORIAL ARE HERE: kaceli.com/a/access2016files/
Access 2016 Tutorial Part I is available from here: • Microsoft Access 2016 ...
Access 2016 Tutorial Part 2 URL: • Microsoft Access 2016 ...
The following are covered in the tutorial:
Learn how to create forms in a database in Access 2016.
Learn how customize forms in Access 2016.
Learn how to create queries in Access 2016.
Learn how to create custom queries with criteria and calculated fields.
Learn how to create reports in Access 2016
Learn how to customize reports in Access 2016.
Here are the actual markers thanks to Moon Laura:
1:12 Creating Compound Form (a form with subform) in Access
5:09 Customizing Forms in Access 2016
9:48 Locating and Filtring Data in an Access Form
12:55 Creating Queries from multiple tables
16:06 Advanced Queries and Query Design in a database
19:44 Using multiple criteria options in a query
25:47 Creating calculated fields in a query
32:32 Creating and modifying reports in Access
49:54 Creating reports from multiple tables
55:11 Customizing reports in Access
1:00:10 Adding a new field to an existing report
If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
Keep in touch:
Website: kaceli.com
TH-cam Channel: / skaceli
COPYRIGHT NOTICE: NO PART OF THIS TUTORIAL MAY BE DOWNLOADED OR DISTRIBUTED IN ANY WAY WITHOUT PERMISSION. If you have such a need, please contact me first.

[@Nagmbeirut]

1:12 Creating Compound Form (a form with subform) in Access
5:09 Customizing Forms in Access 2016
9:48 Locating and Filtring Data in an Access Form
12:55 Creating Queries from multiple tables
16:06 Advanced Queries and Query Design in a database
19:44 Using multiple criteria options in a query
25:47 Creating calculated fields in a query
32:32 Creating and modifying reports in Access
49:54 Creating reports from multiple tables
55:11 Customizing reports in Access
1:00:10 Adding a new field to an existing report

[@KaceliTechTraining]

Thank you. I have now updated the markers giving you credit.

[@nice578]

I have an exam tomorrow. Just watched both vids. I thank you

[@ntbarnes656]

I knew nothing about Access when it came up in am interview days ago. I now feel EXTREMELY confident about what I can do because of these IN-DEPTH tutorials. Thank you so much for putting these together. I must say these were the best tutorials I have ever seen.

[@skuggi121]

Thank you. Excellent TH-cam teaching material.

[@TheAJKahn]

Thank you for the best Access tutorial I've seen. The video was well structured and edited. You taught like a teacher and built the basics before going advance. Overall A+++. I hope that this video forever stays on YT so we can always come and reference this in the future. Thank you once again!

[@lil2Man]

This is perfect for getting a grasp on Access. thanks so much.

[@TheHeadlets]

Thank you so much for this extremely instructive and helpful video series! I really needed to brush up on my MS Access skills quickly and this was perfect.

[@sanahar99]

Simple and easy to follow lesson. Quite Helpful. Thanks.

[@paodan888]

Thank you so much, I know nothing about access yesterday and now I can build a simple time sheet with access.

[@flomos.gbolumah5467]

Thank you for sample explanation of this subject.

[@deborahfiore7832]

Happy Holidays! Thank you for all your help!

[@pattayothlimpapath67]

This video is extremely helpful. Many thanks for this!!

[@crystalbrown5647]

This was a pleasant learning experience. Easy to follow, good pace and informative. You have a new follower. Thanks!

[@pusik2012]

Thank you a lot.You are an excellent teacher

[@Phgrapheyes]

Thanks for providing such an easy-to-follow tutorial.

[@erinburns-flett1509]

Excellent video! Very well paced.

[@rowlando4218]

Great and amazing teaching material, Thanks

[@silmearendil]

This was really helpful, thank you so much

[@francisdon2192]

Concise & precise !!!

[@shirleysoh6142]

You are such an angel!

[@tinaahuja2026]

Amazing tutorial!

[@TheWid]

another excellent and clear story

[@bakr.b.h5276]

Thank you very much Mr.Kaceli for your effort , that was very helpful .

[@KaceliTechTraining]

Thanks for the feedback. Glad it was helpful.

[@haqiqthaq7151]

Thank u very much that u give time for us .

[@elahezolfaghari4652]

Very helpful, thank you!

[@Nagmbeirut]

Thank you very much for teaching me how to use Access. I am using it for the first for my research project. I hope you don't mind me contacting you for any questions. :)

[@jawherammari6781]

thanks, great study material

[@elisedotcom7498]

Thanks so much. Awesome tutorial

[@sandrabard3677]

thank you for your tutorials. They really helped. Subscribing.

[@MrRamonm718]

very productive way of teaching, nice way of explaining all concepts

[@KaceliTechTraining]

Thank you.

[@kinzinger1]

Great Video Series, very informative and easy to follow

[@KaceliTechTraining]

Thank you Dustin. Glad you found the videos helpful.

[@joaocordeniz1155]

This is great!!

[@ahmedosman7313]

Amazing. Big like

[@alihaleem2705]

Amazing tutorial

[@farooqkota8692]

Thanks a lot..Very helpful..

[@avinashvijaydande5507]

Thank you Sir.

[@sallyt4060]

Thank you so much.

[@abdulrazakkhshfeh4100]

semi-experienced users can increase difficulty level by changing the playback speed to x2

[@aqibishfaq1313]

I really liked ur all videos greeting from Pakistan ❤✋😀

[@hassansantigiekamara7762]

I really enjoy your video and it highly educating, may God bless you for educate the world.

[@bujjigadu1972]

Thank you . Very helpful. Request more inputs for building queries with Excel Function criteria. Please help.

[@luckyrook1246]

Super Good!

[@rachealabiola8181]

very helpful

[@yvadadnil]

Brilliant tutorials, thank you so much! I did an Access course 9 years ago but have never used it since, and now I have an interview coming up for a job and need to have knowledge of Access. There's just one thing that has confused me. In the first video when you first showed us how to modify a Form using Design View, I'm pretty sure you said that you shouldn't change what's in the white boxes, only what's in the boxes with the spotted background. But later on when you are demonstrating how to alter the look of a form, you were altering the size and contents of the white boxes.

[@samsonmadaura7689]

Hi Linda Just to help...altering the size and changing content are 2 different actions

[@yvadadnil]

@@samsonmadaura7689 Thanks! It made sense actually when I went back and looked again.

[@wongfookkeong3919]

So Power full Tutorial

[@jdurk]

Watch on 1.25x speed if it's too slow

[@eliel_fada]

Great Great teacher, bravooo.please is the part 3 on youtube?

[@cruzerbagercruzerbager2965]

Settings < Playback speed = 1.25
Much better experience

[@forensicsman320]

Can you demonstrate how to make a row change colors depending on a change in a condition? like your inventory of an item is now zero. Thank you.

[@antonyokundi9466]

Parfait!

[@siopiwai.makerbwiz]

thanks too much

[@Chirikoton]

gracias

[@amanullahstanikzai8085]

Nice one

[@davidjhernandez3052]

Awesome videos, part 1 and part. I am already rolling with my dB. But I have a question: Why on minute 1:59 of this video the "Form with Subform" radio button is not available in mu Access 2016?. That image in minute 1:59 is not available in my Access 2016.

[@khansvirtualdiary]

were looking 4 it

[@flomos.gbolumah5467]

Could I get the excel table to export to access to practice?

[@jacobtambadavidmoundekeno6515]

Thanks you very much this tutorial Microsoft access.
but can you help me to know how to create website or link me to any other person?

[@alikamel7881]

how to make the form like an application when opened ?

[@siddharthmehta2536]

👍👍👍👍👍

[@abdulnasir7889]

Hello haiii.. how are you..?
How to create pdf hyperlinks..?

[@lizq2205]

Thank you for sharing. I have problem following your instructions. My Access 2016 returned error when I multiply [invoiceamt] with .05. I think it's because the variable [invoiceamt] is text with "$" included. I tried to change the property into number. However, after that, all the numbers disappeared. Moreover, the invoice date data went blank when I import the invoice txt into the Access. How can I solve this problem?

[@jasonbrassett8130]

Try using the val() function

[@Zomeone]

My biggest obstacle is this table i cant understand it its rough
I need more simplified one

[@grkantrker]

thank you so much. :ok_hand:

[@m.mabeba1972]

Hello Sir. In my hometown it's really hard to get access to Internet, that's means that i have to go in the cyber net to get access to Internet. Can i please download this tutorial So that i Can study by my own. Please.

[@laminulams8723]

I need to download this tutorial because I may not have assess to internet at any time , so it is occasional can I download pls?

[@Nailey13]

If you have a smartphone, you can download the video directly to your device for use offline.

[@laminulams8723]

@@Nailey13 Thanks for your kindness

[@robh9184]

the >=10000 isn't working for me.. The result is no data in my table. Any hints?

[@KaceliTechTraining]

Are you sure you are applying the criteria to the right column and also have values in that column that are equal or greater than 10k?

[@robh9184]

Thanks for the reply. I managed to get it working. had the 'Invoice Amt' column as a short text data type. I changed this to a 'Currency' data type. It then worked. Great Tutorial!

[@FubaraDmitryHart]

Pls Is the Part1 on TH-cam

[@AmishWebmaster]

th-cam.com/video/1IA4SeajZRw/w-d-xo.html

[@baphnie]

I just don't understand why we need separate software for all this... why can't Excel just do these things?

[@forensicsman320]

Excel is not a database. It just saves information into a file. Access lets you store unlimited data and then parse it however you want like he is demonstrating in the video.

[@anuwejohnbosco5495]

please I'm I the only one watching a blurred video

[@KaceliTechTraining]

Try changing the quality settings. It was recorded in 720p.

[@MMchannels]

very helpful

[@Modhumitamondal]

very helpful