Enable Technology

ACCESS HEXHAM TRAINING COURSES 

ACCESS TRAINING COURSES HEXHAM




About Enable Technology Hexham Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. The Access course could also be scheduled at a socially distanced site near you in Hexham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Total Telecommunications Limited, Carillion PLC, Cadbury PLC, West Bromwich Building Society, Lloyds TSB Bank PLC, South Staffordshire Water PLC, Royal & Sun Alliance Group PLC and Royal Air Force.




Microsoft Access

  • 2 day course
  • Location: Hexham
  • 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
    Creating and Using Macros
    Modifying Table Structures
    Sorting and Filtering
    Database Wellness
    An Introduction to VBA
    Creating and Using Reports
    Calculations in Queries
    Macro Techniques
    Adding Records to a Table
    Multi Table Queries
    Creating and Using Forms
    Designing a Lookup Database
    Creating a Lookup Database
    Adding Transactional Records
    DIY Forms
    Modifying Forms
    Creating Queries
    Macros on Forms
    Formatting Tables
    Relational Database Design

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Hexham
  • 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 Debugging Tools
    Using the Do...Loop Structure
    Working with Recordsets
    Using the Object Browser
    Using the With Statement
    Handling Errors
    Determining the Value of Expressions
    Using Message Boxes
    Understanding Error Handling
    Understanding VBA's Error Trapping Options
    Declaring Variables
    Understanding the Form Object
    Understanding Objects
    Declaring and Creating Object Variables
    Working with the Application Object
    Creating a Function Procedure
    Understanding Procedures
    Working with Properties
    Understanding Constants
    Writing an Error-Handling Routine

  • See Training Course Details...



Email us about this courses



Other Hexham Enable Technology Training Courses

JQuery Hexham Training Courses
JQuery Mobile Hexham Training Courses
SSRS - Hexham SQL Server Reporting Services Training Courses
SSAS Hexham Training Courses
Power BI Hexham Training Courses
SSAS Tabular Hexham Training Courses