Enable Technology

ACCESS GLOUCESTER TRAINING COURSES 

ACCESS TRAINING COURSES GLOUCESTER




About Enable Technology Gloucester Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams 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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Keele University, Barclays Bank PLC, Halfords Group PLC, South Staffordshire Water PLC, Queen's Medical Centre Nottingham, Wolverhampton City Council, Countrywide Homes Limited and Lloyds TSB Bank PLC.




Microsoft Access

  • 2 day course
  • Location: Gloucester
  • 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 ...
  • Database Security
    Relational Database Design
    Database Wellness
    Designing a Lookup Database
    Importing and Exporting Records
    Navigation Pane Protection
    DIY Forms
    Using a Navigation Form
    Working With Records
    Creating a Relational Database
    Sorting and Filtering
    An Introduction to VBA
    Parameter Queries
    Formatting Tables
    Modifying Forms
    Calculations in Queries
    Data Validation
    Multi Table Queries
    Creating Queries
    Modifying Table Structures
    Creating and Using Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gloucester
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding the Form Object
    Organizing Code and Procedures
    Using the Do...Loop Structure
    Declaring Variables
    Understanding the Development Environment
    Using the Object Browser
    Navigating the Access Object Hierarchy
    Determining the Value of Expressions
    Naming Procedures
    Understanding Recordset Cursor Properties - Optional
    Using Visual Basic Help
    Understanding VBA's Error Trapping Options
    Understanding Classes and Objects
    Declaring and Creating Object Variables
    Why Program in Access?
    Understanding Collections
    Understanding Data Types
    Stepping through Code

  • See Training Course Details...



Email us about this courses



Other Gloucester Enable Technology Training Courses

SQL - Gloucester SQL Training Courses
SSIS Gloucester Training Courses
SSAS - Gloucester SQL Server Analysis Services Training Courses
Data Warehouse - Gloucester SQL Training Courses
JavaScript - Gloucester JavaScript Training Courses
DAX Gloucester Training Courses