Enable Technology

ACCESS BOLTON TRAINING COURSES 

ACCESS TRAINING COURSES BOLTON




About Enable Technology Bolton Access Training Courses

Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. 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 Bolton. All Access courses can be customised to meet your particular 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

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are EDF Energy PLC, Birmingham Heartlands Hospital, Capita Group PLC, Countrywide Homes Limited, Shell UK Oil Products Ltd, TalkTalk Direct Limited, Wolverhampton City Council and Canadian High Commission.




Microsoft Access

  • 2 day course
  • Location: Bolton
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Modifying Forms
    Adding Transactional Records
    Action Queries
    An Introduction to VBA
    Creating and Using Macros
    Parameter Queries
    Relational Database Design
    Designing a Lookup Database
    Querying Techniques
    Macros on Forms
    Setting Table Relationships
    Understanding VBA
    Creating a Relational Database
    Creating a Lookup Database
    Creating Queries
    Database Security
    Macro Techniques
    Modifying Table Structures
    Calculations in Queries
    Data Validation
    Importing and Exporting Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bolton
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding Collections
    Working with Events
    Navigating the Access Object Hierarchy
    Using Visual Basic Help
    Understanding Data Types
    Using the Immediate Window to Call Procedures
    Using the For Each...Next Structure
    Specifying a Recordset Cursor Location - Optional
    Creating a Sub Procedure
    Understanding Classes and Objects
    Handling Errors
    Understanding VBA's Error Trapping Options
    Guidelines for use of Branching Structures
    Understanding Control-of-Flow Structures
    Understanding the Err Object
    Using the Do...Loop Structure
    Using the Object Browser
    Working with Inline Error Handling
    Using Intrinsic Constants

  • See Training Course Details...



Email us about this courses



Other Bolton Enable Technology Training Courses

SSIS - Bolton SQL Server Integration Services Training Courses
DAX - Bolton Excel Training Courses
SSRS Bolton Training Courses
PL/SQL Bolton Training Courses
Excel 365 Advanced - Bolton Excel Training Courses
SSAS Tabular - Bolton SQL Server Analysis Services Training Courses