Enable Technology

ACCESS WOLVERHAMPTON TRAINING COURSES 

ACCESS TRAINING COURSES WOLVERHAMPTON




About Enable Technology Wolverhampton Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology training courses are delivered as instructor led courses. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a socially distanced local training venue in Wolverhampton. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training 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

We have operated primarily in the West Midlands for twenty years. Some of our clients are Fujistu PLC, Homeserve PLC, GKN PLC, Carillion PLC, Birmingham City Council, Boots UK Limited, Norwich Union PLC and Nationwide Building Society Limited.




Microsoft Access

  • 2 day course
  • Location: Wolverhampton
  • 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 ...
  • DIY Forms
    Creating and Using Reports
    Calculations in Queries
    Setting Table Relationships
    Macro Techniques
    Modifying Table Structures
    Importing and Exporting Records
    Adding Transactional Records
    Querying Techniques
    Creating a Lookup Database
    Creating a Relational Database
    Creating and Using Forms
    Getting to Know Access 
    Action Queries
    Sorting and Filtering
    Creating and Using Macros
    An Introduction to VBA
    Macros on Forms
    Multi Table Queries
    Working With Records
    Understanding VBA

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wolverhampton
  • 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 ...
  • Organizing Code and Procedures
    Navigating the Access Object Hierarchy
    Handling Errors
    Creating a Function Procedure
    Specifying a Recordset Cursor Type
    Considering Variable Scope and Lifetime Together
    Using Input Boxes
    Working with Procedures and Functions
    Controlling Program Execution
    Understanding Objects
    Setting Break Expressions
    Understanding Expressions and Statements
    Debugging Code
    Understanding Error Handling
    Using the For...Next Structure
    Setting Breakpoints
    Trapping Errors with the On Error Statement
    Working with Variable Lifetime
    Calling Procedures
    Using Intrinsic Functions

  • See Training Course Details...



Email us about this courses



Other Wolverhampton Enable Technology Training Courses

SSRS - Wolverhampton SQL Server Reporting Services Training Courses
SQL - Wolverhampton SQL Training Courses
VBA - Wolverhampton Excel Training Courses
TSQL - Wolverhampton SQL Training Courses
SSAS Wolverhampton Training Courses
Data Warehouse Wolverhampton Training Courses