Enable Technology

ACCESS SWANSEA TRAINING COURSES 

ACCESS TRAINING COURSES SWANSEA




About Enable Technology Swansea Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Access courseware which they can refer to after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a socially distanced venue near you in Swansea. We are happy to discuss customising the course content should you have particular Access training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Lloyds TSB Bank PLC, West Bromwich Building Society, University of Birmingham, Nuclear Engineering Services, Countrywide Homes Limited, Vodafone Group Services, Total Telecommunications Limited and Carillion PLC.




Microsoft Access

  • 2 day course
  • Location: Swansea
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Calculations in Queries
    Creating and Using Forms
    Parameter Queries
    Understanding VBA
    Database Security
    Creating a Lookup Database
    Getting to Know Access 
    An Introduction to VBA
    Creating and Using Reports
    Querying Techniques
    Importing and Exporting Records
    Formatting Tables
    DIY Forms
    Modifying Table Structures
    Creating Queries
    Data Validation
    Navigation Pane Protection
    Macro Techniques
    Relational Database Design
    Sorting and Filtering
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Swansea
  • 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 ...
  • Navigating the Access Object Hierarchy
    Understanding the DoCmd Object
    Using Message Boxes
    Calling Procedures
    Creating a Function Procedure
    Working with Recordsets
    Working with the Application Object
    Trapping Errors with the On Error Statement
    Understanding Errors
    Organizing Code and Procedures
    Working with the ADODB Recordset Object
    Guidelines for use of Branching Structures
    Using Intrinsic Constants
    Understanding Collections
    Using the With Statement
    Working with Variable Scope
    Using the Immediate Window to Call Procedures
    Handling Errors
    Writing an Error-Handling Routine
    Creating a Sub Procedure

  • See Training Course Details...



Email us about this courses



Other Swansea Enable Technology Training Courses

TSQL - Swansea SQL Training Courses
Report Builder - Swansea SQL Server Reporting Services Training Courses
Excel 365 Intermediate - Swansea Excel Training Courses
VBA - Swansea Excel Training Courses
SSIS Swansea Training Courses
SSAS Tabular Swansea Training Courses