Enable Technology

ACCESS LANCASHIRE TRAINING COURSES 

ACCESS TRAINING COURSES LANCASHIRE




About Enable Technology Lancashire Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Enable Technology training courses are delivered as instructor led courses. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Lancashire. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: National Power PLC, Nationwide Building Society Limited, GKN PLC, Canadian High Commission, Queen's Medical Centre Nottingham, Barclays Bank PLC, Boots UK Limited and Vodafone Group Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lancashire
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Creating a Standard Module
    Using Visual Basic Help
    Understanding the DoCmd Object
    Understanding Control-of-Flow Structures
    Understanding Modules
    Working with Procedures and Functions
    Naming Procedures
    Working with the Application Object
    Using the Immediate Window to Call Procedures
    Declaring and Creating Object Variables
    Understanding Constants
    Understanding the Err Object
    Using Debugging Tools
    Working with Events
    Trapping Errors with the On Error Statement
    Controlling Program Execution
    Using the Object Browser
    Using the For...Next Structure
    Understanding Expressions and Statements
    Calling Procedures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Lancashire
  • Telephone on 01952 938014
  • 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 ...
  • An Introduction to VBA
    Sorting and Filtering
    Creating and Using Forms
    Using a Navigation Form
    Database Wellness
    Importing and Exporting Records
    Querying Techniques
    Setting Table Relationships
    Macros on Forms
    Designing a Lookup Database
    Action Queries
    Data Validation
    Calculations in Queries
    Navigation Pane Protection
    Aggregation Queries
    Macro Techniques
    Creating Queries
    Database Security
    DIY Forms
    Multi Table Queries
    Understanding VBA

  • See Training Course Details...



Email us about this courses



Other Lancashire Enable Technology Training Courses

Oracle SQL Lancashire Training Courses
Excel 365 Advanced - Lancashire Excel Training Courses
SSRS Lancashire Training Courses
Excel Power Pivot - Lancashire Excel Training Courses
SQL - Lancashire SQL Training Courses
Report Builder Lancashire Training Courses