Enable Technology

ACCESS CHIPPENHAM TRAINING COURSES 

ACCESS TRAINING COURSES CHIPPENHAM




About Enable Technology Chippenham Access Training Courses

Enable Technology provides practical Access skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Chippenham. We are happy to modify the Access syllabus to match your teams training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Halfords Group PLC, Yell Group PLC, Vodafone Group Services, Keele University, University of Birmingham, Unipart Group, TalkTalk Direct Limited and Loughborough University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Chippenham
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Using the CacheSize Property - Optional
    Setting Break Expressions
    Using the Do...Loop Structure
    Controlling Program Execution
    Using the For...Next Structure
    Using the If...End If Decision Structures
    Understanding Classes and Objects
    Determining the Value of Expressions
    Working with Recordsets
    Guidelines for use of Branching Structures
    Navigating the Access Object Hierarchy
    Understanding Error Handling
    Understanding VBA's Error Trapping Options
    Writing an Error-Handling Routine
    Using the For Each...Next Structure
    Using Debugging Tools
    Organizing Code and Procedures
    Handling Errors

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Chippenham
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Relational Database Design
    Data Validation
    Working With Records
    Setting Table Relationships
    Multi Table Queries
    Action Queries
    Creating a Relational Database
    Database Wellness
    Modifying Forms
    Formatting Tables
    Macro Techniques
    Importing and Exporting Records
    Aggregation Queries
    Adding Transactional Records
    Creating and Using Reports
    Creating a Lookup Database
    Macros on Forms
    DIY Forms
    Using a Navigation Form
    Designing a Lookup Database
    Navigation Pane Protection

  • See Training Course Details...



Email us about this courses



Other Chippenham Enable Technology Training Courses

SSAS Tabular - Chippenham SQL Server Analysis Services Training Courses
Excel Power Pivot Chippenham Training Courses
TSQL - Chippenham SQL Training Courses
SSAS - Chippenham SQL Server Analysis Services Training Courses
JQuery - Chippenham JavaScript Training Courses
PL/SQL Chippenham Training Courses