Enable Technology

ACCESS LICHFIELD TRAINING COURSES 

ACCESS TRAINING COURSES LICHFIELD




About Enable Technology Lichfield Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. During the Covid 19 crisis we can deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor. Every Access course can me modified to meet your bespoke requirements.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: National Power PLC, GKN PLC, Barclays Bank PLC, Canadian High Commission, Boots UK Limited, South Staffordshire Water PLC, Vodafone Group Services and DHL Express.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lichfield
  • Telephone on 01952 305730
  • 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 ...
  • Stepping through Code
    Understanding the DoCmd Object
    Using the Object Browser
    Working with the ADODB Recordset Object
    Introduction to Programming in Access
    Working with Variable Scope
    Using Intrinsic Functions
    Understanding Errors
    Understanding the Development Environment
    Calling Procedures
    Using Expressions, Variables, and Intrinsic Functions
    Working with Properties
    Understanding Classes and Objects
    Understanding Procedures
    Why Program in Access?
    Locking Records for Updating
    Using Message Boxes
    Handling Errors
    Understanding Modules
    Understanding Error Handling

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Lichfield
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Database Security
    Calculations in Queries
    Creating a Relational Database
    Importing and Exporting Records
    Data Validation
    Aggregation Queries
    Working With Records
    Adding Records to a Table
    Querying Techniques
    Creating and Using Reports
    Designing a Lookup Database
    Creating and Using Macros
    An Introduction to VBA
    Using a Navigation Form
    Relational Database Design
    Setting Table Relationships
    Macro Techniques
    Creating a Lookup Database
    Multi Table Queries
    DIY Forms
    Sorting and Filtering

  • See Training Course Details...



Email us about this courses



Other Lichfield Enable Technology Training Courses

CSS - Lichfield Web Development Training Courses
Oracle SQL - Lichfield SQL Training Courses
PowerPoint Basic Lichfield Training Courses
Excel Intermediate - Lichfield Excel Training Courses
PL/SQL - Lichfield SQL Training Courses
Visio 2013 Lichfield Training Courses



Midlands - Possible Access Training Course Locations


Tamworth, Bridgnorth, Worcestershire, Warwickshire, Oxford, Worcester, Birmingham, Atherstone, Shropshire, Uttoxeter, Lichfield, Burton On Trent, Walsall, Crewe, Rugby, Cheltenham, Black Country, Tipton, Kidsgrove, Smethwick, Wednesbury, Kidderminster, Shrewsbury, Solihull, Cannock, Northhampton, Evesham, Wolverhampton, Rowley, Bromsgrove, Coventry, Newcastle Under Lyme, Staffordshire, Halesowen, Stoke On Trent, Rugeley, Nuneaton, Stafford, Malvern, Sandwell, Redditch, Stourbridge, Leicestershire, Oswestry, Leek, Herefordshire, Hereford, Leicester, Leamington Spa, Bedworth, East Midlands, Milton Keynes, Chester, Droitwich, Telford, Stourbridge, Warwick, Derby, Dudley, Stratford Upon Avon, Nottingham, West Bromwich, Kenilworth, Staffordshire, West Midlands, Midlands