This event has ended

# Creating Solutions with Excel and Access 2007

## Birmingham, AL

### Ticket Information

 Ticket Type Sales End Price Fee Quantity Creating Solutions with Excel and Access 2007 Ended \$675.00 \$0.00

Share Creating Solutions with Excel and Access 2007

# creating solutions with Excel and access 2007

### Course Description

The course introduces you to building solutions using the power of Excel 2010 and Access 2010 together to streamline processes.

### COURSE OBJECTIVES

Upon completion of this course, the student will be able to:

·        Perform calculations.

·        Calculate and analyze data.

·        Sort and filter data.

·        Create, run, and edit macros.

·        Create queries.

·        Generate reports.

#### Lesson 1 – Working with Data Analysis

·        What If Analysis?

·        Scenarios

·        Goal Seek

#### Lesson 2 – Calculating Data with Advanced Formulas

·        Basic Formulas

·        Built In Functions

·        Copy Formulas and Functions

·        Date Functions

·        Text Functions

·        Vlookup

·        Absolute/Relative Referencing

·        IF Function

·        ISNA Function

·        Remove Duplicates

#### Lesson 3 – Sort and Filter Data

·        Sort Data

·        Filter Data

·        Clear Filters

·        Subtotal Data

·        Expand and Collapse Subtotals

#### Lesson 4 – Streamlining Workflow

·        Set the Default Options for Excel

·        Data Validation

·        Create a drop down from a list

·        Work with Conditional Formats

·        Control Conditional Formats by Managing the Rules

·        Create a Macro

·        Edit a Macro

·        Adjust Macro Settings

·        Hide the results of macros while it runs

#### Lesson 5 – Querying a Database

·        Create a Query

·        Add Criteria to a Query

·        Filter Records

·        Add a Calculated Field to a Query

#### Lesson 6 – Joining Tables

·        Relate Data within a Table

·        Join Unrelated Tables

#### Lesson 7 – Creating Flexible Queries

·        Set Select Query Properties

·        Create Parameter Queries

·        Create Append Queries

·        Create Update Queries

#### Lesson 8 – Writing Advanced Queries

·        Create Subqueries

·        Create Duplicate Queries and Unmatched Queries

#### Lesson 9 – 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

#### Lesson 10 – Simplifying Tasks with Macros

·        Create a Macro with the Command Button Wizard

·        Create a Macro from Scratch

·        Attach a Macro

Have questions about Creating Solutions with Excel and Access 2007? Contact ThinkData Solutions, Inc

## Thursday, April 26, 2012 at 9:00 AM - Friday, April 27, 2012 at 4:00 PM (CDT)

Add to my calendar