Access 2007: Queries in Depth

Creating and leveraging real-world queries and turning raw data into usable information.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