Enable Technology

ACCESS NATIONAL TRAINING COURSES 

ACCESS TRAINING COURSES NATIONAL




About Enable Technology National Access Training Courses

Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a socially distanced local training venue in National. The Access syllabus can be adjusted and additional topics incorporated if helpful.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are South Staffordshire Water PLC, Boots UK Limited, University of Birmingham, Nationwide Building Society Limited, Barclays Bank PLC, Vodafone Group Services, Total Telecommunications Limited and Royal Air Force.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: National
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Understanding the Development Environment
    Working with Methods
    Understanding Modules
    Organizing Code and Procedures
    Using Message Boxes
    Using Break Mode during Run Mode
    Working with Inline Error Handling
    Working with Procedures and Functions
    Understanding Error Handling
    Creating a Standard Module
    Working with the ADODB Recordset Object
    Handling Errors
    Using the With Statement
    Naming Procedures
    Understanding Data Types
    Using the Do...Loop Structure
    Working with Variable Scope
    Using the CacheSize Property - Optional
    Specifying a Recordset Cursor Location - Optional

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: National
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Creating a Lookup Database
    Relational Database Design
    Database Security
    Getting to Know Access 
    Working With Records
    Creating Queries
    Sorting and Filtering
    Querying Techniques
    Creating and Using Macros
    Creating and Using Forms
    Navigation Pane Protection
    Understanding VBA
    Setting Table Relationships
    Importing and Exporting Records
    Creating a Relational Database
    Action Queries
    Macro Techniques
    Adding Transactional Records
    Modifying Forms
    Parameter Queries
    Creating and Using Reports

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

SQL - National SQL Training Courses
SSAS Tabular National Training Courses
DAX - National Excel Training Courses
Power BI National Training Courses
Excel Power Pivot National Training Courses
SSIS - National SQL Server Integration Services Training Courses