Enable Technology

ACCESS BATLEY TRAINING COURSES 

ACCESS TRAINING COURSES BATLEY




About Enable Technology Batley Access Training Courses

We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. 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.

Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Batley. All Access courses can be customised to meet your particular requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Unipart Group, Countrywide Homes Limited, Nuclear Engineering Services, Carillion PLC, Aston University, Homeserve PLC, National Power PLC and Nationwide Building Society Limited.




Microsoft Access

  • 2 day course
  • Location: Batley
  • 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 ...
  • Modifying Forms
    Navigation Pane Protection
    An Introduction to VBA
    Creating a Lookup Database
    Parameter Queries
    Relational Database Design
    Creating Queries
    Modifying Table Structures
    Getting to Know Access 
    Sorting and Filtering
    Querying Techniques
    Designing a Lookup Database
    Working With Records
    Macro Techniques
    Creating a Relational Database
    DIY Forms
    Action Queries
    Setting Table Relationships
    Adding Records to a Table
    Aggregation Queries
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Batley
  • Telephone on 01952 305730
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Understanding Data Types
    Using Debugging Tools
    Working with Events
    Understanding the Err Object
    Understanding the Development Environment
    Understanding Recordset Cursor Properties - Optional
    Why Program in Access?
    Understanding the Form Object
    Working with the ADODB Recordset Object
    Using Expressions, Variables, and Intrinsic Functions
    Considering Variable Scope and Lifetime Together
    Understanding Control-of-Flow Structures
    Understanding Constants
    Working with Variable Scope
    Controlling Program Execution
    Creating a Function Procedure
    Working with Procedures and Functions
    Understanding the Order of Events
    Understanding Modules
    Using Message Boxes

  • See Training Course Details...



Email us about this courses



Other Batley Enable Technology Training Courses

SSIS 2008 Batley Training Courses
Crystal 2013 - Batley Crystal Reports Training Courses
SSAS 2008 Batley Training Courses
Project 2016 Batley Training Courses
Data Warehouse - Batley SQL Training Courses
SSRS 2008 - Batley SQL Server Reporting Services Training Courses



North - Possible Access Training Course Locations


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

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