Enable Technology

ACCESS BARNSLEY TRAINING COURSES 

ACCESS TRAINING COURSES BARNSLEY




About Enable Technology Barnsley Access Training Courses

We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant is given Access courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Barnsley. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Keele University, DHL Express, Barclays Bank PLC, Shell UK Oil Products Ltd, Vodafone Group Services, Norwich Union PLC, Countrywide Homes Limited and Nationwide Building Society Limited.




Microsoft Access

  • 2 day course
  • Location: Barnsley
  • Telephone on 01952 305730
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Creating and Using Macros
    Navigation Pane Protection
    Database Security
    Designing a Lookup Database
    Understanding VBA
    Adding Records to a Table
    Setting Table Relationships
    DIY Forms
    Macros on Forms
    Action Queries
    Aggregation Queries
    Formatting Tables
    Data Validation
    Multi Table Queries
    Getting to Know Access 
    Creating a Relational Database
    Database Wellness
    Working With Records
    Sorting and Filtering
    Modifying Forms
    Calculations in Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barnsley
  • 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 ...
  • Working with Variable Lifetime
    Considering Variable Scope and Lifetime Together
    Understanding Expressions and Statements
    Writing an Error-Handling Routine
    Understanding the Form Object
    Understanding Classes and Objects
    Working with Recordsets
    Controlling Program Execution
    Calling Procedures
    Understanding the Err Object
    Organizing Code and Procedures
    Working with Inline Error Handling
    Using the CacheSize Property - Optional
    Working with Events
    Creating a Standard Module
    Introduction to Programming in Access
    Declaring and Creating Object Variables
    Specifying a Recordset Cursor Type
    Understanding Errors
    Understanding the DoCmd Object

  • See Training Course Details...



Email us about this courses



Other Barnsley Enable Technology Training Courses

SSAS 2005 Barnsley Training Courses
Crystal 2011 - Barnsley Crystal Reports Training Courses
Excel Advanced Barnsley Training Courses
PowerPoint Advanced Barnsley Training Courses
Data Mining Barnsley Training Courses
Power BI Barnsley Training Courses



North - Possible Access Training Course Locations


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

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