Microsoft Access 2013 DVD Training Course – Amazing eLearning
Microsoft Access 2013 DVD Training Course

Microsoft Access 2013 DVD Training Course

Regular price
Sale price
Shipping calculated at checkout.

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

Become a master of the new version of Microsoft’s database program when taking our Microsoft Access 2013 training course. Not only will you learn all the new features and enhancements, but our self-study Access 2013 training videos are taught by certified instructors in the field that have years of experience in the corporate training world. With our Microsoft Access 2013 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 2013 training videos either.


Microsoft Access 2013 Basic

1.0 Getting Started with Access 2013
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 2013 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 2013 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


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 10, 8, 7, Vista and XP
Processor: Pentium 133 Mhz or higher
Hard drive space: 10MB
CD-ROM Drive speed: 24X