Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access 2007: Queries

via LinkedIn Learning

Overview

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.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
  • Reviewing the Access interface
1. Creating Queries in Access
  • Query basics
  • Naming conventions and best practices
  • Using the Query Wizard
  • Exploring the Query By Example (QBE) interface
2. Creating Simple Select Queries
  • Defining a single criterion
  • Comparison operators
  • Defining the column headers with aliases
  • Exploring the field properties
  • Understanding query level properties
  • Working with joins and primary keys
  • Printing query results
3. Creating Parameter Queries
  • Understanding parameter queries
  • Obtaining parameters from other Access objects
4. Creating Calculated Fields
  • Using Totals to calculate values
  • Introducing mathematical operators
  • Using mathematical operators
  • Using text
5. Using the Expression Builder
  • The Expression Builder interface
  • Exploring some built-in functions
6. Working with Dates in Queries
  • Understanding dates as serial numbers
  • Specifying a range of dates or times
  • Using the Format function
  • Using other Date/Time functions
  • Defining today's date
  • Working with time intervals
  • Using the DateDiff function
7. Understanding Conditional Statements
  • Introduction to the conditional IIf function
  • Creating an IIf function with the Expression Builder
  • Using the Switch function
8. Using Alternate Query Types
  • Using crosstab queries
  • Finding duplicate queries
  • Finding unmatched queries
  • Working with action queries and backups
  • Updating queries
  • Making tables and appending queries
  • Deleting queries
Conclusion
  • Goodbye

Taught by

Adam Wilbert

Reviews

Start your review of Access 2007: Queries

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.