Sub Queries ,JOINS & Functions – Chapter 2

4.00 out of 5
(1 customer review)


Chapter2 – Queries



  • 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

1 review for Sub Queries ,JOINS & Functions – Chapter 2

  1. 4 out of 5


Add a review