The Ultimate Microsoft Access 2010 Training Course 15 Hours (Udemy.com)

Have all the database terms, data, and reports got you down? Demystify Access forever with this effective course.

Created by: Simon Sez IT

Produced in 2018

icon
What you will 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 distri

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 82 / 100

icon
Course Description

In todays 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 cant afford to miss this training. This bundle includes: 15 hours of video tutorials Over 60 individual video lectures Optional quizzes to test what youve 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/sortingas 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 shineboth 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 Who this course is for:
Anyone new to Microsoft Access or upgrading from an earlier version.

icon
Instructor Details

Simon Sez IT

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 over 5,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 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

icon
More courses by Simon Sez IT

The Ultimate QuickBooks Pro Training Bundle - 60+ Hours

$11.99

The Ultimate Microsoft Office 2016 Training Bundle

$11.99

Learn Microsoft Excel Pivot Tables

$11.99

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

$11.99

QuickBooks Pro 2017 Training: Manage Small Business Finances

$11.99

Learn Microsoft Windows 10 the Easy Way for Beginners

$11.99

icon
More office productivity courses

MS-700 Managing Microsoft Teams Training & Lab Simulations

$11.99

How to Create Animated Videos with Powerpoint

$11.99

Microsoft PowerPoint From Beginner to Advanced

$11.99

Productivity Hacks for Writers (Writing Mastery)

$11.99

Powerpoint 2016 2019 - Master powerpoint presentation

$11.99

Master Microsoft Word Beginner to Advanced

$11.99

icon
Reviews

4.1

22 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Richard Duncan on 3/3/2020

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.

By Raelene Noti on 8/27/2019

it is a good match

By Victor R Pendleton on 2/3/2019

I know most of this so it is slow

By Mitch Hertzler on 11/5/2018

It seems like it will be very informative. However, the last video showed that he was using Access 2007 and this is a course for Access 2010.

By Angel Ramos on 8/11/2018

Although nice and slow paced, a bit too slow for my current understanding of the subject. Also, this seems lower than the advanced level I'm trying to further learn.

By William Scott on 5/14/2018

Learnt a lot and always good to coma back and refresh my knowledge.

By Brooks Gustafson on 1/13/2018

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.

By Carol Schablow on 11/1/2017

Good initial overview of the basic features

By Greer Dixon on 10/6/2017

Used Access several years ago - nice refresher

By Deanna Rodgers on 4/22/2017

Very informative

By Shannon Oien on 11/24/2016

I like Toby's methodical approach.

By Edward Hyatt on 9/26/2016

So far course has been great, it starts very basic but gives you a good foundation.