Enable Technology

ACCESS SALISBURY TRAINING COURSES 

ACCESS TRAINING COURSES SALISBURY




About Enable Technology Salisbury Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Salisbury. Every Access course can be modified to meet your bespoke requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can 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: Royal & Sun Alliance Group PLC, Birmingham City Council, Vodafone Group Services, Halfords Group PLC, South Staffordshire Water PLC, Birmingham City University, Cadbury PLC and Queen's Medical Centre Nottingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Salisbury
  • 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 Procedures
    Understanding VBA's Error Trapping Options
    Considering Variable Scope and Lifetime Together
    Declaring Variables
    Controlling Program Execution
    Creating a Function Procedure
    Working with Methods
    Creating a Standard Module
    Stepping through Code
    Understanding the Development Environment
    Specifying a Recordset Cursor Type
    Declaring and Creating Object Variables
    Using the For...Next Structure
    Using Intrinsic Functions
    Working with Properties
    Using Expressions, Variables, and Intrinsic Functions
    Working with Boolean Expressions
    Determining the Value of Expressions
    Understanding Modules
    Setting Break Expressions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Salisbury
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Multi Table Queries
    Data Validation
    Relational Database Design
    Creating and Using Forms
    Setting Table Relationships
    Macros on Forms
    Querying Techniques
    Action Queries
    Creating Queries
    Aggregation Queries
    Adding Records to a Table
    Getting to Know Access 
    Modifying Forms
    Macro Techniques
    Parameter Queries
    An Introduction to VBA
    Creating and Using Macros
    Creating a Lookup Database
    Calculations in Queries
    DIY Forms
    Designing a Lookup Database

  • See Training Course Details...



Email us about this courses



Other Salisbury Enable Technology Training Courses

SSIS - Salisbury SQL Server Integration Services Training Courses
Excel 365 Intermediate Salisbury Training Courses
DAX - Salisbury Excel Training Courses
Excel 365 Advanced - Salisbury Excel Training Courses
SSAS - Salisbury SQL Server Analysis Services Training Courses
Report Builder - Salisbury SQL Server Reporting Services Training Courses