SQL for Microsoft Access
What you'll learn
- Know all 6 clauses of the SELECT statement, and in which order.
- Add functions and formulas into your code.
- Do basic and advanced JOINs, some of which cannot be done in the graphical interface.
- Create UNION queries, which also cannot be done in the graphical interface.
Requirements
- You need to know how to use a computer, and hopefully know how to use a spreadsheet.
- You need to know the basics of how to use Microsoft Access.
- You should have MS Access 2007, 2010, 2013, 2016 or 365 installed on your computer.
Description
Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?
What do people just like you think of this course?
"This is an excellent course, very well organized, structured, explained and paced. In addition, the course is content rich, provides a very good context and helpful tips! This is exactly what I was looking for. Thank you very much!" - Dmitry Tlusten
"I am a 51 year old complete beginner and just wanted to learn access to create my own database for a side business. I first took an MS Access course and then this SQL for Access course which allowed me to understand access better and to add some useful functionality to my database. Really enjoyed it, felt like a great introduction to SQL." - Mark Nugent
"If I were to name single biggest advantage of this course I would say that it is very logically structured. In my opinion essential to master any subject. Before the course I had some vague idea of SQL, but after it I feel quite solid." - Bartomiej Kurzeja
In this course learn how to:
Write SQL code, using the six SELECT clauses.
Use functions and formulas in your SELECT statements.
Create joins between tables, including more complex joins which cannot be evaluated using the graphical interface.
Write action queries and cross-queries.
Using derived tables in the FROM clause, and subqueries in the WHERE clause.
Creating correlated queries and cross-queries.
Using UNION and UNION ALL, and
Importing or Linking data and creating Pass-Through queries from other databases.
Hopefully, by the end of this course, you will also feel "quite solid" in Access SQL, and be able to use the extra functionality allowed only when using Access SQL to build even better databases.
Who this course is for:
- This course is for you if you want to develop your Microsoft Access skills by learning how to code SQL queries.
- This course is for you if you want to create more advanced queries in Access.
- This course will use the latest version of Access, but is ideal for you if you use any modern version - Access 2007, 2010, 2013, 2016 or 365.
- This course is also for you if you use an older version of Microsoft Access, but want to learn the newer versions.
Featured review
Instructors
- 4.6 Instructor Rating
- 110,142 Reviews
- 684,017 Students
- 50 Courses
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 630,000 students and more than 40 video courses, including over a dozen Bestseller courses.
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
- 4.6 Instructor Rating
- 92,828 Reviews
- 674,080 Students
- 39 Courses
I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.
Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.
Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.
For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies.
That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job.
I Do Data courses are dedicated to enabling you to succeed.