Amazing eLearning
 Shopping Cart: 0 item(s) / Total: $0
Accounting
Business Office
CompTIA Certification
Database
eLearning
Graphic Design
Networking
Operating Systems
Personal Finance
Programming
Project Management
Video Editing
Virtualization
Web Design
3D Animation
Freebies
Gift Certificate
Apps Center
Find our products in these locations:

Microcenter
Amazon
Frys


Internation Shipping Available
Secure checkout insured
Credit Card Processing

Amazing eLearning, LLC, Computers - Training, Burlingame, CA

McAfee SECURE sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Home > Business Office  > Microsoft Office 2010

Your Choice - Online Access (default) or DVD Course (optional)

Microsoft Access 2010 Expert Training
Reward Points
149 points will be rewarded to you when you buy this item.
Share |

Microsoft Access 2010 Expert Training

Part Number access2010
review 0 Review(s)
0
Review this item Review this item
Your Price:
$149.00
Availability:
In Stock
Quantity
Email a friend Email a friend
Description

Microsoft Access 2010 Video Training Baisc, Intermediate, and Advanced Level

Become a master of the new version of Microsoft’s database program when taking our Microsoft Access 2010 training course. Not only will you learn all the new features and enhancements, but our self-study Access 2010 training videos are taught by certified instructors in the field that have years of experience in the corporate training world. With our Microsoft Access 2010 training course, you will learn from a variety of interactive components that make learning fun while still informative. Busy professionals don’t have to take time off of work or miss out on family time when learning from our self-study Access 2010 training videos either. 

 

Microsoft Access 2010 Basic

1.0 Getting Started with Access 2010
1.1 Introduction
1.2 What is Access? Explore the Access Environment
1.3 Customizing the Quick Access Toolbar and Ribbon
1.4 View an Existing Database
1.5 Tables, Queries, Forms and Reports
1.6 Explore the Different Views of Access
1.7 Introduction to Relational Database Design
1.8 Five Essential Steps for Database Design
1.9 Ceating a New Blank Database
1.10 Getting Help
1.11 Summary

2.0 The Essential Access Building Block: Tables
2.1 Introduction
2.2 Creating a Table using Table Wizard
2.3 Creating a Table in Design View
2.4 Identifying Data Types
2.5 Establishing a Primary Key
2.6 Setting Fields Properties
2.7 Creating Table Relationships
2.8 Identifying the Types of Table Relationships
2.9 Establishing Referential Integrity
2.10 Changing the Table Design
2.11 Summary

3.0 Working with Tables
3.1 Introduction
3.2 Changing Fonts
3.3 Cells Borders and Colors
3.4 Column Width and Row Height Modification
3.5 The Number Group
3.6 The Alignment Group
3.7 The Styles Grouip
3.8 The Themes Grouip
3.9 Summary

4.0 Queries
4.1 Introduction
4.2 Deleting and Adding Cells
4.3 Hiding and Unhiding Rows
4.4 Finding and Selecting Tools
4.5 Using Spell Check
4.6 How to use Copy and Paste Function
4.7 Summary

5.0 Designing Forms
5.1 Introduction
5.2 Worksheet Tab Configuration
5.3 View and Zoom
5.4 Setting Panes and Split Windows
5.5 Working with Multiple Windows
5.6 Summary

6.0 Generating Reports
6.1 Introduction
6.2 Printing your Workbook
6.3 Advanced Printing Options
6.4 Sharing as Other File Types
6.5 Summary


Microsoft Access 2010 Intermediate

1.0 Enhancing Tables
1.1 Introduction
1.2 Validation Rules and Validation Text
1.3 Creating an Input Mask
1.4 Using Lookup Wizard to Restrict Data Entry
1.5 Using Hyperlink in Tables
1.6 Utilizing OLE Data Type
1.7 Summary

2.0 Using a Variety of Query Types
2.1 Introduction
2.2 Creating a Query with Two or More Tables
2.3 Creating a Parameter Query
2.4 Creating an Update Query
2.5 Creating an Append Query
2.6 Creating a Delete Query
2.7 Making Table Query
2.8 Finding the Duplicates Using the Wizard
2.9 Finding the Unmatched Using the Wizard
2.10 Using the Record Group Tool
2.11 Showing Top Values
2.12 Summary

3.0 Charting
3.1 Introduction
3.2 Charting in Forms
3.3 Charting in Reports
3.4 Summary

4.0 Pivot Tables and Pivot Charts
4.1 Introduction
4.2 Creating a Pivot Table
4.3 Using the Pivot Chart View
4.4 Summary

