Microsoft Access Advanced
3.6 (10 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,355 students enrolled

Microsoft Access Advanced

Learning to use MS Access to its Fullest Extent
3.6 (10 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,355 students enrolled
Created by ZandaX Training
Last updated 3/2019
English
English [Auto]
Current price: $97.99 Original price: $139.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 downloadable resources
  • 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
What you'll learn
  • Main subject modules for our Microsoft Access Advanced course:
  • Advanced Data Management - Advanced Form Tasks - Automating Reports
  • SQL and Microsoft Access - Macros and Visual Basic for Applications (VBA) - Finishing the Application
  • Full module details:
  • Advanced Data Management - Referential Integrity - Table Relationships - An Introduction to SQL - Modal Dialog Boxes
  • Advanced Form Tasks - Using Subforms - Creating a Navigation Form - Advanced Form Controls - Exporting a Form - Other Form Tasks
  • Automating Reports - Creating the Report Form - Building Query Criteria
  • SQL and Microsoft Access - Understanding SQL - Using the SELECT Statement - Using Subqueries - Using SQL Joins
  • Macros and Visual Basic for Applications (VBA) - Access and VBA - Building Advanced Procedures - Using VBA in a Database
  • Finishing the Application - Setting Start Up Options - Sharing/Splitting the Database - Creating an ACCDE - Encrypting the Database with a Password
Requirements
  • Some of the lessons are quite technical, so you MUST have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Description

MODULE 1:  Advanced Data Management

Learning outcomes: A look into table relationships and referential integrity along  with introducing SQL, the language database professionals use to manage a  database.

Topics covered:

  • Referential Integrity

  • Table Relationships

  • An Introduction to SQL

  • Modal Dialog Boxes

MODULE 2:  Advanced Form Tasks

Learning outcomes: Creating navigation forms and sub-forms along with some of the  advanced form controls necessary to create a fully rounded user  interface.

Topics covered:

  • Using Subforms

  • Creating a Navigation Form

  • Advanced Form Controls

  • Exporting a Form

  • Other Form Tasks

MODULE 3:  Automating Reports

Learning outcomes:  Create Reports in Access that can return data quickly by using a  form to control and launch reports. Look at modifying form properties  including combo boxes and link a query to a form.

Topics covered:

  • Creating the Report Form

  • Building Query Criteria

MODULE 4:  SQL and Microsoft Access

Learning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.

Topics covered:

  • Understanding SQL

  • Using the SELECT Statement

  • Using Subqueries

  • Using SQL Joins

MODULE 5:  Macros and Visual Basic for Applications (VBA)

Learning outcomes:  Using Macros and Visual Basic to create some advanced functionality to your Access Database.

Topics covered:

  • Macro Basics

  • More about Macros

  • Access and VBA

  • Building Advanced Procedures

  • Using VBA in a Database

MODULE 6:  Finishing the Application

Learning outcomes:  Look at finishing touches to control how users interact with a  database using start-up and sharing options. Identify security measures  by creating an ACCDE and encrypting a database with a password.

Topics covered:

  • Setting Start Up Options

  • Sharing/Splitting the Database

  • Creating an ACCDE

  • Encrypting the Database with a Password

Who this course is for:
  • Users with a solid understanding of MS Access who want to take their capabilities to an advanced level in a short space of time.
Course content
Expand all 44 lectures 02:20:11
+ Advanced Form Tasks
10 lectures 33:48
Introduction
01:01
Using Subforms - Overview
00:48
Using Subforms
04:48
Creating a Navigation Form - Overview
00:36
Creating a Navigation Form
09:18
Advanced Form Controls - Overview
01:07
Advanced Form Controls
05:43
Advanced Form Controls
04:55
Exporting a Form - Overview
00:49
Exporting a Form
04:43
+ Automating Reports
4 lectures 10:37
Introduction
01:00
Creating the Report Form - Overview
00:32
Building Query Criteria - Overview
00:49
Creating the Report Form
08:16
+ SQL and Microsoft Access
6 lectures 23:21
Introduction
01:22
Understanding SQL - Overview
02:15
Using the SELECT Statement - Overview
01:35
Using the SELECT Statement
08:15
Using SQL Joins - Overview
01:59
Using SQL Joins
07:55
+ Macros and Visual Basic for Applications (VBA)
7 lectures 21:59
Introduction
01:15
Access and VBA - Overview
01:00
Access and VBA
06:55
Building Advanced Procedures - Overview
01:07
Building Advanced Procedures
04:42
Using VBA in a Database - Overview
01:13
Using VBA in a Database
05:47
+ Finishing the Application
9 lectures 23:14
Introduction
01:01
Setting Start Up Options - Overview
00:58
Setting Start Up Options
06:44
Sharing/Splitting the Database - Overview
01:28
Sharing/Splitting the Database
02:45
Creating an ACCDE - Overview
01:10
Creating an ACCDE
04:39
Encrypting the Database with a Password - Overview
00:44
Encrypting the Database with a Password
03:45