Access 2007: Queries
Access 2007: Queries
MP4 | Video: 540p | Duration: 2:08:44 | English | Subtitles: VTT | 221.3 MB
MP4 | Video: 540p | Duration: 2:08:44 | English | Subtitles: VTT | 221.3 MB
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