Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Have all the database terms, data, and reports got you down? Demystify Access forever with this effective course.
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:
- 15 hours of video tutorials
- Over 60 individual video lectures
- Optional quizzes to test what you’ve learned
- Certificate of completion
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."
- TopTenReviews.com
"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
Course Content
- 32 section(s)
- 66 lecture(s)
- Section 1 Getting to Know the Workspace
- Section 2 Access Basics
- Section 3 Tables
- Section 4 Forms
- Section 5 Expression Builder
- Section 6 Conditional Formatting
- Section 7 Sorting and Filtering
- Section 8 Reports
- Section 9 Queries
- Section 10 Security
- Section 11 Access 2010 Quiz
- Section 12 Introduction to Advanced Access 2010
- Section 13 Macros
- Section 14 Database Options Before Distribution
- Section 15 Naming
- Section 16 Tables Review of Table
- Section 17 Keys and Indexes
- Section 18 Normalization
- Section 19 Relationships
- Section 20 Queries
- Section 21 Datasheet View
- Section 22 Forms
- Section 23 Visual Basic for Applications
- Section 24 Polishing Up
- Section 25 Security
- Section 26 Import/Export
- Section 27 Linking to Data
- Section 28 Splitting Database
- Section 29 Multi-User
- Section 30 Reports
- Section 31 Package & Distribute
- Section 32 Access 2010 Advanced Quiz
What You’ll Learn
- Learn the Access 2010 interface including the Backstage View, Ribbon Features, and Quick Access Toolbar.
- Explore the fundamentals of a database including records, fields, table objects, relationships, and primary keys.
- Discover techniques for creating forms that present data in a visual way.
- Understand and set-up the expression builder.
- Filter data in single and multiple columns in tables and forms.
- Learn how to create reports.
- Discover how to improve your report design, add existing fields, and how to group and sort right on the report.
- Learn how to update the database quickly using update queries, append queries, and delete queries.
- Execute a set of defined actions and learn to create and modify macros.
- Identify best practices for naming objects in an Access 2010 Database.
- Learn to collect data from external sources.
- Discover the importance of preparing an Access database for distribution and for multi-user access by separating forms.
- Distinguish the difference between Word and Excel macros, and the macros and VBA programs that are a part of Access.
- Learn best practices for setting-up a new database.
- Using VBA for robust error handling and making a handy switchboard.
Skills covered in this course
Reviews
-
RRichard Duncan
I have a friend who has a growing small business and is desperately wanting a software package to help him manage his business. I designed an Approach database years ago to manage a business of my own so I have some familiarity with database design. Of course Access is much more robust than Approach ever was so this course is exactly what I need learn what need to help my friend and possibly start a design business as well.
-
BBrooks Gustafson
So far it is great...some of the information I already knew coming into this training. the instructor seems to be laying a very good groundwork of what a database is and its function through the access program.
-
WWilliam Scott
Learnt a lot and always good to coma back and refresh my knowledge.
-
JJenny Southern
Good content, seems quite thorough thus far. The constant flicking between screen's after each part is a bit annoying.