Enable Technology

ACCESS PYLE TRAINING COURSES 

ACCESS TRAINING COURSES PYLE




About Enable Technology Pyle Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with Access training materials which they keep after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Pyle. All Access courses can be customised to meet your particular requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Keele University, Canadian High Commission, Carillion PLC, Capita Group PLC, Barclays Bank PLC, Yell Group PLC, University of Birmingham and GKN PLC.




Microsoft Access

  • 2 day course
  • Location: Pyle
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Getting to Know Access 
    DIY Forms
    Aggregation Queries
    Importing and Exporting Records
    Sorting and Filtering
    Adding Records to a Table
    Formatting Tables
    An Introduction to VBA
    Database Wellness
    Setting Table Relationships
    Macros on Forms
    Creating a Relational Database
    Macro Techniques
    Modifying Table Structures
    Data Validation
    Understanding VBA
    Using a Navigation Form
    Adding Transactional Records
    Parameter Queries
    Creating and Using Reports
    Designing a Lookup Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Pyle
  • 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 ...
  • Introduction to Programming in Access
    Understanding VBA's Error Trapping Options
    Understanding Errors
    Organizing Code and Procedures
    Declaring Variables
    Creating a Function Procedure
    Using Expressions, Variables, and Intrinsic Functions
    Working with Properties
    Using the Do...Loop Structure
    Working with the Application Object
    Working with Procedures and Functions
    Debugging Code
    Working with Recordsets
    Determining the Value of Expressions
    Using the Immediate Window to Call Procedures
    Setting Break Expressions
    Calling Procedures
    Working with Inline Error Handling
    Using Break Mode during Run Mode
    Understanding Modules
    Understanding the Err Object

  • See Training Course Details...



Email us about this courses



Other Pyle Enable Technology Training Courses

Excel 365 Intermediate - Pyle Excel Training Courses
Excel Power Pivot Pyle Training Courses
DAX Pyle Training Courses
SSAS Pyle Training Courses
JQuery Mobile - Pyle JavaScript Training Courses
Excel 365 Advanced - Pyle Excel Training Courses