Enable Technology

ACCESS CHELTENHAM TRAINING COURSES 

ACCESS TRAINING COURSES CHELTENHAM




About Enable Technology Cheltenham Access Training Courses

We are a company that provides short intensive Access training courses. All Enable Technology tutors are Microsoft certified experts. We will issue each Access training participant with learning resources which they can refer to post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Access courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Cheltenham. All Access courses can be customised to meet your particular requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Dollond & Aitchison Limited, South Staffordshire Water PLC, Queen's Medical Centre Nottingham, Unipart Group, DHL Express, Birmingham City Council, TalkTalk Direct Limited and Homeserve PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cheltenham
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Working with Boolean Expressions
    Using the Immediate Window to Call Procedures
    Specifying a Recordset Cursor Type
    Using Debugging Tools
    Considering Variable Scope and Lifetime Together
    Using Message Boxes
    Using the Select Case...End Select Structure
    Using the Object Browser
    Working with the Application Object
    Introduction to Programming in Access
    Setting Break Expressions
    Working with Variable Scope
    Using the For...Next Structure
    Understanding Expressions and Statements
    Working with Properties
    Understanding Constants
    Using the If...End If Decision Structures
    Understanding VBA's Error Trapping Options
    Working with the ADODB Recordset Object

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Cheltenham
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Parameter Queries
    Database Wellness
    Creating and Using Reports
    Modifying Table Structures
    Aggregation Queries
    Designing a Lookup Database
    Adding Transactional Records
    Creating and Using Macros
    An Introduction to VBA
    Macro Techniques
    Formatting Tables
    Creating a Relational Database
    Action Queries
    Querying Techniques
    Calculations in Queries
    Creating and Using Forms
    Data Validation
    Sorting and Filtering
    Using a Navigation Form
    Creating Queries
    Modifying Forms

  • See Training Course Details...



Email us about this courses



Other Cheltenham Enable Technology Training Courses

SQL - Cheltenham SQL Training Courses
Oracle SQL Cheltenham Training Courses
JQuery Cheltenham Training Courses
SSAS Cheltenham Training Courses
JavaScript - Cheltenham JavaScript Training Courses
Power Query - Cheltenham Excel Training Courses