Enable Technology

ACCESS WALES TRAINING COURSES 

ACCESS TRAINING COURSES WALES




About Enable Technology Wales Access Training Courses

Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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. We also offer the option of scheduling of Access course at a socially distanced venue near you in Wales. Every Access course can be modified to meet your bespoke requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Canadian High Commission, Nuclear Engineering Services, Fujistu PLC, Capita Group PLC, Birmingham Heartlands Hospital, Keele University, West Bromwich Building Society and University of Birmingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wales
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Navigating the Access Object Hierarchy
    Understanding Control-of-Flow Structures
    Understanding Objects
    Calling Procedures
    Using Intrinsic Constants
    Understanding Recordset Cursor Properties - Optional
    Handling Errors
    Using Message Boxes
    Understanding Expressions and Statements
    Specifying a Recordset Cursor Location - Optional
    Creating a Sub Procedure
    Determining the Value of Expressions
    Setting Breakpoints
    Using the Object Browser
    Using the With Statement
    Using Visual Basic Help
    Using the Do...Loop Structure
    Understanding the DoCmd Object

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Wales
  • 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 ...
  • Importing and Exporting Records
    Working With Records
    Formatting Tables
    Sorting and Filtering
    Understanding VBA
    Creating and Using Forms
    Creating and Using Reports
    Creating Queries
    Macro Techniques
    Action Queries
    Setting Table Relationships
    Calculations in Queries
    Adding Records to a Table
    Relational Database Design
    Modifying Table Structures
    Data Validation
    Database Wellness
    DIY Forms
    Using a Navigation Form
    Parameter Queries
    Navigation Pane Protection

  • See Training Course Details...



Email us about this courses



Other Wales Enable Technology Training Courses

VBA - Wales Excel Training Courses
Excel 365 Advanced - Wales Excel Training Courses
Power Query - Wales Excel Training Courses
Oracle SQL Wales Training Courses
Excel 365 Basic - Wales Excel Training Courses
SSAS Tabular - Wales SQL Server Analysis Services Training Courses