Home >> Desktop Applications >> Microsoft Office Training >> Office 2010
Microsoft Access 2010 Online / CBT Training Course
Video Course Duration: 9 hours 20 minutes
Not Available
Available
|
||||||||||||||||||||||||
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. We also have a variety of other Microsoft Office training courses to choose from.
Available Access 2010 Learning Formats
- CD
- Online
- Network Deployable
Learn Microsoft Access 2010 Training via Online
Those that always have Internet connection handy will enjoy learning from our Microsoft Access 2010 online training course that is completely take from the desktop of your computer. Instead of having to drive to an offsite location for class, you can easily access the online Access 2010 training videos whenever you want, any time of day or night, 24/7 since you can access the online account whenever you have time. The elearning option will provide a quality education for those that want the convenience of learning on their own.
Learn Microsoft Access 2010 CBT Training Videos on CD / DVD
Our self-study Access 2010 CBT course is also a great option for learning since it is also taken from your computer. The only difference between the Access 2010 CBT course and our online option is that you learn from our Microsoft Access 2010 training CD. On the CD is our self-paced Access 2010 computer based training videos that teach you all the necessary information via in-depth discussions, demos, presentations and more that detail the information in understandable terms you will remember when working with the program on your own. The computer based training program offers those too busy for school to learn whenever they please.
Microsoft Access 2010 Training Outline:
Microsoft Access 2010 Basic
1.0 Getting Started with Access 2010
Introduction
What is Access? Explore the Access Environment
Customizing the Quick Access Toolbar and Ribbon
View an Existing Access Database
Tables, Queries, Forms and Reports
Explore the Different Views of Access
Introduction to Relational Database Design
Five Essential Steps for Database Design
Creating a New Blank Database
Getting Help
Summary
2.0 The Essential Access Building Block: Tables
Introduction
Create a Table using the Table Wizard
Create a Table in Design View
Identifying Data Types
Establishing a Primary Key
Setting Fields Properties
Creating Table Relationships
Identifying the Types of Table Relationships
Establishing Referential Integrity
Changing the Table Design
Summary
3.0 Working with Tables
Introduction
Typing Data in the Tables
Find Records
Sort Records
Filter Records
Adding, Deleting and Changing Records
View Data from Related Tables
Modifying Tables: Rename, Copy, Delete, Save As
Summary
4.0 Queries
Introduction
Create a Select Query Using the Wizard
Create a Select Query in Design View
Add Criteria to a Query
How to Ask And/Or Questions
Using Wildcards to Find Data
Setting Query Properties
Modify the Query Design
Add a Calculated Field to a Query
Summary
5.0 Designing Forms
Introduction
View Data Using an Access Form
Add, Modify or Delete Records Using an Access Form
Create a Form Using the Form Wizard
Create a Form from Scratch
Create a Calculated Field on a Form
Improving a Form Using the Toolbox
Looking at Form Properties
Using the Data Entry Property
Summary
6.0 Generating Reports
Introduction
View an Access Report
Create an Access Report From Scratch
Create an Access Report Using the Wizard
Add a Calculated Field to a Report
Looking at Report Properties
Apply a Theme to a Report
Prepare a Report for Printer
Making Changes to a Report
Adding Groups and Sorting
Summary
Microsoft Access 2010 Intermediate
1.0 Enhancing Tables
Introduction
Validation Rules and Validation Text
Create an Input Mask
Use the Lookup Wizard to Restrict Data Entry
Using Hyperlinks in Tables
Utilizing the OLE Data Type
Summary
2.0 Using a Variety of Query Types
Introduction
Create a Query with Two or More Tables
Create a Parameter Query
Create an Update Query
Create an Append Query
Create a Delete Query
Make Table Query
Find Duplicates Using the Wizard
Find Unmatched Using the Wizard
Use the Record Grouping Tool
Showing Top Values
Summary
3.0 Charting
Introduction
Charting in Forms
Charting in Reports
Summary
4.0 Pivot Tables and Pivot Charts
Introduction
Create a Pivot Table
Using the Pivot Chart View
Summary
5.0 Macros
Introduction
Looking at the Macro Environment
Creating a Macro
Running and Modifying a Macro
Attaching a Macro to a Form Button
Creating an AutoExec Macro
Summary
Microsoft Access 2010 Advanced
1.0 Advanced Tools in the Database
Introduction
Compacting and Repairing a Database
Using Data Analysis Tools
Splitting a Database
Encrypting a Database and Setting a Password
Convert a Database to an MDE File
Creating a Database Backup
Summary
2.0 Using Access with Other Applications
Introduction
Importing Excel
Exporting Data to Excel
Exporting to PDF
Exporting into a Word Mail Merge
Publishing in HTML to a Web Browser
Sharing VIA Email
Summary
3.0 Reports
Introduction
Adding Conditional Formatting and Data Bars
Creating Multi-Table Reports
Creating Mailing Labels
Summary
4.0 Queries
Introduction
Parameter Queries
Using an Update Query to Convert Text to Proper Case
Query to Display Due Dates for the Current Month
Show Records from the Last 3 Months
Using an Append Query to Set the Initial Value of an AutoNumber Field
Summary
5.0 Forms
Introduction
Creating a Switchboard
Setting Startup Options
Setting Tab Stops on Forms
Using Subforms
Summary
