Enable Technology

ACCESS NATIONAL TRAINING COURSES 

ACCESS TRAINING COURSES NATIONAL




About Enable Technology National Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local socially distanced training site in National. All Access courses can be customised to meet your particular 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.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Cadbury PLC, Birmingham Heartlands Hospital, Keele University, University of Birmingham, Birmingham City Council, Aston University, Birmingham City University and West Bromwich Building Society.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: National
  • 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 ...
  • Using Expressions, Variables, and Intrinsic Functions
    Working with Methods
    Using the If...End If Decision Structures
    Navigating the Access Object Hierarchy
    Working with Events
    Working with Variable Lifetime
    Writing an Error-Handling Routine
    Working with Variable Scope
    Understanding Control-of-Flow Structures
    Creating a Standard Module
    Using Input Boxes
    Using Intrinsic Constants
    Using Visual Basic Help
    Trapping Errors with the On Error Statement
    Organizing Code and Procedures
    Understanding VBA's Error Trapping Options
    Using Message Boxes
    Understanding Objects
    Setting Breakpoints
    Specifying a Recordset Cursor Type
    Considering Variable Scope and Lifetime Together

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: National
  • 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 a Lookup Database
    Modifying Forms
    Multi Table Queries
    Designing a Lookup Database
    An Introduction to VBA
    Sorting and Filtering
    Formatting Tables
    Creating and Using Forms
    Macro Techniques
    Database Wellness
    Aggregation Queries
    Database Security
    Parameter Queries
    Macros on Forms
    Modifying Table Structures
    Creating and Using Reports
    Calculations in Queries
    Getting to Know Access 
    Creating and Using Macros
    Navigation Pane Protection
    Adding Transactional Records

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

SSAS Tabular National Training Courses
Data Mining - National Data Analytics Training Courses
TSQL National Training Courses
SSIS 2014 National Training Courses
Oracle SQL - National SQL Training Courses
CSS - National Web Development Training Courses