Enable Technology

ACCESS AMMANFORD TRAINING COURSES 

ACCESS TRAINING COURSES AMMANFORD




About Enable Technology Ammanford Access Training Courses

Enable Technology provides practical Access skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post 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.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local socially distanced training site. All Access courses can be customised to meet your particular 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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Homeserve PLC, Carillion PLC, Loughborough University, Canadian High Commission, Norwich Union PLC, Lloyds TSB Bank PLC, Barclays Bank PLC and University of Birmingham.




Microsoft Access

  • 2 day course
  • Location: Ammanford
  • 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 ...
  • Data Validation
    Modifying Forms
    Creating and Using Macros
    Getting to Know Access 
    Creating Queries
    Database Wellness
    An Introduction to VBA
    Navigation Pane Protection
    Importing and Exporting Records
    Creating and Using Reports
    Adding Records to a Table
    Multi Table Queries
    Parameter Queries
    Understanding VBA
    Modifying Table Structures
    Designing a Lookup Database
    Action Queries
    Formatting Tables
    Macro Techniques
    Adding Transactional Records
    Creating a Lookup Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ammanford
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Working with Methods
    Using Intrinsic Functions
    Using the For Each...Next Structure
    Understanding VBA's Error Trapping Options
    Understanding Errors
    Working with Inline Error Handling
    Using the With Statement
    Writing an Error-Handling Routine
    Understanding Data Types
    Creating a Standard Module
    Naming Procedures
    Calling Procedures
    Understanding the Order of Events
    Understanding Error Handling
    Creating a Function Procedure
    Using the Immediate Window to Call Procedures
    Understanding Control-of-Flow Structures
    Locking Records for Updating
    Using the Object Browser

  • See Training Course Details...



Email us about this courses



Other Ammanford Enable Technology Training Courses

Power BI - Ammanford Microsoft Power BI Training Courses
SSAS Ammanford Training Courses
SSAS Tabular - Ammanford SQL Server Analysis Services Training Courses
Oracle SQL Ammanford Training Courses
Data Warehouse Ammanford Training Courses
SQL Ammanford Training Courses