MS Access - Sub Queries JOINS Functions Series2

MS Access - Sub Queries JOINS Functions Series2

• 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

  
  

JOINS & FUNCTIONS -in depth discussion

Url: View Details

What you will learn

• You will be able to implement all queries and functions learnt in this course in your office and can ease a lot of pressure which comes from manual work.

Rating: 4.25

Level: All Levels

Duration: 4.5 hours

Instructor: ajay parmar