| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Access 2007: Queries (Half-Day) |
| Course Number: APH0002 |
| Category: Business & Office Applications |
| Duration: 0.50 days |
Description
This half-day class builds on the skills and concepts taught in the Access 2007: Introduction class. Participants will learn how to create basic, join, crosstab, parameter, and action queries.
Outline
- Unit 1: Basic queries
- Topic A: Creating and using queries
- A-1: Planning a query
- A-2: Using the Query Wizard
- A-3: Creating a query in Design view
- A-4: Saving and running the query
- A-5: Sorting query results
- A-6: Filtering a query by adding criteria
- A-7: Creating a query from a filter
- Topic B: Modifying query results and queries
- B-1: Editing query results
- B-2: Adding fields to a query
- B-3: Finding records with empty fields
- Topic C: Performing operations in queries
- C-1: Using comparison operators
- C-2: Using the OR condition
- C-3: Using the AND condition
- C-4: Using the * wildcard
- C-5: Using calculations in a query
- C-6: Totaling a group of records
- C-7: Using the Avg and Count functions
- C-8: Using the Min and Max functions
- Topic A: Creating and using queries
- Unit 2: Complex queries
- Topic A: Joining tables in queries
- A-1: Creating a query using the Simple Query Wizard
- A-2: Creating a join in Design view
- A-3: Creating an outer join
- A-4: Creating a join with an intermediate table
- A-5: Creating a self-join query
- A-6: Finding records that do not match between tables
- A-7: Finding duplicate records
- A-8: Deleting tables from a query
- Topic B: Calculated fields
- B-1: Creating a calculated field
- B-2: Modifying the format of a displayed value
- B-3: Using the Expression Builder
- Topic C: Summarizing and grouping values
- C-1: Creating a query to display summary values
- C-2: Using queries to concatenate values
- Topic A: Joining tables in queries
- Unit 3: Advanced queries
- Topic A: Creating crosstab queries
- A-1: Viewing a crosstab query
- A-2: Using the Crosstab Query Wizard
- Topic B: Creating parameter queries
- B-1: Creating a single-criterion parameter query
- B-2: Creating a query with multiple parameters
- B-3: Using a wildcard in a parameter query
- Topic C: Using action queries
- C-1: Adding records to a table with an append query
- C-2: Deleting records with a delete query
- C-3: Modifying records with an update query
- C-4: Creating a Make Table query
- Topic A: Creating crosstab queries