Enable Technology

ACCESS GATESHEAD TRAINING COURSES 

ACCESS TRAINING COURSES GATESHEAD




About Enable Technology Gateshead Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a venue near you in Gateshead. 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 operated primarily in the West Midlands for twenty years. Some of our clients are Vodafone Group Services, Nuclear Engineering Services, Capita Group PLC, Norwich Union PLC, DHL Express, Dollond & Aitchison Limited, National Power PLC and Cadbury PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gateshead
  • 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 ...
  • Specifying a Recordset Cursor Type
    Setting Breakpoints
    Working with Methods
    Working with Variable Lifetime
    Specifying a Recordset Cursor Location - Optional
    Working with Recordsets
    Stepping through Code
    Declaring and Creating Object Variables
    Understanding Control-of-Flow Structures
    Setting Break Expressions
    Debugging Code
    Using Input Boxes
    Working with Properties
    Understanding Procedures
    Understanding Data Types
    Understanding Expressions and Statements
    Understanding the Order of Events
    Understanding Error Handling
    Navigating the Access Object Hierarchy

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Gateshead
  • 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 ...
  • An Introduction to VBA
    Relational Database Design
    Creating and Using Forms
    Formatting Tables
    Adding Records to a Table
    Importing and Exporting Records
    Calculations in Queries
    Data Validation
    Database Wellness
    Creating Queries
    Action Queries
    DIY Forms
    Sorting and Filtering
    Modifying Table Structures
    Parameter Queries
    Multi Table Queries
    Modifying Forms
    Aggregation Queries
    Macros on Forms
    Creating and Using Macros
    Creating and Using Reports

  • See Training Course Details...



Email us about this courses



Other Gateshead Enable Technology Training Courses

TSQL - Gateshead SQL Training Courses
JavaScript Gateshead Training Courses
Excel 365 Basic Gateshead Training Courses
Excel 365 Advanced Gateshead Training Courses
DAX Gateshead Training Courses
SSRS - Gateshead SQL Server Reporting Services Training Courses