Enable Technology

ACCESS WEDNESBURY TRAINING COURSES 

ACCESS TRAINING COURSES WEDNESBURY




About Enable Technology Wednesbury Access Training Courses

We are a company that provides short intensive Access training courses. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Access course resources that can be referenced post 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. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Wednesbury. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Royal Air Force, Birmingham Heartlands Hospital, TalkTalk Direct Limited, EDF Energy PLC, Lloyds TSB Bank PLC, Canadian High Commission, Keele University and Queen's Medical Centre Nottingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wednesbury
  • 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 ...
  • Understanding Modules
    Using Expressions, Variables, and Intrinsic Functions
    Naming Procedures
    Working with Boolean Expressions
    Working with the ADODB Recordset Object
    Creating a Standard Module
    Working with Properties
    Using the CacheSize Property - Optional
    Declaring Variables
    Trapping Errors with the On Error Statement
    Setting Breakpoints
    Creating a Function Procedure
    Working with Inline Error Handling
    Understanding the DoCmd Object
    Specifying a Recordset Cursor Type
    Using the For Each...Next Structure
    Calling Procedures
    Understanding Error Handling

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Wednesbury
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Macro Techniques
    Understanding VBA
    Formatting Tables
    Using a Navigation Form
    Adding Records to a Table
    Action Queries
    Calculations in Queries
    Designing a Lookup Database
    Database Wellness
    Macros on Forms
    Creating and Using Forms
    Parameter Queries
    Relational Database Design
    Querying Techniques
    Database Security
    Creating Queries
    Creating a Relational Database
    Getting to Know Access 
    Creating and Using Reports
    Modifying Forms
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Wednesbury Enable Technology Training Courses

DAX - Wednesbury Excel Training Courses
SSAS Wednesbury Training Courses
Power Query Wednesbury Training Courses
TSQL - Wednesbury SQL Training Courses
SSAS Tabular - Wednesbury SQL Server Analysis Services Training Courses
JQuery Mobile - Wednesbury JavaScript Training Courses