5.0 Macro
5.1 Introduction
5.2 Looking at the Macro Enviornment
5.3 Creating a Macro
5.4 Running and Modifying a Macro
5.5 Attaching a Macro to a Form Button
5.6 Creating an AutoExec Macro
5.7 Summary


Microsoft Access 2010 Advanced

1.0 Advanced Tools in Database
1.1 Introduction
1.2 Compacting and Repairing a Database
1.3 Using Data Analysis Tools
1.4 Splitting a Database
1.5 Encrypting a Database and Setting up a Password
1.6 Converting a Database to an MDE File
1.7 Creating a Database Backup
1.8 Summary

2.0 Using Access with Other Applications
2.1 Introduction
2.2 Importing Excel
2.3 Exporting Data to Excel
2.4 Exporting to PDF
2.5 Exporting to Mail Merge in Word
2.6 Publishing in HTML to a Web Browser
2.7 Sharing via E-Mail
2.8 Summary

3.0 Reports
3.1 Introduction
3.2 Adding conditional Formatting and Data Bars
3.3 Creating Multi-Table Reports
3.4 Creating Mailing Labels
3.5 Summary

4.0 Queries
4.1 Introduction
4.2 Parameter Queries
4.3 Using an Update Query to Covnert Text to Proper Case
4.4 Query to Display Due Dates for the Current Month
4.5 Show Records from the last Three Months
4.6 Using an Append Query to Set The Initial Value of an Auto Number Field
4.7 Summary

5.0 Forms
5.1 Creating a Switchboard
5.2 Setting Startup Options
5.3 Setting Tab Stop on Forms
5.4 Using Subforms
5.5 Summary

   

 

We only use certified instructors to lead our Microsoft Access 2010 training video, ensuring that you get the information you need in a way that is easy to understand. The reviews and exams help you to measure your success as you progress through the training materials. Our online instructors, or e-structors, are available to you online 24 hours a day, 7 days a week to answer any questions that you might have while working through your Microsoft Access 2010 video training. Any one of these items is a tremendous resource, but when combined the learn Access 2010 video course becomes a powerful CBT learning environment.

 

Our Access 2010 training video course offers several advantages over traditional instructor led courses. Because we package all of the training materials on DVD, you are able to access your training anywhere you have a computer. Bring the Microsoft Access 2010 training DVD with you to work to study at lunchtime and then bring it home to use on your home computer in the evening. You decide when and where you are going to study. Another advantage of the Microsoft Access 2010 videos is that you are in control of your learning experience. In a live class, you must learn the information at the time and pace it is presented and hope that you retain it. With our CBT format, you can review the information anytime you like and you control how quickly or slowly you progress through the course materials. You can watch the how to use Access 2010 video as many times as you need to in order to fully understand the information being taught. An added benefit of DVD based computer based training is the cost savings. With our DVD format, you can save up to 80% when compared to typical instructor led classes. CBT learning is simply a better way to learn.

 
Content: CD-ROM disc (sealed in a DVD-case)

System Requirements:
Platform: Windows 7, Vista and XP 
Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X

 

Microsoft Access 2010 Training Video CBT Features:

 
Accessories
Microsoft Excel 2010 Expert Training
Microsoft Excel 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
Microsoft OneNote 2010 Expert Training
Microsoft OneNote 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
Microsoft Outlook 2010 Expert Training
Microsoft Outlook 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
Microsoft PowerPoint 2010 Expert Training
Microsoft PowerPoint 2010 Expert Training
Average Rating 1 Review(s)
Your Price: $99.95
Microsoft Project 2010 Expert Training
Microsoft Project 2010 Expert Training
Average Rating 1 Review(s)
Your Price: $149.00
Microsoft Visio 2010 Expert Training
Microsoft Visio 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $99.95
Microsoft Word 2010 Expert Training
Microsoft Word 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
  
Related Items
Microsoft Word 2010 Step-By-Step Training
Microsoft Word 2010 Step-By-Step Training
Average Rating 0 Review(s)
Your Price: $39.95
Microsoft Word 2010 Expert Training
Microsoft Word 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
Microsoft Outlook 2010 Expert Training
Microsoft Outlook 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
Microsoft Visio 2010 Expert Training
Microsoft Visio 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $99.95
Microsoft Project 2010 Expert Training
Microsoft Project 2010 Expert Training
Average Rating 1 Review(s)
Your Price: $149.00
Microsoft Excel 2010 Expert Training
Microsoft Excel 2010 Expert Training
Average Rating 0 Review(s)
Your Price: $149.00
Mastering After Effect 6.5 Mastering After Effect 6.5
$9.95
more details
Adobe Dreamweaver CS3 Instructor-led Video Training
$49.95
Learn Acrobat Fast
$1.99