Enable Technology

ACCESS BARROW-IN-FURNESS TRAINING COURSES 

ACCESS TRAINING COURSES BARROW-IN-FURNESS




About Enable Technology Barrow-in-furness Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials 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.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver Access courses at your site. Another option is we can organise a local training site in Barrow-in-furness. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Boots UK Limited, Barclays Bank PLC, Unipart Group, Lloyds TSB Bank PLC, Wolverhampton City Council, Carillion PLC, Vodafone Group Services and University of Birmingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barrow-in-furness
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Using the Select Case...End Select Structure
    Setting Break Expressions
    Understanding Procedures
    Working with Inline Error Handling
    Creating a Sub Procedure
    Using the CacheSize Property - Optional
    Understanding the Development Environment
    Using the With Statement
    Trapping Errors with the On Error Statement
    Declaring and Creating Object Variables
    Using the Object Browser
    Understanding Constants
    Using Intrinsic Constants
    Understanding Objects
    Declaring Variables
    Introduction to Programming in Access
    Using the For...Next Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Barrow-in-furness
  • 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 ...
  • Designing a Lookup Database
    Working With Records
    An Introduction to VBA
    Creating and Using Macros
    DIY Forms
    Relational Database Design
    Adding Records to a Table
    Macro Techniques
    Macros on Forms
    Understanding VBA
    Creating Queries
    Setting Table Relationships
    Querying Techniques
    Using a Navigation Form
    Creating and Using Reports
    Creating a Relational Database
    Action Queries
    Data Validation
    Aggregation Queries
    Modifying Forms
    Adding Transactional Records

  • See Training Course Details...



Email us about this courses



Other Barrow-in-furness Enable Technology Training Courses

Excel Power Pivot Barrow-in-furness Training Courses
Data Warehouse Barrow-in-furness Training Courses
Power BI - Barrow-in-furness Microsoft Power BI Training Courses
SSIS Barrow-in-furness Training Courses
SQL - Barrow-in-furness SQL Training Courses
Excel 365 Intermediate - Barrow-in-furness Excel Training Courses