Access 2010 Training

Learn How To Create and Use Forms, Utilize Queries to Retrieve Data, Perform Calculations Using Expressions and Functions, Create PivotCharts and PivotTables, Run Reports and Much More!

This Course Includes All of the Following:

Instant Online Access Begin Streaming Your Training Immediately
Physical Media Shipped Directly to Your Doorstep For Free, Worldwide

Certified Instruction:

Heather AckmannMicrosoft MVP, MCT, MOS Master 2010, MOS Master 2003

$97
Paying with Purchase Order?
View Outline
Our Total Experience Guarantee is Very Simple

If you are not satisfied with our training, our service, or our support FOR ANY REASON, return your course within 90 days for a FULL REFUND (up to $397). You have my word.

Scott Skinger Founder & President of TrainSignal, Inc.

Overview

Mobile On-Demand Training Train Where You Want, When You Want
Additional Training Formats High Resolution Video, MP3 Audio and PDF of Instructor Notes
Watch a Demo

Plus, Discover the New Features of Access 2010!

Professional Training

Nearly 12 Hours (11 Hours, 42 Minutes, 34 Seconds) of Access 2010 Training Videos Jam Packed on 3 DVDs!
Multiple File Formats Make it convenient for you to learn anywhere you go! iPod Video, Mp3 Audio, .WMV & high quality .AVI video
PDF of Instructor Notes allow you to follow along with the videos and take more organized notes
Instant Access Online to the entire training course

Course Outline

Access 2010 Training - Course Outline

Lesson 01 - Getting Started with Access 2010 Training

Introduction to the Course
About the Instructor
Tour of the Course

Lesson 02 - Lab Setup

Access 2010 Database Specifications
Minimum Requirements for Access 2010
Exercise Files

Lesson 03 - Introduction to Databases and Normalization

Introduction to Relational Databases
Flat–File Databases
Relational Databases
Introduction to Normalization
Normalization Example
Denormalization
Designing Database Guidelines
Normalization Example
Trivia Time

Lesson 04 - Overview of Microsoft Access 2010 Objects

Database Objects
Queries
Forms
Reports
Macros
Modules

Lesson 05 - Tour of Microsoft Access 2010

Starting Microsoft Access 2010
Creating a New File
Creating a New Table
Saving a Database
Opening a Database
Trusting a File
The Quick Access Toolbar
Backstage View
Access Options Overview
The Ribbon
Contextual Tabs
The Navigation Pane

Lesson 06 - Understanding Object Views

Introduction to Microsoft Access Object Views
Table Views
Query Views
Form Views
Report Views

Lesson 07 - Navigating Microsoft Access 2010 Database Objects

Navigating a Table of Query
Keyboard Shortcuts
Navigating a Form
Navigating a Report

Lesson 08 - Creating Simple Forms

Creating a Single Item Form
Automatic Subdatasheet Creation
Creating a Multiple Items Form
Creating a Split Form
The Form Wizard
Creating a Navigation Form

Lesson 09 - Form Formatting Basics

Introduction to Controls
Resizing Controls
Moving Controls
Working with Layouts
Adjusting the Tab Order
Applying Themes

Lesson 10 - Introduction to Queries

Kinds of Queries
Creating a Select Query Using the Simple Query Wizard
Creating a Select Query from Design View
Working with Fields
Sorting and Filtering Records

Lesson 11 - Finding Specific Data Using Criteria, Operators, and Wildcards

Introduction to Criteria
Introduction to Operators
Adding Criteria to a Query
Combining Criteria
Adding Alternate Criteria
Locating Blank Values (Nulls)
Introduction to Wildcards

Lesson 12 - Creating Parameter Queries

Introduction to Parameter Queries
Creating a Parameter Query
Changing the Parameter Prompt Order
Using Wildcards and Functions with Parameter Queries

Lesson 13 - Understanding Joins

Introduction to Joins
Types of Joins
Creating an Inner Join
Creating an Outer Join
Creating a Self–Join

Lesson 14 - Creating Calculated Expressions

Introduction to Expressions
Creating a Calculated Detail Field
Building Expressions Using the Expression Builder
Building Expressions in Forms and Reports

Lesson 15 - Summarizing Data

Introduction to Aggregate Queries
Calculating a Group of Query Records
Calculating a Group of Query Records From Datasheet View
Calculating a Group of Query Records From Design View
Grouping with Criteria and Calculated Fields
Pitfalls of Summarizing Data

Lesson 16 - Introduction to Built-in Functions

Introduction to Functions
Basic Date/Time Functions
The Month Function
The Year Function
Text Functions
The LCase and UCase Functions
The Left and Right Functions
The Trim Function
The Format Function
Conversion & Math Functions
The FormatCurrency Function
The CCur Function
The Round Function

Lesson 17 - Advanced Functions

Advanced Date/Time Functions
The DatePart Function
The DateAdd Function
The DateDiff Function
The Sum Function
The Max & Min Function
The DMax & DMin Functions
The DLookup Function
Handling Null Values & Program Flow
The Nz Function
The IIf Function
The Switch Function
Using Functions in Macros
Nesting Functions

Lesson 18 - Creating PivotTables

Introduction to PivotTables
Creating a PivotTable
Creating a Calculated Field
Manipulating a PivotTable
Exporting Data to Microsoft Excel

Lesson 19 - Creating PivotCharts

Introduction to PivotCharts
Creating a PivotChart
Manipulating a PivotChart
Changing Chart Types

Lesson 20 - Creating Reports

Creating a Report Using the Report Tool
Creating a Report Using the Report Wizard
Creating a Report from Design View
Creating Mailing Labels

