Enable Technology

ACCESS BUCKLEY TRAINING COURSES 

ACCESS TRAINING COURSES BUCKLEY




About Enable Technology Buckley Access Training Courses

Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. The Access course could also be scheduled at a socially distanced site near you in Buckley. Every Access course can be modified to meet your bespoke requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Boots UK Limited, Royal & Sun Alliance Group PLC, Wolverhampton City Council, Aston University, Birmingham City University, Unipart Group, South Staffordshire Water PLC and Nationwide Building Society Limited.




Microsoft Access

  • 2 day course
  • Location: Buckley
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating a Lookup Database
    Modifying Forms
    Adding Records to a Table
    Multi Table Queries
    Setting Table Relationships
    Macros on Forms
    Data Validation
    Macro Techniques
    Aggregation Queries
    Adding Transactional Records
    Formatting Tables
    Creating Queries
    Understanding VBA
    Querying Techniques
    Creating and Using Macros
    Using a Navigation Form
    Importing and Exporting Records
    Calculations in Queries
    Getting to Know Access 
    Database Security
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Buckley
  • 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 Variable Scope
    Determining the Value of Expressions
    Using the For Each...Next Structure
    Using the Object Browser
    Declaring and Creating Object Variables
    Locking Records for Updating
    Writing an Error-Handling Routine
    Setting Breakpoints
    Understanding Procedures
    Using Debugging Tools
    Using Message Boxes
    Declaring Variables
    Understanding VBA's Error Trapping Options
    Guidelines for use of Branching Structures
    Working with Variable Lifetime
    Understanding Collections
    Using the With Statement
    Handling Errors
    Working with Methods

  • See Training Course Details...



Email us about this courses



Other Buckley Enable Technology Training Courses

SQL Buckley Training Courses
DAX Buckley Training Courses
SSAS - Buckley SQL Server Analysis Services Training Courses
Excel 365 Basic Buckley Training Courses
SSAS Tabular Buckley Training Courses
SSIS Buckley Training Courses