Enable Technology

ACCESS PUDSEY TRAINING COURSES 

ACCESS TRAINING COURSES PUDSEY




About Enable Technology Pudsey Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. 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 Cadbury PLC, University of Birmingham, GKN PLC, Loughborough University, West Bromwich Building Society, Aston University, Birmingham City University and Norfolk Police Constabulary.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Pudsey
  • 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 the DoCmd Object
    Using the With Statement
    Working with Recordsets
    Understanding Expressions and Statements
    Using the Select Case...End Select Structure
    Understanding Objects
    Understanding Constants
    Working with Variable Lifetime
    Creating a Standard Module
    Creating a Sub Procedure
    Working with Variable Scope
    Why Program in Access?
    Using the For...Next Structure
    Working with Inline Error Handling
    Trapping Errors with the On Error Statement
    Using the CacheSize Property - Optional
    Understanding Procedures
    Specifying a Recordset Cursor Type
    Understanding Error Handling
    Using Break Mode during Run Mode

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Pudsey
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Creating and Using Forms
    Parameter Queries
    Creating and Using Macros
    Creating a Relational Database
    Designing a Lookup Database
    Relational Database Design
    Macro Techniques
    Formatting Tables
    DIY Forms
    Using a Navigation Form
    Setting Table Relationships
    Navigation Pane Protection
    Database Security
    Multi Table Queries
    Creating and Using Reports
    Creating Queries
    Working With Records
    Importing and Exporting Records
    Calculations in Queries
    Modifying Forms
    Getting to Know Access 

  • See Training Course Details...



Email us about this courses



Other Pudsey Enable Technology Training Courses

JQuery - Pudsey JavaScript Training Courses
Excel Power Pivot Pudsey Training Courses
SQL Pudsey Training Courses
DAX - Pudsey Excel Training Courses
Power Query Pudsey Training Courses
SSAS Pudsey Training Courses