Enable Technology

ACCESS TREHARRIS TRAINING COURSES 

ACCESS TRAINING COURSES TREHARRIS




About Enable Technology Treharris Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We will issue each Access training participant with learning resources which they can refer to post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

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 provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Treharris. The Access syllabus can be adjusted and additional topics incorporated if helpful.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Wolverhampton City Council, Birmingham City University, Boots UK Limited, Barclays Bank PLC, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Countrywide Homes Limited and Birmingham City Council.




Microsoft Access

  • 2 day course
  • Location: Treharris
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Adding Records to a Table
    Sorting and Filtering
    Adding Transactional Records
    Aggregation Queries
    Working With Records
    Calculations in Queries
    Macro Techniques
    An Introduction to VBA
    Setting Table Relationships
    Multi Table Queries
    Creating Queries
    Database Security
    DIY Forms
    Using a Navigation Form
    Getting to Know Access 
    Action Queries
    Querying Techniques
    Creating a Lookup Database
    Parameter Queries
    Relational Database Design
    Navigation Pane Protection

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Treharris
  • 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 Development Environment
    Understanding Procedures
    Understanding Classes and Objects
    Why Program in Access?
    Working with the Code Editor
    Stepping through Code
    Understanding the DoCmd Object
    Understanding Collections
    Working with Recordsets
    Introduction to Programming in Access
    Understanding the Err Object
    Using the With Statement
    Working with Events
    Using Intrinsic Constants
    Working with Variable Lifetime
    Handling Errors
    Calling Procedures
    Working with Boolean Expressions

  • See Training Course Details...



Email us about this courses



Other Treharris Enable Technology Training Courses

Power Query - Treharris Excel Training Courses
SSRS - Treharris SQL Server Reporting Services Training Courses
Data Warehouse - Treharris SQL Training Courses
Power BI Treharris Training Courses
PL/SQL Treharris Training Courses
Excel Power Pivot - Treharris Excel Training Courses