The Ultimate Microsoft Access 2010 Training Course 15 Hours

Have all the database terms, data, and reports got you down? Demystify Access forever with this effective course.
3.8 (32 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,264 students enrolled
$19
$125
85% off
Take This Course
  • Lectures 65
  • Length 15.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2014 English

Course Description

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

What are the requirements?

  • Microsoft Access 2010

What am I going to get from this course?

  • 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.

What is the target audience?

  • Anyone new to Microsoft Access or upgrading from an earlier version.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting to Know the Workspace
Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
Preview
15:38
IMPORTANT - Read this to ensure the best video quality!
Article
Start/Exit, Help Features, Shortcuts, Views, Templates
Preview
15:32
Section 2: Access Basics
Understanding Database Components
Preview
15:14
Introduction to Design of a Database
Preview
14:19
Introduction to Building a Database
Preview
13:27
Section 3: Tables
Creating Tables & Basic Setup of Relationships
15:25
Using Quick Parts to Setup New Table, Importing Spreadsheet
16:18
Entering Data Types into Tables
15:18
Changing Table Attributes, Copy, Rename, Delete Records
16:21
Table Structures
15:15
Table and Field Properties
15:55
Section 4: Forms
Auto-Create Forms, Filtering & Searching
Preview
15:13
Types of Different Forms & Creating New
14:56
Improve Look, Style, & Feel of Forms
15:13
Adding Fields to Existing Form
15:58
Section 5: Expression Builder
Understanding and Setting Up the Expression Builder
14:58
Section 6: Conditional Formatting
Format Control on Forms/Reports
14:58
Section 7: Sorting and Filtering
Sorting Single & Multiple Columns; Filter One Field Data Records
15:33
Sorting & Filtering Data in Form View; Find & Replace in Forms
15:10
Section 8: Reports
Course Review
00:43
Understanding Reports & Structure
15:24
Creating Reports; Using Print Preview to Check Report Outcome
15:35
Advanced Reporting; Formatting Reports
15:23
How to Improve Report Design, Add Existing Fields; Group/Sort
14:25
Section 9: Queries
Select Queries; Sorting; Defined Criteria
15:00
Change Fields wthin Query; Specifying Criteria for Numbers/Text
15:31
Update Queries; Append Queries; Delete Queries
15:56
Inner/Outer Joins; Make Table Queries; Mail Merge
16:27
Section 10: Security
Securing Database and Views; New Features
14:01
Section 11: Access 2010 Quiz
Assessment Test
35 questions
Section 12: Introduction to Advanced Access 2010
Introduction
10:50
Section 13: Macros
Working with Macros
15:57
AutoExec Macro
15:42
Section 14: Database Options Before Distribution
Database Options
Preview
11:40
More Database Options
Preview
15:35
Section 15: Naming
Renaming Database Objects
11:13
Section 16: Tables Review of Table
Basics & Understanding Data Types
13:34
Table Field Properties
14:22
Validation Rules & Tex
13:31
Section 17: Keys and Indexes
Understanding & Using Keys and Indexes
15:47
Section 18: Normalization
Data Normalization
15:38
Section 19: Relationships
Types of Relationships
12:39
Maintaining Relationships
07:29
Section 20: Queries
Using & Understanding Queries
11:47
Complex Queries
16:04
Creating Queries and Using Join & Sub-Queries
16:00
Section 21: Datasheet View
Datasheet View
15:30
Section 22: Forms
Creating & Working with Forms
13:56
Using Forms to Maintain Data
16:04
Command Buttons
14:10
Command Buttons Part 2
14:45
Visual Basic for Applications
09:39
Section 23: Visual Basic for Applications
Understanding When & How to Use VBA
Preview
16:01
More about VBA and Using It to Improve Database
14:46
VBA Language Structure & Making a Switchboard
15:19
Error Handling
16:24
Section 24: Polishing Up
Cleaning Up Before Distribution
16:48
Section 25: Security
Security Techniques
15:59
Section 26: Import/Export
External Data & Importng/Exporting Data
16:39
Section 27: Linking to Data
Linking to Excel & Linking to Another Database
Preview
09:25
Section 28: Splitting Database
Separating/Splitting Up Forms, Reports, etc from Database
09:37
Section 29: Multi-User
Options for Making Changes When Database is Multi-User
14:56
Section 30: Reports
Advanced Features for Reports
12:35
Advanced Features for Reports part 2
12:50
Section 31: Package & Distribute
Distributing Application
15:00
Section 32: Access 2010 Advanced Quiz
Assessment Test
40 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

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.

Ready to start learning?
Take This Course