Enable Technology

ACCESS TAMWORTH TRAINING COURSES 

ACCESS TRAINING COURSES TAMWORTH




About Enable Technology Tamworth Access Training Courses

We are a company that provides short intensive Access training 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. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We can also deliver the Access course at a socially distanced local training venue in Tamworth. Every Access course can be modified to meet your bespoke requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Capita Group PLC, Royal & Sun Alliance Group PLC, Keele University, Canadian High Commission, Barclays Bank PLC, Countrywide Homes Limited, University of Birmingham and Birmingham Heartlands Hospital.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Tamworth
  • Telephone on 01952 938014
  • 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 ...
  • Stepping through Code
    Navigating the Access Object Hierarchy
    Using Intrinsic Constants
    Calling Procedures
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Objects
    Working with Inline Error Handling
    Working with Procedures and Functions
    Locking Records for Updating
    Determining the Value of Expressions
    Understanding the DoCmd Object
    Setting Break Expressions
    Why Program in Access?
    Working with Variable Scope
    Using Break Mode during Run Mode
    Understanding Error Handling
    Specifying a Recordset Cursor Location - Optional
    Using the With Statement

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Tamworth
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Multi Table Queries
    Formatting Tables
    Creating a Relational Database
    Designing a Lookup Database
    Setting Table Relationships
    Working With Records
    Calculations in Queries
    Macro Techniques
    An Introduction to VBA
    Parameter Queries
    Creating a Lookup Database
    Adding Records to a Table
    Relational Database Design
    Modifying Table Structures
    Modifying Forms
    Action Queries
    Macros on Forms
    Data Validation
    Creating and Using Forms
    Aggregation Queries
    Understanding VBA

  • See Training Course Details...



Email us about this courses



Other Tamworth Enable Technology Training Courses

Excel Power Pivot Tamworth Training Courses
SSRS Tamworth Training Courses
TSQL - Tamworth SQL Training Courses
SQL Tamworth Training Courses
Power Query Tamworth Training Courses
Oracle SQL - Tamworth SQL Training Courses