Enable Technology

ACCESS SHREWSBURY TRAINING COURSES 

ACCESS TRAINING COURSES SHREWSBURY




About Enable Technology Shrewsbury 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. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Shrewsbury. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are West Bromwich Building Society, Birmingham Heartlands Hospital, DHL Express, Norfolk Police Constabulary, Countrywide Homes Limited, Homeserve PLC, Norwich Union PLC and Vodafone Group Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Shrewsbury
  • 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 ...
  • Specifying a Recordset Cursor Location - Optional
    Understanding the Err Object
    Naming Procedures
    Why Program in Access?
    Organizing Code and Procedures
    Introduction to Programming in Access
    Creating a Function Procedure
    Declaring Variables
    Working with the Application Object
    Using the Object Browser
    Trapping Errors with the On Error Statement
    Determining the Value of Expressions
    Using the Do...Loop Structure
    Understanding Errors
    Controlling Program Execution
    Using the For Each...Next Structure
    Using Intrinsic Constants
    Understanding Recordset Cursor Properties - Optional
    Using Input Boxes

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Shrewsbury
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Relational Database Design
    An Introduction to VBA
    Modifying Table Structures
    Sorting and Filtering
    Action Queries
    DIY Forms
    Creating and Using Macros
    Parameter Queries
    Setting Table Relationships
    Creating and Using Forms
    Querying Techniques
    Creating Queries
    Adding Transactional Records
    Importing and Exporting Records
    Database Security
    Database Wellness
    Understanding VBA
    Creating a Relational Database
    Navigation Pane Protection
    Formatting Tables
    Aggregation Queries

  • See Training Course Details...



Email us about this courses



Other Shrewsbury Enable Technology Training Courses

TSQL - Shrewsbury SQL Training Courses
Power Query - Shrewsbury Excel Training Courses
PL/SQL - Shrewsbury SQL Training Courses
SSIS Shrewsbury Training Courses
VBA - Shrewsbury Excel Training Courses
Excel 365 Advanced Shrewsbury Training Courses