MS Access – Sub Queries JOINS Functions Series2

JOINS & FUNCTIONS -in depth discussion

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

What you’ll 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..

Course Content

  • Introduction to JOINS /SUB QUERIES AND FUNCTIONS –> 12 lectures • 4hr 30min.

MS Access - Sub Queries JOINS Functions Series2

Requirements

  • Knowledge to MS Access Table and Queries like select, update, delte , update is must for a student.
  • 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