In Access 2007: 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 and primary keys
* Using comparison operators
* Printing query results
* Creating parameter queries
* Creating calculated fields
* Using the Expression Builder
* Making conditional statements
* Appending queries
* Updating queries
Download File Size:165.49 MB