Learn Microsoft Access 2010 - Beginners
Create, design, and customize high-performing databases.
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.
This course includes:
- 7 hours of video tutorials
- 28 individual video lectures
- Optional quiz with 35 test questions
- Certificate of Completion
The “IT” in Simon Sez IT stands for “Information Technology.” We offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious institutions. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.
Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In our first four years alone, we serviced tens of thousands of satisfied customers in over 100 countries.
PreviewCreating Tables & Basic Setup of Relationships (15:25)
PreviewUsing Quick Parts to Setup New Table, Importing Spreadsheet (16:18)
StartEntering Data Types into Tables (15:18)
StartChanging Table Attributes, Copy, Rename, Delete Records (16:21)
StartTable Structures (15:15)
StartTable and Field Properties (15:55)