Enable Technology

ACCESS BEDWAS TRAINING COURSES 

ACCESS TRAINING COURSES BEDWAS




About Enable Technology Bedwas Access Training Courses

We are a company that provides short intensive Access training courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.

Courses are instructor led and groups sizes small. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a local training venue in Bedwas. Every Access course can be modified to meet your bespoke requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Yell Group PLC, Barclays Bank PLC, Loughborough University, Fujistu PLC, West Bromwich Building Society, South Staffordshire Water PLC, GKN PLC and Total Telecommunications Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bedwas
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Understanding VBA's Error Trapping Options
    Using the Immediate Window to Call Procedures
    Working with the Application Object
    Handling Errors
    Introduction to Programming in Access
    Understanding the Development Environment
    Working with Properties
    Working with the Code Editor
    Understanding Errors
    Guidelines for use of Branching Structures
    Understanding Constants
    Naming Procedures
    Working with Inline Error Handling
    Using the Object Browser
    Using the With Statement
    Working with Methods
    Working with Procedures and Functions
    Trapping Errors with the On Error Statement
    Using the Do...Loop Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Bedwas
  • 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 ...
  • Macros on Forms
    Creating and Using Forms
    Importing and Exporting Records
    Designing a Lookup Database
    Macro Techniques
    Adding Transactional Records
    Aggregation Queries
    Using a Navigation Form
    Creating and Using Macros
    Calculations in Queries
    Understanding VBA
    Adding Records to a Table
    Formatting Tables
    Modifying Table Structures
    Getting to Know Access 
    Setting Table Relationships
    Creating Queries
    Action Queries
    Creating a Relational Database
    DIY Forms
    An Introduction to VBA

  • See Training Course Details...



Email us about this courses



Other Bedwas Enable Technology Training Courses

PL/SQL Bedwas Training Courses
Power BI - Bedwas Microsoft Power BI Training Courses
VBA Bedwas Training Courses
Excel 365 Intermediate Bedwas Training Courses
TSQL Bedwas Training Courses
JavaScript - Bedwas JavaScript Training Courses