You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications. Lesson 1: Querying a Database
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Lesson 2: Joining Tables
- Create Query Joins
- Join Unrelated Tables
- Relate Data within a Table
Lesson 3: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter QueriesCreate Action Queries
Lesson 4: Structuring Existing Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
Lesson 5: Writing Advanced Queries
- Create Subqueries
- Create Unmatched and Duplicate Queries
- Group and Summarize Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
|
