Enable Technology

ACCESS NATIONAL TRAINING COURSES 

ACCESS TRAINING COURSES NATIONAL




About Enable Technology National Access Training Courses

We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in National. We are happy to modify the Access syllabus to match your teams training requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Unipart Group, West Bromwich Building Society, Nuclear Engineering Services, Carillion PLC, Keele University, Lloyds TSB Bank PLC, Dollond & Aitchison Limited and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: National
  • Telephone on 01952 305730
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Macros on Forms
    Multi Table Queries
    Importing and Exporting Records
    Parameter Queries
    Setting Table Relationships
    Relational Database Design
    Understanding VBA
    Creating Queries
    Working With Records
    Using a Navigation Form
    Creating and Using Forms
    Modifying Table Structures
    Action Queries
    Designing a Lookup Database
    Navigation Pane Protection
    Creating a Relational Database
    Getting to Know Access 
    Database Security
    Creating and Using Macros
    DIY Forms
    Sorting and Filtering

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: National
  • Telephone on 01952 305730
  • 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 ...
  • Creating a Sub Procedure
    Specifying a Recordset Cursor Location - Optional
    Working with Variable Lifetime
    Writing an Error-Handling Routine
    Setting Break Expressions
    Using Debugging Tools
    Naming Procedures
    Using Input Boxes
    Using the For...Next Structure
    Organizing Code and Procedures
    Understanding Classes and Objects
    Guidelines for use of Branching Structures
    Understanding Error Handling
    Creating a Standard Module
    Setting Breakpoints
    Working with Properties
    Navigating the Access Object Hierarchy

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

Microsoft Project Level 3 - National Microsoft Project Training Courses
SSAS Tabular National Training Courses
Mobile - National Web Development Training Courses
Crystal 2011 National Training Courses
JQuery National Training Courses
SSRS 2008 National Training Courses