Enable Technology

ACCESS MID GLAMORGAN TRAINING COURSES 

ACCESS TRAINING COURSES MID GLAMORGAN




About Enable Technology Mid Glamorgan Access Training Courses

We offer intensive two and three days Access 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. 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.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another way we could deliver the Access course is at a local training site. All Access courses can be customised to meet your particular requirements.

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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Birmingham Heartlands Hospital, Boots UK Limited, Barclays Bank PLC, University of Birmingham, Fujistu PLC, Vodafone Group Services, Carillion PLC and Dollond & Aitchison Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Mid Glamorgan
  • 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 ...
  • Understanding Constants
    Using Message Boxes
    Using the Do...Loop Structure
    Understanding Classes and Objects
    Locking Records for Updating
    Understanding Objects
    Understanding Errors
    Using Expressions, Variables, and Intrinsic Functions
    Working with Methods
    Working with Properties
    Creating a Function Procedure
    Using the Object Browser
    Guidelines for use of Branching Structures
    Understanding Data Types
    Using the Select Case...End Select Structure
    Working with Boolean Expressions
    Using Intrinsic Functions
    Using the With Statement
    Setting Break Expressions
    Calling Procedures
    Understanding the Form Object

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Mid Glamorgan
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating Queries
    Modifying Table Structures
    Data Validation
    Creating and Using Macros
    DIY Forms
    Creating and Using Forms
    Working With Records
    Adding Records to a Table
    Sorting and Filtering
    Modifying Forms
    Creating a Lookup Database
    Relational Database Design
    Getting to Know Access 
    Querying Techniques
    Parameter Queries
    Calculations in Queries
    Multi Table Queries
    Using a Navigation Form
    Aggregation Queries
    Adding Transactional Records
    Macros on Forms

  • See Training Course Details...



Email us about this courses



Other Mid Glamorgan Enable Technology Training Courses

SSAS Mid Glamorgan Training Courses
JavaScript - Mid Glamorgan JavaScript Training Courses
Excel Power Pivot Mid Glamorgan Training Courses
Power BI Mid Glamorgan Training Courses
DAX - Mid Glamorgan Excel Training Courses
Excel 365 Intermediate Mid Glamorgan Training Courses