Lesson 21 - Basic Report Formatting

Formatting Basics
Controls
Control Layouts
Sections and Grouping
Adding Controls & Page Elements
Labels
Text Boxes
Pictures
Page Numbers
Date/Time
Borders & Rectangles

Lesson 22 - Advanced Report Formatting

Advanced Format Properties
Filtering Reports
Conditional Formatting
Creating Data Bars
Adding a Chart

Lesson 23 - Printing and Exporting Reports

Previewing a Report
Printing a Report
Exporting a Report

Lesson 24 - Next Steps

Certified Instruction

Heather Ackmann (Microsoft MVP, MCT, MOS Master 2010, MOS Master 2003)

Heather Ackmann is an accomplished instructor with a decade of teaching experience, helping students at the high school, college, and adult levels in a variety of topics. Specializing in Microsoft Office computer applications, she is a Microsoft Office Specialist Master and holds a degree in English and Secondary Education.

While her energetic and easy-to-follow style is ideal for beginners to computer applications, her knowledge, thoroughness, and foresight will satisfy the more proficient user.

She is honored to have been recently awarded the Microsoft MVP Award for the Office System.

Courses Instructed by Heather Ackmann

FAQ

Access 2010 Training - FAQ

Can I Take This Access 2010 Training Course?: YES! Whether you’re a total beginner to database design or Access 2010, or even if you are self-taught, this course will fill in the gaps and provide you the most thorough Access 2010 training anywhere!
YES! If you are familiar with the other Office applications (i.e. Word and Excel) and have a basic understanding of data entry, this course will get you up to speed and make you a bonafide Access 2010 expert!

Order Access 2010 Training Now!

$97

"TrainSignal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well...": I just wanted to send in my thanks. It’s really nice to have a product out there for net admins that really delivers.

Everyone else seems to brag about how you can use their products to pass a test. I've taken and passed several tests, and few contained the content I need on a day-to-day basis.

TrainSignal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well. I bought your product at my previous employer and will buy it for my current employer as funds become available.

Though your product is amazing, I would like to make one request that I feel would complete the package. Most admins are clueless when it comes to scripting.

Everyone seems to have tons of advanced scripting, but just like everything else, there are little to no explanations for the beginner. Could you please consider adding something in that area to your training? Keep up the good work.

Thanks
David Morehead www.wcsmiami.org
"...the best paying job of my IT career. Your videos had a big part in that...": I wanted to let you know I was asked today (3/16/2007) to provide references for a Network Engineer position at a large world-wide law firm. Providing references is typically the last step before an offer. This potentially could be the best paying job of my IT career. Your videos had a big part in that.

I have two and half years experience with Active Directory and Exchange 2003, but your videos showed me just what I needed to pass their skills assessment test. The price was well worth it.
Bill Boyd
"You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand...": I just wanted to let you know I have been very impressed with the orders we have placed with you.

Last year we bought the Microsoft Server Complete Library. It is one of the best I have seen.

You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand.

I have attended many training classes where I was getting good information but because of the way it was taught I had to force myself to pay attention and in some cases just try not to fall asleep.

These videos are just the opposite. If I am not careful I will sit up too late watching them. Well, we just received our most recent order. This time we decided to order all of your VMWare Videos. If they are as good as your other work then I know I'm going to be happy.

Thanks for the help and keep up the good work.
Del Bullion VDI Communications, Inc.
"I will recommend TrainSignal to all of my tech buddies...": I wanted to write and express my great satisfaction with the Exchange Server 2003 for SophiesToyBox.com. I am very impressed with the course. I felt as though I was actually performing the tasks during the course.

Scott was great at explaining things and even going through the quirks that would surely happen during an install. I am very pleased with the material and plan to be back to purchase more. Great job. I will recommend TrainSignal to all of my tech buddies.
William R. Cunningham (Reggie) Systems Administrator, Institute for Safe Medication Practiceswww.ismp.org
"I am on my way to becoming an MCSE and have found your videos very informative. However, your service deserves even more praise.": I inadvertently ordered two of the same course on Routing and Remote Access and when I discovered my mistake, I was very upset.

Internet based companies are often hard to deal with. If you try to return something, they put you off -sometimes indefinitely. I was almost sure that I would encounter problems when I attempted to exchange the video.

I called Ashley on the phone and informed her of my intent to exchange the duplicate video for another. She told me that she would send the other video when I returned mine.

I sent the video back by UPS and within a few days I received a package with the new Active Directory tutorial movie. I was so impressed that your company did not try to hold the movie hostage or to delay sending it. Even though I am an avid supporter of technology, I have to agree with those who say that the age of impersonal commerce has opened doorways to poor service.

I hope your company is successful and that others realize the benefit of doing business with someone they can trust!

Sincerely,
Nancy Ashley Ware

Looking For Volume User Licensing For Access 2010 Training?

24/7 Access to Training

Online access to all training through My Online Training, with an option for physical media.

Volume Discounts

Discounts start at quantities as low as 2 licenses per training course.

Scalable Licensing Model

License your team for specific courses that meet their needs to build a custom package of TrainSignal Training.

Call 1.888.229.5055 or Email sales@trainsignal.com

Contact us for a free volume license quote or tell us how many licenses you need and we'll show you the volume license discount immediately in your cart.

Volume Discount Pricing For Access 2010 Training

# of Users	% Discount	Cost Per User
1	0%	$97.00
2	20%	$77.60
3-4	25%	$72.75
5-9	30%	$67.90
10-19	35%	$63.05
20-49	40%	$58.20
50+	Call 1.888.229.5055