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. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local socially distanced training site in Barnsley. We are happy to discuss customising the course content should you have particular Access training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Capita Group PLC, Norfolk Police Constabulary, Canadian High Commission, Carillion PLC, National Power PLC, South Staffordshire Water PLC, Royal & Sun Alliance Group PLC and Birmingham City University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barnsley
  • 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 ...
  • Using the Do...Loop Structure
    Using Intrinsic Constants
    Specifying a Recordset Cursor Type
    Guidelines for use of Branching Structures
    Declaring Variables
    Working with Events
    Working with Variable Scope
    Understanding Error Handling
    Setting Break Expressions
    Trapping Errors with the On Error Statement
    Creating a Standard Module
    Working with Procedures and Functions
    Using Intrinsic Functions
    Handling Errors
    Determining the Value of Expressions
    Understanding Expressions and Statements
    Using the For...Next Structure
    Working with the Application Object
    Understanding Objects
    Using Expressions, Variables, and Intrinsic Functions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Barnsley
  • Telephone on 01952 938014
  • 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 ...
  • Relational Database Design
    Designing a Lookup Database
    Navigation Pane Protection
    Creating and Using Reports
    Adding Transactional Records
    Multi Table Queries
    DIY Forms
    Parameter Queries
    Database Security
    Creating Queries
    Calculations in Queries
    Adding Records to a Table
    Aggregation Queries
    Creating a Lookup Database
    Modifying Forms
    Macros on Forms
    Database Wellness
    Understanding VBA
    Macro Techniques
    An Introduction to VBA
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Barnsley Enable Technology Training Courses

Report Builder - Barnsley SQL Server Reporting Services Training Courses
SQL - Barnsley SQL Training Courses
Excel 365 Basic Barnsley Training Courses
Excel Power Pivot - Barnsley Excel Training Courses
SSAS Tabular - Barnsley SQL Server Analysis Services Training Courses
DAX Barnsley Training Courses