Enable Technology

ACCESS LIVERPOOL TRAINING COURSES 

ACCESS TRAINING COURSES LIVERPOOL




About Enable Technology Liverpool Access Training Courses

We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a socially distanced local training venue in Liverpool. We are happy to modify the Access syllabus to match your teams training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Shell UK Oil Products Ltd, Queen's Medical Centre Nottingham, Unipart Group, TalkTalk Direct Limited, South Staffordshire Water PLC, Total Telecommunications Limited, Keele University and Royal & Sun Alliance Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Liverpool
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Specifying a Recordset Cursor Type
    Understanding Data Types
    Considering Variable Scope and Lifetime Together
    Navigating the Access Object Hierarchy
    Understanding the Development Environment
    Using the Immediate Window to Call Procedures
    Locking Records for Updating
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Collections
    Using Intrinsic Functions
    Writing an Error-Handling Routine
    Working with Variable Scope
    Understanding the DoCmd Object
    Creating a Function Procedure
    Understanding Error Handling
    Using Input Boxes
    Controlling Program Execution
    Using Debugging Tools
    Using the If...End If Decision Structures
    Using the Select Case...End Select Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Liverpool
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Database Security
    Database Wellness
    Creating and Using Macros
    Creating Queries
    Sorting and Filtering
    Data Validation
    Importing and Exporting Records
    Macros on Forms
    DIY Forms
    Creating and Using Forms
    Navigation Pane Protection
    Using a Navigation Form
    Creating a Lookup Database
    Multi Table Queries
    Calculations in Queries
    Formatting Tables
    Querying Techniques
    Creating and Using Reports
    Parameter Queries
    Working With Records
    Designing a Lookup Database

  • See Training Course Details...



Email us about this courses



Other Liverpool Enable Technology Training Courses

Power Query Liverpool Training Courses
Power BI Liverpool Training Courses
DAX Liverpool Training Courses
Excel 365 Intermediate Liverpool Training Courses
Report Builder Liverpool Training Courses
JQuery Liverpool Training Courses