SQL for Microsoft Access 2007 to 2016
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?
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.
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.
Course content
- Preview01:58
- 00:35Welcome to Udemy
- 02:00Introduction to Udemy
- Preview05:39
- Preview05:01
Instructor
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.