# MS Access - Sub Queries JOINS Functions Series2

• Course provided by Udemy
• Study type: Online
• Starts: Anytime
• Price: See latest price on Udemy

## Course Description

• This course talks about different types of Joins like inner, left, right,outer or full

• we talk about live situations and how to deal with them using joins or sub queries

• we talk about use of IIF function in access query

• how to use IIF in IFF which is called nested IFF function

• Deal with all date functions like dateserial, date,month,year,dateadd,datediff etc

• how we can use text functions , upper, lower functions. MID LEFT RIGHT

• how as a beginner we use the access query zoom option and wizard to find out the functions if they exist or not

• how to use functions using wizard and what are the things one should keep in mind while using them

## Who this course is for:

• Students who want to learn more about queries and also need to learn functions with the help of which they can easily carry out their day to day access related work

## Course content

1 section • 12 lectures • 4h 30m total length
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part1
54:48
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part2
26:43
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part3
47:55
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part5
24:27
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part6
35:05
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part7
08:07
• Introduction to JOINS /SUB QUERIES AND FUNCTIONS - Part8
08:41
• Introduction to JOINS SUB QUERIES AND FUNCTIONS
18:06
• Student Questions - Let us see
20:24

## Instructor

Instructor - Advance Excel, Excel Vba ,Access, Access Vba
• 4.5 Instructor Rating
• 533 Reviews
• 2,289 Students
• 45 Courses

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.