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. The tutor delivering the course will be a Microsoft certified 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.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a venue near you in National. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Birmingham City University, Barclays Bank PLC, Queen's Medical Centre Nottingham, Canadian High Commission, Nationwide Building Society Limited, Birmingham City Council, Homeserve PLC and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: National
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Aggregation Queries
    Using a Navigation Form
    Designing a Lookup Database
    Navigation Pane Protection
    Adding Transactional Records
    Data Validation
    Formatting Tables
    Understanding VBA
    Getting to Know Access 
    An Introduction to VBA
    Importing and Exporting Records
    Creating a Lookup Database
    Modifying Forms
    Relational Database Design
    Querying Techniques
    Action Queries
    Macro Techniques
    Creating and Using Forms
    DIY Forms
    Database Wellness
    Creating Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: National
  • 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 ...
  • Working with Methods
    Considering Variable Scope and Lifetime Together
    Specifying a Recordset Cursor Type
    Setting Break Expressions
    Using the Do...Loop Structure
    Understanding the Form Object
    Using the If...End If Decision Structures
    Guidelines for use of Branching Structures
    Understanding Modules
    Using Expressions, Variables, and Intrinsic Functions
    Using the CacheSize Property - Optional
    Writing an Error-Handling Routine
    Working with the Code Editor
    Using Break Mode during Run Mode
    Declaring Variables
    Creating a Standard Module
    Using the For...Next Structure
    Controlling Program Execution
    Understanding Classes and Objects

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

Oracle SQL - National SQL Training Courses
Excel 365 Intermediate - National Excel Training Courses
SSRS National Training Courses
Power BI National Training Courses
JQuery Mobile National Training Courses
Excel 365 Basic - National Excel Training Courses