Enable Technology



About Enable Technology Burton On Trent Access Training Courses

We have a twenty year history of providing skills based Access industry training. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a socially distanced local training venue in Burton On Trent. We are happy to discuss customising the course content should you have particular Access training 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 over twenty years continuous technical training experience. Some of our clients are Vodafone Group Services, Total Telecommunications Limited, South Staffordshire Water PLC, Keele University, Nuclear Engineering Services, Carillion PLC, Yell Group PLC and Boots UK Limited.

Microsoft Access

  • 2 day course
  • Location: Burton On Trent
  • 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 ...
  • Setting Table Relationships
    Action Queries
    Querying Techniques
    Understanding VBA
    Macros on Forms
    Using a Navigation Form
    Calculations in Queries
    Adding Transactional Records
    Creating Queries
    Modifying Table Structures
    Database Wellness
    Macro Techniques
    Sorting and Filtering
    Importing and Exporting Records
    Parameter Queries
    Creating a Relational Database
    Modifying Forms
    Designing a Lookup Database
    Navigation Pane Protection
    Creating a Lookup Database
    Data Validation

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Burton On Trent
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Using the CacheSize Property - Optional
    Using the Object Browser
    Using Debugging Tools
    Using the If...End If Decision Structures
    Naming Procedures
    Controlling Program Execution
    Creating a Standard Module
    Setting Breakpoints
    Handling Errors
    Understanding the DoCmd Object
    Stepping through Code
    Using Expressions, Variables, and Intrinsic Functions
    Understanding the Form Object
    Understanding Procedures
    Specifying a Recordset Cursor Location - Optional
    Using the For...Next Structure
    Using Visual Basic Help
    Introduction to Programming in Access
    Declaring and Creating Object Variables

  • See Training Course Details...

Email us about this courses

Other Burton On Trent Enable Technology Training Courses

Excel 365 Advanced Burton On Trent Training Courses
SSRS Burton On Trent Training Courses
JQuery Burton On Trent Training Courses
SSAS - Burton On Trent SQL Server Analysis Services Training Courses
Excel Power Pivot Burton On Trent Training Courses
PL/SQL Burton On Trent Training Courses