Enable Technology

ACCESS KEIGHLEY TRAINING COURSES 

ACCESS TRAINING COURSES KEIGHLEY




About Enable Technology Keighley 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 course participant will receives course practice files and Access course resources that can be referenced post training. 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. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local socially distanced venue in Keighley. The Access syllabus can be adjusted and additional topics incorporated if helpful.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have over twenty years continuous technical training experience. Our clients include: Aston University, Canadian High Commission, Yell Group PLC, Loughborough University, Total Telecommunications Limited, Capita Group PLC, Keele University and Royal & Sun Alliance Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Keighley
  • Telephone on 01952 305730
  • 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 ...
  • Working with Methods
    Working with Events
    Determining the Value of Expressions
    Understanding the Form Object
    Understanding Error Handling
    Using the If...End If Decision Structures
    Working with Inline Error Handling
    Using Break Mode during Run Mode
    Working with the Code Editor
    Understanding Collections
    Trapping Errors with the On Error Statement
    Using Input Boxes
    Creating a Sub Procedure
    Understanding Data Types
    Working with Recordsets
    Understanding Modules
    Introduction to Programming in Access
    Locking Records for Updating

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Keighley
  • Telephone on 01952 305730
  • 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 ...
  • Database Wellness
    Working With Records
    Adding Transactional Records
    Querying Techniques
    Creating and Using Reports
    Creating a Relational Database
    Aggregation Queries
    Parameter Queries
    Sorting and Filtering
    Calculations in Queries
    Creating Queries
    Setting Table Relationships
    Action Queries
    Macro Techniques
    Navigation Pane Protection
    Designing a Lookup Database
    Multi Table Queries
    Modifying Table Structures
    Understanding VBA
    Creating and Using Forms
    An Introduction to VBA

  • See Training Course Details...



Email us about this courses



Other Keighley Enable Technology Training Courses

SSRS 2016 Keighley Training Courses
Excel Intermediate - Keighley Excel Training Courses
SSIS 2014 - Keighley SQL Server Integration Services Training Courses
Data Warehouse - Keighley SQL Training Courses
Data Mining - Keighley Data Analytics Training Courses
JQuery Mobile - Keighley JavaScript Training Courses



North - Possible Access Training Course Locations


Sheffield Access Training Courses
Halifax Access Training Courses
Scunthorpe Access Training Courses
Newcastle Upon Tyne Access Training Courses
Harrogate Access Training Courses
Castleford Access Training Courses
Sunderland Access Training Courses
Doncaster Access Training Courses
Rotherham Access Training Courses
Huddersfield Access Training Courses
Grimsby Access Training Courses
North East Access Training Courses
Keighley Access Training Courses
Durham Access Training Courses
Barnsley Access Training Courses
Dewsbury Access Training Courses
Scarborough Access Training Courses
South Shields Access Training Courses
Normanton Access Training Courses
Middlesbrough Access Training Courses
Wakefield Access Training Courses
Yorkshire Access Training Courses
Bridlington Access Training Courses
Leeds Access Training Courses
York Access Training Courses
Pudsey Access Training Courses
Hartlepool Access Training Courses
Batley Access Training Courses
Gateshead Access Training Courses
Wetherby Access Training Courses
Hexham Access Training Courses

Sheffield, Halifax, Scunthorpe, Newcastle Upon Tyne, Harrogate, Castleford, Sunderland, Doncaster, Rotherham, Huddersfield, Grimsby, North East, Keighley, Durham, Barnsley, Dewsbury, Scarborough, South Shields, Normanton, Middlesbrough, Wakefield, Yorkshire, Bridlington, Leeds, York, Pudsey, Hartlepool, Batley, Gateshead, Wetherby, Hexham