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.
Learn Microsoft Access 2010 by Simon Sez IT is a 7-hour course filled with all the information you need to create, design, and customize high-performing databases. Your professional trainer will introduce you to Microsoft’s “Ribbon” interface, showing you tips and techniques to leverage its features for more efficient database management.
Discover the fundamentals of database design and construction, which 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.
Before the “Microsoft Access Training: Microsoft Access Tutorial” course is over, we’ll cover all key areas of the program: custom queries using defined criteria, select queries, updating queries, appending queries, deleting queries, inner joins, outer joins, table queries, and mail merges.
Plus, when you sign up for our class, you’ll also get these 5 BONUSES in addition to the 40 online course videos:
Where else can you find so many extra tools to help you master Access 2010?!?!
So start learning today. Because being a technology dinosaur isn’t going to get you a promotion or raise!
All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged.
What our customers are saying:
"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.
So take this Microsoft Access training and learn from Microsoft Access tutorial.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Chapter 1 - Getting to Know the Workspace|
Intro to Backstage View, Ribbon, Quick Access Toolbar & OptionsPreview
Essential Information for a Successful Training Experience
Start/Exit, Help Features, Shortcuts, Views, TemplatesPreview
Access 2010 keyboard shortcuts
MP3 audio files
|Section 2: Chapter 2 - Access Basics|
Understanding Database ComponentsPreview
Introduction to Design of a DatabasePreview
Introduction to Building a Database
|Section 3: Chapter 3 - Tables|
Creating Tables & Basic Setup of RelationshipsPreview
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: Chapter 4 - Forms|
Auto-Create Forms, Filtering & Searching
Types of Different Forms & Creating New
Improve Look, Style, & Feel of Forms
Adding Fields to Existing Form
|Section 5: Chapter 5 - Expression Builder|
Understanding and Setting Up the Expression Builder
|Section 6: Chapter 6 - Conditional Formatting|
Format Control on Forms/Reports
|Section 7: Chapter 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: Chapter 8 - Reports|
Understanding Reports & StructurePreview
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: Chapter 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: Chapter 10 - Security|
Securing Database and Views; New Features
|Section 11: 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,500+ 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 280,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.