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

Expected Outcomes

  1. 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.