Enable Technology



About Enable Technology Northwich Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Northwich. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham City University, Royal Air Force, Countrywide Homes Limited, Barclays Bank PLC, Carillion PLC, Vodafone Group Services, West Bromwich Building Society and Halfords Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Northwich
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Working with Boolean Expressions
    Using the CacheSize Property - Optional
    Handling Errors
    Writing an Error-Handling Routine
    Using Intrinsic Functions
    Calling Procedures
    Specifying a Recordset Cursor Type
    Using the With Statement
    Debugging Code
    Using Expressions, Variables, and Intrinsic Functions
    Declaring Variables
    Using the Do...Loop Structure
    Declaring and Creating Object Variables
    Using Break Mode during Run Mode
    Understanding Errors
    Using Message Boxes
    Understanding Modules
    Understanding Data Types
    Naming Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Northwich
  • 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 ...
  • Querying Techniques
    Relational Database Design
    Calculations in Queries
    Designing a Lookup Database
    Using a Navigation Form
    Creating Queries
    Aggregation Queries
    Macros on Forms
    Navigation Pane Protection
    Action Queries
    Understanding VBA
    An Introduction to VBA
    Data Validation
    Creating a Lookup Database
    Adding Records to a Table
    Formatting Tables
    Setting Table Relationships
    Modifying Forms
    DIY Forms
    Parameter Queries
    Working With Records

  • See Training Course Details...

Email us about this courses

Other Northwich Enable Technology Training Courses

DAX Northwich Training Courses
Excel 365 Advanced - Northwich Excel Training Courses
VBA Northwich Training Courses
Power BI Northwich Training Courses
SSRS - Northwich SQL Server Reporting Services Training Courses
Excel 365 Basic - Northwich Excel Training Courses