Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 4.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Microsoft Access

SQL for Microsoft Access 2007 to 2016

Learn how to write SQL code in Microsoft Access, so you can create more advanced Access queries
Rating: 4.6 out of 54.6 (134 ratings)
716 students
Created by Phillip Burton
Last updated 10/2020
English
English [Auto]
30-Day Money-Back Guarantee

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.
Curated for the Udemy for Business collection

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.

Featured review

FeltonLovett Sr.
FeltonLovett Sr.
8 courses
3 reviews
Rating: 5.0 out of 5a year ago
I am very satisfied with what I've learned in this course. I've been using access for about 2 years and the things that I have learned will go a long way to making my and my co-workers job so much easier.

Course content

8 sections • 43 lectures • 4h 26m total length

  • Preview01:58
  • Welcome to Udemy
    00:35
  • Introduction to Udemy
    02:00
  • Preview05:39
  • Preview05:01

  • A basic SELECT statement, using the SELECT and FROM clauses
    10:07
  • Adding a WHERE clause
    10:24
  • Summarising data with a GROUP BY clause
    09:05
  • Adding a HAVING clause
    07:48
  • Adding some order - using the ORDER BY clause
    08:32

  • GROUP BY - Adding Aggregating functions
    04:31
  • Using Aliases
    08:34
  • Using WHERE on Text fields
    06:20
  • Using WHERE on NULLs
    05:47
  • Using WHERE on Date fields
    08:23
  • Date/Time Functions
    05:53
  • Maths and Text Functions
    03:40
  • Conditional functions
    07:11

  • Where can you use SQL statements?
    07:59
  • Adding a second table
    09:05
  • Different types of JOINs
    06:56
  • Writing a JOIN query
    05:58
  • Inequality Joins
    09:26
  • Adding a third table
    07:01
  • Do I need complicated JOINs - subforms and subreports
    08:41

  • Missing data
    06:16
  • Creating a Make Table query
    05:01
  • Inserting data
    05:00
  • Deleting data
    05:22
  • Updating data
    12:20

  • Adding DISTINCT into the SELECT clause
    03:08
  • Adding TOP into the SELECT clause
    03:23
  • Adding derived tables in the FROM clause
    04:57
  • Adding subqueries in the WHERE clause
    03:08
  • Adding correlated queries
    06:08
  • Creating a cross-query
    07:23
  • Adding parameters
    12:57
  • UNION and UNION ALL
    06:10
  • What is a Data Definition query?
    02:01

  • Importing or Linking data - Tables
    08:32
  • Creating a Pass-Through query
    03:47

  • Bonus Lecture
    02:55
  • Thank you for joining me on this course
    01:18

Instructor

Phillip Burton
Best Selling Instructor - over 250,000 students so far
Phillip Burton
  • 4.5 Instructor Rating
  • 39,553 Reviews
  • 280,734 Students
  • 43 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.