Enable Technology

ACCESS KEIGHLEY TRAINING COURSES 

ACCESS TRAINING COURSES KEIGHLEY




About Enable Technology Keighley Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. The Access course could also be scheduled at a socially distanced site near you in Keighley. Every Access course can be modified to meet your bespoke requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Vodafone Group Services, Carillion PLC, Aston University, West Bromwich Building Society, Norfolk Police Constabulary, Homeserve PLC, Wolverhampton City Council and Halfords Group PLC.




Microsoft Access

  • 2 day course
  • Location: Keighley
  • 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 ...
  • DIY Forms
    Creating Queries
    Understanding VBA
    Modifying Forms
    Parameter Queries
    Adding Records to a Table
    Calculations in Queries
    Adding Transactional Records
    Creating and Using Macros
    Macro Techniques
    Creating a Relational Database
    Querying Techniques
    Sorting and Filtering
    Importing and Exporting Records
    An Introduction to VBA
    Creating and Using Reports
    Multi Table Queries
    Data Validation
    Designing a Lookup Database
    Getting to Know Access 
    Relational Database Design

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Keighley
  • 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 ...
  • Understanding Error Handling
    Writing an Error-Handling Routine
    Understanding the Err Object
    Debugging Code
    Using Intrinsic Functions
    Using Intrinsic Constants
    Using the Object Browser
    Working with Events
    Using the CacheSize Property - Optional
    Creating a Function Procedure
    Trapping Errors with the On Error Statement
    Understanding Constants
    Understanding Classes and Objects
    Working with the Application Object
    Working with Boolean Expressions
    Understanding Collections
    Using the Immediate Window to Call Procedures
    Introduction to Programming in Access
    Setting Break Expressions

  • See Training Course Details...



Email us about this courses



Other Keighley Enable Technology Training Courses

Data Warehouse - Keighley SQL Training Courses
JQuery Keighley Training Courses
Excel 365 Advanced Keighley Training Courses
Report Builder Keighley Training Courses
SSIS Keighley Training Courses
JavaScript Keighley Training Courses