Microsoft Access 2010 Training - Advanced

Upgrading your Microsoft Access skills is a smart move for any professional.
4.4 (35 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.
2,116 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 40
  • Length 11.5 hours
  • Skill Level Expert Level
  • 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 11/2012 English

Course Description

Ideal for those seeking to advance their careers by developing top-notch database skills, the Microsoft Access Training: Learn Microsoft Access 2010 course by Simon Sez IT provides 8 full hours of expert quality training videos. Learn Microsoft Access 2010 - Advanced takes the seemingly overwhelming concept of advanced database management and breaks it into several easy to understand, detailed chapters. A general understanding of previous versions of Microsoft Access will make this Microsoft Access Training: Learn Microsoft Access 2010 course comfortable and will be a great base from which to build.

Beyond just getting data into the database, 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—in terms of how they look on paper and 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.

Plus, when you sign up for our class, you’ll also get these 5 BONUSES in addition to the 40 online course videos:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (40 questions) - to test what you've learned.
  3. Downloadable & printable transcripts (over 160 searchable pages) – to give you another learning option, if you prefer reading but don’t have time to take notes.
  4. 8 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym.
  5. A certificate of completion to tell everyone you've aced the course.

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.

Take this Microsoft Access Training course now and learn Microsoft Access 2010 advanced level.

What are the requirements?

  • Intermediate level Access knowledge

What am I going to get from this course?

  • 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.
  • How to best use the multi-user aspects of Access 2010.

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: Chapter 1 - Introduction
Introduction to Advanced Access 2010
Preview
10:50
IMPORTANT - Read this to ensure the best video quality!
Article
Course transcripts
163 pages
Microsoft Access 2010 keyboard shortcuts
28 pages
MP3 audio files
Article
Section 2: Chapter 2 - Macros
Working with Macros
Preview
15:57
AutoExec Macro
Preview
15:42
Section 3: Chapter 3 - Database Options before Distribution
Database Options
11:40
More Database Options
15:35
Section 4: Chapter 4 - Naming
Renaming Database Objects
11:13
Section 5: Chapter 5 - Tables
Review of Table Basics & Understanding Data Types
Preview
13:34
Table Field Properties
14:22
Validation Rules & Text
13:31
Section 6: Chapter 6 - Keys and Indexes
Understanding & Using Keys and Indexes
15:47
Section 7: Chapter 7 - Normalization
Data Normalization
15:38
Section 8: Chapter 8 - Relationships
Types of Relationships
12:39
Maintaining Relationships
07:29
Section 9: Chapter 9 - Queries
Using & Understanding Queries
Preview
11:47
Complex Queries
16:04
Creating Queries and Using Join & Sub-Queries
16:00
Section 10: Chapter 10 - Datasheet View
Course Review
00:43
Datasheet View
15:30
Section 11: Chapter 11 - Forms
Creating & Working with Forms
Preview
13:56
Using Forms to Maintain Data
16:04
Command Buttons
14:10
Command Buttons Part 2
14:45
Form Features that Need VBA Code
09:39
Section 12: Chapter 12 - 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 13: Chapter 13 - Polishing Up
Cleaning Up Before Distribution
16:48
Section 14: Chapter 14 - Security
Security Techniques
15:59
Section 15: Chapter 15 - Import/Export
External Data & Importing/Exporting Data
16:39
Section 16: Chapter 16 - Linking to Data
Linking to Excel & Linking to Another Database
09:25
Section 17: Chapter 17 - Splitting Database
Separating/Splitting Up Forms, Reports, etc from Database
09:37
Section 18: Chapter 18 - Multi-User
Options for Making Changes When Database is Multi-User
14:56
Section 19: Chapter 19 - Reports
Advanced Features for Reports
12:35
Advanced Features for Reports part 2
12:50
Section 20: Chapter 20 - Package & Distribute
Distributing Application
15:00
Section 21: 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