In Access 2010: Queries in Depth author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw
data into usable information. The course covers setting up queries performing calculations using the built-in Access
functions to further refine query results and identifying top performers or areas for improvement based on a range of
criteria. Exercise files are included with the course.
Topics include:
* Naming conventions and best practices
* Working with joins
* Using comparison operators
* Defining criteria for select queries
* Creating parameter queries
* Creating calculated fields
* Working with dates and times
* Using the Expression Builder
* Creating conditional statements
* Making deleting and appending records
* Building reports