SQL in Microsoft Access: Day 2

Service Description

SQL in Microsoft Access: Day 2 builds on the SQL fundamentals introduced in Day 1 and takes participants deeper into writing powerful, flexible queries in Microsoft Access. In this hands-on course, participants will move beyond basic SELECT queries to work with multiple tables, more complex criteria, advanced query techniques, and SQL statements used to solve real-world database challenges. Participants will learn how to combine and manipulate data more effectively while gaining a better understanding of how Access processes SQL. Through practical exercises, participants will write, modify, troubleshoot, and analyze SQL statements while building the skills needed to create more sophisticated Access database solutions. Topics include: Reviewing and building on Day 1 SQL concepts Working with multiple tables Understanding INNER JOIN, LEFT JOIN, and RIGHT JOIN Creating and troubleshooting JOIN conditions Using nested and more complex criteria Creating subqueries Working with advanced aggregate queries Combining results with UNION queries Creating parameter queries with SQL Using SELECT DISTINCT Working with action queries Creating UPDATE queries Creating APPEND queries Creating DELETE and MAKE TABLE queries Using SQL to solve real-world database problems Reading and troubleshooting more complex SQL statements Best practices for creating clear, maintainable queries Who should attend: Microsoft Access users who have completed SQL in Microsoft Access: Day 1 or have equivalent experience writing SELECT queries, applying criteria, creating calculated fields, and using aggregate functions. Level: Intermediate SQL / Intermediate to Advanced Microsoft Access Duration: 4.5 hours — Day 2 of a 2-day, 9-hour course Format: Live, instructor-led online training