Introduction to queries
Create a simple select query
Join tables and queries
Examples of query criteria
Apply criteria to text values
Use Like criterion to locate data
Use the OR criteria to query on alternate or multiple conditions
Examples of wildcard characters
Compare two tables and find only matching data
Find duplicate records with a query
Use a parameter to make a query ask for input
Examples of using dates as criteria in Access queries
Date criteria doesn't work in my query
Add to or subtract from date and time values
Create and run an update query
Create and run a delete query
Delete duplicate records with a query
What do I do if I get an error message about not being able to delete from the specified tables?
Sum data by using a query
Count data by using a query
Create a make table query
Add records to a table by using an append query
Common errors when you run an append query
Use a union query to combine multiple queries into a single result
Edit SQL statements to sharpen query results
Access SQL: basic concepts, vocabulary, and syntax
Access SQL: WHERE clause
Access SQL: SELECT clause
GROUP BY Clause
ORDER BY Clause
ALL, DISTINCT, DISTINCTROW, TOP Predicates
