|
Title: Using Access and Excel to Analyze Data
Date: June 8-9, 2010
Time: 8:30am - 4:30pm
Instructor: Gary Cloud
Location:
The course is being held in the City of Austin's Small Business Development
Program computer lab located at 505 Barton Springs Road in the One Texas Center
building in Austin, Texas. You can get a map to this building by accessing:
City of Austin's SBDP Computer Lab
Price: $425
Early Bird Discount: $399 if you register by May 8, 2010.
Software Version: This class is taught on Microsoft 2003 Excel and Access software. Our instructor is able to provide some in-class instruction for Microsoft 2007 users.
Course Description: Many data analysts use both Access and Excel to analyze data. Both Access and Excel are powerful programs. But do you know which tool is better for your specific task? Take this two-day information-packed course to learn to use Excel's "flat" database features and Access' "relational" database features in a meaningful way. Learn to Sort, Filter and Query large amounts of data.
Prerequisite Skills Necessary for Class: Participants must understand the basic concepts of Access including how to open a database and look at the basics of tables. Participants will also need to know Excel basics including how to build a basic function (such as sum or multiple) and also use Excel on a regular basis.
What to Expect: After this class participants will be able to use Access and Excel to manage and analyze large amounts of data.
What NOT to Expect: This class in not designed to teach you how to build a database to track data. The purpose of this class is to focus on Queries and Data Analysis. Participants will learn how to import data or to manage existing data.
Course Outline:
Excel's Database Features
Sorting
Custom Sorts
Subtotals
Filtering
Pivot Tables
Access Table Basics
Navigate Views
Understanding Data Types
Understand Relationships
Importing & Exporting
Importing Excel Files
Importing Delimited Files
Importing Other Access Tables
Exporting to Excel
Exporting to Other File Types
Basic Access Queries
Writing Select Queries
Using Wildcards
Writing And/Or statements
Calculating in a Query
Using Aggregate and Other Functions
Using Variables in Parameter Queries
Intermediate Queries
Understand Inner and Outer Joins
Build Action Queries - Update, Delete, Make Table & Append
Write Cross-Table Queries
Find and Delete Duplicates
SQL Basics
Writing Union Queries
Create Random Samples
Reports
Build a Basic Report Using a Table or a Query
Summarize and Calculate in Reports
Modify Reports
Instructor Bio:
Gary Cloud
Gary Cloud with Cloud Training Services has been teaching computer classes since 1996. He trains on a variety of computer software products-both industry-specific and off-the-shelf. However, a major focus of his training has been on training Microsoft Office products such as Word, Excel, PowerPoint, Access and Outlook. During his years of training he has worked with a variety of industries, including banking. utility, medical, local and state government and higher education.
Gary holds a B.A. from Texas Wesleyan University and a M.A.M. from Wayland Baptist University.
CPE: 16 hours
Level: Intermediate
Type of Class: Computer
TX Board of Public Accountancy Sponsor Number: 009317
Cancellation Information: Cancellation Date: May 18, 2010
To cancel your registration from this course, please call or email the course contact listed below.
Please Note our Cancellation Policy for Computer Classes: If a cancellation is received after the cancellation
date, the registrant may send a replacement, or be charged in full. A set of course materials will be sent to the registrant.
Class participants will
be billed after the class. Payment should be made to SOLUTIONS TRAINING GROUP,
Federal Tax ID: 20-2732184 and mailed to 2701 Maria Anna Rd, Austin, TX 78703.
If you have any questions, please contact Shannon Bieberdorf at (512) 914-5557
shannon@solutionstraininggroup.com. For
additional information about this class, please contact Laurie Garrant at laurie@solutionstraininggroup.com,
(512) 914-5567.
|
