Office Productivity
Microsoft
Microsoft Access
Advanced Microsoft Access 2010 Tutorial
4.4 (116 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,813 students enrolled

Advanced Microsoft Access 2010 Tutorial

Take your Microsoft Access skills to the next level with this Advance Access Tutorial.
4.4 (116 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,813 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
English [Auto]
Preview this course
Advanced Microsoft Access 2010 Tutorial
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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

Course content
Expand all 74 lectures 07:09:42
+ – Advanced Table Design
3 lectures 19:21
Creating And Using Input Masks
09:02
Indexing - The Hows And Whys
07:31
Multiple Field Primary Keys
02:48
+ – Advanced Queries
11 lectures 01:06:34
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
+ – Action Queries
7 lectures 35:21
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
+ – Advanced Form Design
14 lectures 01:39:18
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
+ – Advanced Reports
10 lectures 01:12:33
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
+ – Macros
11 lectures 01:04:06
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
+ – Database Utilities
5 lectures 16:09
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
+ – Application Making And Security
4 lectures 18:53
Main Menu Tidying Requirements
04:47
Restricted Access By Use Of The ACCDE Format
03:56
Download And Distribute Access 2010 Runtime
02:11
Splitting The Database In Two For Final Security
07:59
+ – Access With SQL Server
4 lectures 26:55
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