Enable Technology

ACCESS BARRY TRAINING COURSES 

ACCESS TRAINING COURSES BARRY




About Enable Technology Barry Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Barry. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norwich Union PLC, Barclays Bank PLC, National Power PLC, Halfords Group PLC, Cadbury PLC, Keele University, Royal & Sun Alliance Group PLC and DHL Express.




Microsoft Access

  • 2 day course
  • Location: Barry
  • Telephone on 01952 938014
  • 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 ...
  • Database Wellness
    Navigation Pane Protection
    Adding Transactional Records
    Parameter Queries
    Creating a Relational Database
    Multi Table Queries
    Relational Database Design
    Creating and Using Reports
    Modifying Forms
    Creating and Using Forms
    Action Queries
    Calculations in Queries
    Adding Records to a Table
    Modifying Table Structures
    Using a Navigation Form
    An Introduction to VBA
    Creating a Lookup Database
    Importing and Exporting Records
    Setting Table Relationships
    Aggregation Queries
    Formatting Tables

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barry
  • 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 ...
  • Understanding the Form Object
    Understanding Procedures
    Understanding the DoCmd Object
    Creating a Sub Procedure
    Handling Errors
    Using Debugging Tools
    Writing an Error-Handling Routine
    Why Program in Access?
    Understanding Constants
    Using the If...End If Decision Structures
    Working with Procedures and Functions
    Working with Variable Lifetime
    Stepping through Code
    Understanding Recordset Cursor Properties - Optional
    Controlling Program Execution
    Guidelines for use of Branching Structures
    Using Break Mode during Run Mode
    Setting Breakpoints

  • See Training Course Details...



Email us about this courses



Other Barry Enable Technology Training Courses

SSRS - Barry SQL Server Reporting Services Training Courses
Excel Power Pivot Barry Training Courses
SSIS Barry Training Courses
DAX Barry Training Courses
SSAS - Barry SQL Server Analysis Services Training Courses
Oracle SQL - Barry SQL Training Courses