Advanced Microsoft Access 2010 Tutorial

Take your Microsoft Access skills to the next level with this Advance Access Tutorial.
4.3 (46 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,468 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 75
  • Length 7.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 5/2012 English

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Advanced Microsoft Access 2010 Tutorial Video picks up where the InfiniteSkills beginner course leaves off and shows how to work with some of the program's more robust database creation and management features. Presented by a professional IT trainer, the video lessons go point by point through advanced query options and form design, as well as a number of shortcuts and productivity options that can simplify and shift the way you work. Given the advanced subject matter, the order of the Access course is logical and easy to follow. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data, and the course's full chapter on Macros make it easy to manage and access data in Access 2010. Project files are included to match the examples onscreen.


What You Will Learn

- How to perform advanced data manipulation across multiple databases and sources.
- How to create complex user forms that will improve the quality and quantity of data collected.
- How to perform crucial management and maintenance functions using Access utilities and commands.
- How to enhance and develop secure, compatible databases that can be accessed by users working with Office products and common industry standards such as SQL.


Who Should Take This Course

- Anyone with a basic understanding of Microsoft Access who wants to unlock the program's power user capabilities and security features.
- Anyone who wants to implement Access solutions within SQL-based and mixed environments.
- Access administrators looking to work faster and smart through shortcuts and macros that automate repetitive tasks.


What People Are Saying

"I was told we'd have to move everything over to MySQL to get the security we needed, but these tutorials helped me prove otherwise. The lessons on encryption were perfect."
- Hank Mascis

"I am genuinely impressed with what is capable with Access now. It's improved greatly over the years, and this training and the VBA course has helped me see the light."
- V Spinotto

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 Started
Working Files - Download These First
Preview
Article
What Will This Course Cover
Preview
02:41
Relational Databases Demystified
Preview
07:54
Using The Working Files
04:12
Section 2: Advanced Table Design
Creating And Using Input Masks
09:02
Indexing - The Hows And Whys
07:31
Multiple Field Primary Keys
02:48
Section 3: Advanced Queries
Selecting Unique Values
04:35
Use Of Parameter Queries
07:35
Adding A Calculated Field
05:35
Using iif In A Calculated Field
04:45
Creating A Cross Tab Query
05:19
A Cross Tab Without The Wizard
03:31
Why Change The Join Type In Queries
07:09
Viewing And Writing SQL
07:50
Introducing The Expression Builder
06:45
The Power Of The Sub Query
06:47
Generating A Union Query In Access
06:43
Section 4: Action Queries
The Make Table Query - For Backups
04:15
The Make Table Query From Multiple Tables Of Data
05:22
Changing Data Using An Update Query
07:06
Update Query With A User Driven Parameter
03:53
Add Records To A Table Using The Append Query
03:46
Delete Records Using The Delete Query
03:51
Backup And Restore Data Using Action Queries
07:08
Section 5: Advanced Form Design
Adding Linked Objects And Displaying On A Form
07:01
Sub Forms Unbound Or Bound
09:00
Using Tabs To Display Multiple Sub Form Data
08:08
Referencing Combo Box Unbound Columns
05:18
The NEW Navigation Forms
04:25
Creating A Form To Use As A Menu Or Dialog
04:01
Adding A Form Button With The Wizard
08:07
Creating Buttons WITHOUT The Wizard
08:37
Open Another Form-Filtered By Current Form (Method 1)
08:04
Open Another Form-Filtered By Current Form (Method 2)
06:56
Building A Search Form
08:56
Check Whether The Search Criteria Is Entered
07:34
Use Double Click To Open Related Data
04:55
Dynamically Changing The Row Source Of A Combo Or List Box
08:16
Section 6: Advanced Reports
Creating A Report From Scratch Without The Wizard
08:39
Adding Images To The Report
04:21
Calculations On A Report
03:39
Sorting And Grouping A Report
10:09
Totals On Reports Groups
06:25
Creating And Adding Sub Reports
10:00
Concatenation With Carriage Returns
08:30
Adding A Chart Or Graph
06:21
A Chart Filtered By The Report Section
06:00
Pie Charts In Reports
08:29
Section 7: Macros
Creating A New Macro
04:10
Example Functionality Of Macros
05:46
Assigning Macros To Buttons On Forms
05:08
Using if In A Macro To Control Program Flow
09:08
Commenting Your Macro Code For Future Reference
02:48
NEW - The Embedded Macro
05:01
Sub Macros And Their Uses
06:16
Trigger A Macro From The Ribbons
07:04
Controlling Startup Actions With The AutoExec Macro
07:49
Creating An AutoKeys Macro For Customizing Keyboard Shortcuts
06:25
Adding An OK/Cancel Confirmation Box
04:31
Section 8: Database Utilities
Compact And Repair - A Useful Utility
02:42
Converting Access To Previous Versions
03:01
Saving A Backup Copy
01:03
Tracking Object Dependencies
04:04
The Start Up Settings
05:19
Section 9: Application Making And Security
Main Menu Tidying Requirements
04:47
Restricted Access By Use Of The ACCDE Format
03:56
Download And Distribute Access 2010 Runtime
02:11
Encrypting And Password Protecting A 2010 Database
04:10
Splitting The Database In Two For Final Security
07:59
Section 10: Access With SQL Server
Upgrade An Existing Application To Use SQL Server
07:29
Linking a New Database To SQL Server
06:37
Introducing The Access Project File
07:21
Running A Stored Procedure From The Access Project
05:28
Section 11: Summary
What Have You Learned?
03:05

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course