Enable Technology

ACCESS LYTHAM URMSTON TRAINING COURSES 

ACCESS TRAINING COURSES LYTHAM URMSTON




About Enable Technology Lytham Urmston Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued Access training manuals they can refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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 Capita Group PLC, Birmingham City Council, Total Telecommunications Limited, Birmingham Heartlands Hospital, DHL Express, Countrywide Homes Limited, National Power PLC and Dollond & Aitchison Limited.




Microsoft Access

  • 2 day course
  • Location: Lytham Urmston
  • Telephone on 01952 938014
  • 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 ...
  • Modifying Forms
    Multi Table Queries
    Getting to Know Access 
    Importing and Exporting Records
    Creating and Using Reports
    Using a Navigation Form
    Adding Transactional Records
    Macros on Forms
    Formatting Tables
    Setting Table Relationships
    Creating and Using Macros
    Creating a Lookup Database
    An Introduction to VBA
    Navigation Pane Protection
    Aggregation Queries
    Data Validation
    Understanding VBA
    Modifying Table Structures
    Database Wellness
    Macro Techniques
    Creating and Using Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lytham Urmston
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Understanding Expressions and Statements
    Using Message Boxes
    Declaring and Creating Object Variables
    Working with the Code Editor
    Understanding Procedures
    Specifying a Recordset Cursor Location - Optional
    Debugging Code
    Creating a Function Procedure
    Understanding Constants
    Understanding Classes and Objects
    Working with Properties
    Declaring Variables
    Working with Methods
    Using Input Boxes
    Using the Do...Loop Structure
    Using the Immediate Window to Call Procedures
    Using the CacheSize Property - Optional
    Why Program in Access?
    Creating a Standard Module

  • See Training Course Details...



Email us about this courses



Other Lytham Urmston Enable Technology Training Courses

JavaScript Lytham Urmston Training Courses
JQuery Lytham Urmston Training Courses
Excel 365 Advanced - Lytham Urmston Excel Training Courses
SQL Lytham Urmston Training Courses
SSAS Tabular Lytham Urmston Training Courses
Excel Power Pivot Lytham Urmston Training Courses