SQL for Microsoft Access

Learn how the where clause filters records by conditions, using operators like greater than, less than, between, not equal, and brackets to resolve ambiguity; understand semicolon usage and readability.

Explore aggregations in Microsoft Access by using group by for non-aggregate fields, and apply sum, count, min, max, and average with the expression builder to name results.

Filter text fields with the where clause in Access using literal strings, brackets, and not equal; use left, right, and like with wildcards to match starts, ends, or contains letters.

Explore how nulls behave in Microsoft Access SQL, learn to use is null and is not null to find or exclude unknown values, and distinguish null from empty strings.

Explore text and math functions in SQL for Microsoft Access, including left, right, mid, trim, ltrim, case conversion, rounding, and financial functions in select and where clauses.

Explore how inner, left, right, and outer joins combine customers and orders in Microsoft Access, compute zero orders with counts, and why cross joins are rarely used.

Learn to extend an Access SQL query to three tables by joining orders with customers and employees, using brackets to separate joins and aliases to disambiguate fields.

Filter customers by the three least used job titles with a subquery in the where clause, or use a derived table; both approaches produce the same result in Access SQL.

Learn to create a cross-tab pivot in SQL for Access by transforming the month of order date into columns, grouping by employee, and counting orders as values.

Explore how to link Microsoft Access to an external data source like SQL Server, choosing between import and link, and importing the Person.Address table from AdventureWorks.

Learn to write sql in microsoft access using the six clauses of the select statement—select, from, where, group by, having, and order by— and apply joins, including inequality joins.