Training in Access from Activia

Microsoft Access Advanced

A 1-Day Training Course

Course Content

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.

Who Should Attend

Users with a solid understanding of MS Access 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Some of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Course Outline
This course is a 1-day training course structured into 6 modules.
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
  • Module 5
    Automating With Visual Basic for Applications (VBA)
    Learning outcomes
    Using Macros and Visual Basic to create some advanced functionality to your Access Database.
    Topics covered
  • Building Advanced Procedures
  • 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

  • Activia Training :   Training courses for business at twelve locations UK wide