Microsoft Access Advanced

Learning to use MS Access to its Fullest Extent

Ratings: 3.93 / 5.00




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

What You Will 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

Who Should Attend!

  • Users with a solid understanding of MS Access who want to take their capabilities to an advanced level in a short space of time.