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
- author
- Adam Wilbert
- subject
- Business, Databases, Office Suites
- software
- Access 2010, Office 2010
- level
- Intermediate
- duration
- 3h 2m
- released
- Jun 16, 2011
viewed
duration
Suggested courses to watch next:
