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
|
專業軟體光碟
