Enable Technology

ACCESS NATIONAL TRAINING COURSES 

ACCESS TRAINING COURSES NATIONAL




About Enable Technology National Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in National. Every Access course can be modified to meet your bespoke requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Homeserve PLC, Barclays Bank PLC, Norfolk Police Constabulary, Canadian High Commission, Lloyds TSB Bank PLC, Royal & Sun Alliance Group PLC, Birmingham City Council and GKN PLC.




Microsoft Access

  • 2 day course
  • Location: National
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Understanding VBA
    Creating and Using Macros
    Adding Records to a Table
    Querying Techniques
    Parameter Queries
    Creating a Relational Database
    Database Wellness
    Calculations in Queries
    Using a Navigation Form
    Setting Table Relationships
    Aggregation Queries
    Data Validation
    Creating and Using Forms
    Designing a Lookup Database
    Macros on Forms
    Modifying Forms
    Sorting and Filtering
    Relational Database Design
    DIY Forms
    Adding Transactional Records
    Macro Techniques

  • 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 ...
  • Understanding the Err Object
    Understanding Modules
    Declaring and Creating Object Variables
    Understanding the Order of Events
    Working with Variable Scope
    Using the Immediate Window to Call Procedures
    Understanding Classes and Objects
    Specifying a Recordset Cursor Type
    Creating a Sub Procedure
    Understanding Error Handling
    Understanding the DoCmd Object
    Creating a Function Procedure
    Using Break Mode during Run Mode
    Working with Methods
    Locking Records for Updating
    Naming Procedures
    Guidelines for use of Branching Structures
    Using the Do...Loop Structure
    Working with Boolean Expressions

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

Power BI - National Microsoft Power BI Training Courses
SSAS 2014 - National SQL Server Analysis Services Training Courses
Oracle SQL National Training Courses
SSAS 2017 National Training Courses
HTML National Training Courses
Data Mining National Training Courses