Enable Technology

ACCESS STAFFORDSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES STAFFORDSHIRE




About Enable Technology Staffordshire Access Training Courses

Enable Technology specialise in succinct skills based Access training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training Access resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the Access course at a socially distanced local training venue in Staffordshire. We are happy to modify the Access syllabus to match your teams training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Total Telecommunications Limited, Loughborough University, Norfolk Police Constabulary, Wolverhampton City Council, Vodafone Group Services, West Bromwich Building Society, Nationwide Building Society Limited and Cadbury PLC.




Microsoft Access

  • 2 day course
  • Location: Staffordshire
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Parameter Queries
    Formatting Tables
    An Introduction to VBA
    Creating a Relational Database
    Adding Records to a Table
    Data Validation
    Modifying Forms
    Understanding VBA
    Sorting and Filtering
    Creating a Lookup Database
    Action Queries
    Modifying Table Structures
    Creating Queries
    Aggregation Queries
    Macro Techniques
    Setting Table Relationships
    Navigation Pane Protection
    DIY Forms
    Adding Transactional Records
    Database Wellness
    Querying Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Staffordshire
  • 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 ...
  • Working with Recordsets
    Working with Properties
    Using Input Boxes
    Understanding Control-of-Flow Structures
    Using Intrinsic Functions
    Declaring and Creating Object Variables
    Working with Boolean Expressions
    Using Intrinsic Constants
    Controlling Program Execution
    Working with the Application Object
    Using the Do...Loop Structure
    Using the For Each...Next Structure
    Guidelines for use of Branching Structures
    Working with Procedures and Functions
    Understanding Expressions and Statements
    Locking Records for Updating
    Calling Procedures
    Understanding Constants
    Organizing Code and Procedures
    Working with Methods
    Using the Object Browser

  • See Training Course Details...



Email us about this courses



Other Staffordshire Enable Technology Training Courses

Excel 365 Intermediate - Staffordshire Excel Training Courses
SSIS Staffordshire Training Courses
JavaScript - Staffordshire JavaScript Training Courses
PL/SQL Staffordshire Training Courses
Excel 365 Advanced - Staffordshire Excel Training Courses
SSAS Tabular - Staffordshire SQL Server Analysis Services Training Courses