Enable Technology

ACCESS SOMERSET TRAINING COURSES 

ACCESS TRAINING COURSES SOMERSET




About Enable Technology Somerset Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Somerset. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Keele University, Homeserve PLC, Dollond & Aitchison Limited, Cadbury PLC, Boots UK Limited, Wolverhampton City Council, Birmingham Heartlands Hospital and Birmingham City Council.




Microsoft Access

  • 2 day course
  • Location: Somerset
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Querying Techniques
    Sorting and Filtering
    Relational Database Design
    Getting to Know Access 
    Working With Records
    Understanding VBA
    Calculations in Queries
    Modifying Forms
    Creating a Lookup Database
    Multi Table Queries
    Action Queries
    DIY Forms
    Adding Transactional Records
    Navigation Pane Protection
    Using a Navigation Form
    Aggregation Queries
    Macro Techniques
    An Introduction to VBA
    Data Validation
    Modifying Table Structures
    Database Security

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Somerset
  • 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 ...
  • Working with Recordsets
    Understanding the Development Environment
    Using the With Statement
    Setting Break Expressions
    Debugging Code
    Using Intrinsic Functions
    Understanding Expressions and Statements
    Locking Records for Updating
    Controlling Program Execution
    Creating a Function Procedure
    Specifying a Recordset Cursor Location - Optional
    Using the If...End If Decision Structures
    Setting Breakpoints
    Working with Properties
    Introduction to Programming in Access
    Understanding VBA's Error Trapping Options
    Specifying a Recordset Cursor Type

  • See Training Course Details...



Email us about this courses



Other Somerset Enable Technology Training Courses

PL/SQL - Somerset SQL Training Courses
Report Builder Somerset Training Courses
Power Query Somerset Training Courses
SSIS Somerset Training Courses
Oracle SQL - Somerset SQL Training Courses
DAX - Somerset Excel Training Courses