Advanced Microsoft Access 2010 Tutorial
4.5 (53 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,503 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Microsoft Access 2010 Tutorial to your Wishlist.

Add to Wishlist

Advanced Microsoft Access 2010 Tutorial

Take your Microsoft Access skills to the next level with this Advance Access Tutorial.
4.5 (53 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,503 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Learn Fest Sale
Current price: $10 Original price: $50 Discount: 80% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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

Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 75 Lectures Collapse All 75 Lectures 07:21:13
+
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
5 Lectures 23:03
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
+
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
1 More Section
About the Instructor
Infinite Skills
4.4 Average rating
40,132 Reviews
701,732 Students
331 Courses
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.