Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
In today’s workplace, data management skills are absolutely crucial, and Microsoft Access is the most widely available software for the job. Whether you need beginner, intermediate or advanced level Access 2010 training, our Ultimate Microsoft Access 2010 Training Course has got you covered. Starting with the absolute basics, these informative and engaging courses will take you to the level of total data mastery in both editions of the program, as you work through both beginners and advanced courses.
If you need to manage data at all in your job, or are looking for a promotion to a role where you do, then you simply can’t afford to miss this training.
This bundle includes:
Courses included with this bundle:
Learn Microsoft Access 2010
Discover the fundamentals of database design and construction, as this will allow you to construct a strong relational database that makes future modifications and data analysis easier.
Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports.
Learn Microsoft Access 2010 - Advanced
Beyond just getting data into the database, in our Advanced level course, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—both in terms of how they look on paper as well as due to the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases.
Where else can you find so many extra tools to help you master Access?
What people are saying:
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
"Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!"
- Lisa R., France.
“The instructor is easy to follow. He explains things clearly and takes his time going over it. The best part is that you can review the course as often as you want if there is something you are having a hard time grasping.”- Terry J. Stigall
“Easy to understand and informative. I consider myself an advanced user of MS Access, but I learned something useful in every chapter.”- Kathleen Dziubek
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting to Know the Workspace|
Intro to Backstage View, Ribbon, Quick Access Toolbar & OptionsPreview
IMPORTANT - Read this to ensure the best video quality!
Start/Exit, Help Features, Shortcuts, Views, TemplatesPreview
|Section 2: Access Basics|
Understanding Database ComponentsPreview
Introduction to Design of a DatabasePreview
Introduction to Building a DatabasePreview
|Section 3: Tables|
Creating Tables & Basic Setup of Relationships
Using Quick Parts to Setup New Table, Importing Spreadsheet
Entering Data Types into Tables
Changing Table Attributes, Copy, Rename, Delete Records
Table and Field Properties
|Section 4: Forms|
Auto-Create Forms, Filtering & SearchingPreview
Types of Different Forms & Creating New
Improve Look, Style, & Feel of Forms
Adding Fields to Existing Form
|Section 5: Expression Builder|
Understanding and Setting Up the Expression Builder
|Section 6: Conditional Formatting|
Format Control on Forms/Reports
|Section 7: Sorting and Filtering|
Sorting Single & Multiple Columns; Filter One Field Data Records
Sorting & Filtering Data in Form View; Find & Replace in Forms
|Section 8: Reports|
Understanding Reports & Structure
Creating Reports; Using Print Preview to Check Report Outcome
Advanced Reporting; Formatting Reports
How to Improve Report Design, Add Existing Fields; Group/Sort
|Section 9: Queries|
Select Queries; Sorting; Defined Criteria
Change Fields wthin Query; Specifying Criteria for Numbers/Text
Update Queries; Append Queries; Delete Queries
Inner/Outer Joins; Make Table Queries; Mail Merge
|Section 10: Security|
Securing Database and Views; New Features
|Section 11: Access 2010 Quiz|
|Section 12: Introduction to Advanced Access 2010|
|Section 13: Macros|
Working with Macros
|Section 14: Database Options Before Distribution|
More Database OptionsPreview
|Section 15: Naming|
Renaming Database Objects
|Section 16: Tables Review of Table|
Basics & Understanding Data Types
Table Field Properties
Validation Rules & Tex
|Section 17: Keys and Indexes|
Understanding & Using Keys and Indexes
|Section 18: Normalization|
|Section 19: Relationships|
Types of Relationships
|Section 20: Queries|
Using & Understanding Queries
Creating Queries and Using Join & Sub-Queries
|Section 21: Datasheet View|
|Section 22: Forms|
Creating & Working with Forms
Using Forms to Maintain Data
Command Buttons Part 2
Visual Basic for Applications
|Section 23: Visual Basic for Applications|
Understanding When & How to Use VBAPreview
More about VBA and Using It to Improve Database
VBA Language Structure & Making a Switchboard
|Section 24: Polishing Up|
Cleaning Up Before Distribution
|Section 25: Security|
|Section 26: Import/Export|
External Data & Importng/Exporting Data
|Section 27: Linking to Data|
Linking to Excel & Linking to Another DatabasePreview
|Section 28: Splitting Database|
Separating/Splitting Up Forms, Reports, etc from Database
|Section 29: Multi-User|
Options for Making Changes When Database is Multi-User
|Section 30: Reports|
Advanced Features for Reports
Advanced Features for Reports part 2
|Section 31: Package & Distribute|
|Section 32: Access 2010 Advanced Quiz|
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.