Getting to Know Microsoft Access, Part 6: Advanced Queries and SQL

This week we’re going to take queries to another level. We discussed the commonly used select query in last week’s tutorial. This week we’ll discuss some other ways to retrieve data as well as other query operations that allow for updating, adding, and deleting data. We’ll start this lesson with a look at some special purpose queries: parameter and autolookup queries. After that we’ll discuss the action queries update, append, make-table, and delete.


Read the full article here: Getting to Know Microsoft Access, Part 6: Advanced Queries and SQL

For more discussion go here: Blog Article Discussion