Access 2007

Writing Advanced Queries

-Create Subqueries

-Create Unmatched Queries

-Duplicate Queries

-Group and Summarize Records

  Using Criteria

-Summarize Data Using a Crosstab

  Query

-Create a PivotTable and a PivotChart

Querying a Database

-Filter Records

-Create a Query

-Add Criteria to a Query

-Add a Calculated Field to a Query

-Perform Calculations on a Record

  Grouping

Joining Tables 

-Create Query Joins

-Relate Data within a Table

-Join Unrelated Tables

-Work with multiple worksheets

  through joins

Creating Flexible Queries 

-Set Select Query Properties

-Create Append Queries

-Create Parameter Queries

-Create Update Queries

Generating Reports

-View an Access Report

-Create a Report

-Format the Controls in a Report

-Add a Custom Calculated Field

  to a Report

-Apply an AutoFormat to a Report

-Prepare a Report for Print

Simplifying Tasks with Macros 

-Create a Macro

-Restrict Records Using a Condition

-Attach a Macro

-Validate Data Using a Macro

-Automate Data Entry Using a Macro

Excel 2007

Calculating Data with Advanced Formulas

-Perform Logical Analysis

-Perform Date and Time

  Calculations

-Calculate Data with Lookup &

  Reference Functions

-Perform Numeric Calculations

Sorting and Filtering Data

-Calculate Large Volumes

  of Data

-Sort Data in a Spreadsheet

-Filter Data in a Spreadsheet

-Add Subtotals to a Worksheet

Streamlining Workflow

-Update Workbook Properties

-Add Data Validation Criteria

-Apply Conditional Formatting

-Modify Excel's Default Settings

-Create a Macro

-Edit a Macro