Enable Technology

ACCESS SHREWSBURY TRAINING COURSES 

ACCESS TRAINING COURSES SHREWSBURY




About Enable Technology Shrewsbury Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We will issue each Access training participant with learning resources which they can refer to post training. 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.

Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Shrewsbury. All Access courses can be customised to meet your particular requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Canadian High Commission, Birmingham Heartlands Hospital, Fujistu PLC, Lloyds TSB Bank PLC, DHL Express, Shell UK Oil Products Ltd, Royal Air Force and Birmingham City University.




Microsoft Access

  • 2 day course
  • Location: Shrewsbury
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Parameter Queries
    Querying Techniques
    Database Wellness
    Modifying Table Structures
    Aggregation Queries
    DIY Forms
    Macros on Forms
    Adding Records to a Table
    Database Security
    Adding Transactional Records
    Navigation Pane Protection
    Using a Navigation Form
    Importing and Exporting Records
    Creating a Lookup Database
    Action Queries
    Creating and Using Macros
    Getting to Know Access 
    Creating a Relational Database
    Designing a Lookup Database
    Sorting and Filtering
    An Introduction to VBA

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Shrewsbury
  • Telephone on 01952 938014
  • 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 ...
  • Understanding the Err Object
    Using Break Mode during Run Mode
    Understanding Expressions and Statements
    Navigating the Access Object Hierarchy
    Using Intrinsic Functions
    Working with the ADODB Recordset Object
    Writing an Error-Handling Routine
    Working with Events
    Using the Immediate Window to Call Procedures
    Using Expressions, Variables, and Intrinsic Functions
    Introduction to Programming in Access
    Creating a Function Procedure
    Declaring Variables
    Setting Breakpoints
    Understanding Classes and Objects
    Why Program in Access?
    Locking Records for Updating
    Creating a Sub Procedure
    Understanding Error Handling

  • See Training Course Details...



Email us about this courses



Other Shrewsbury Enable Technology Training Courses

SQL Shrewsbury Training Courses
SSRS - Shrewsbury SQL Server Reporting Services Training Courses
JavaScript Shrewsbury Training Courses
DAX - Shrewsbury Excel Training Courses
Excel 365 Basic Shrewsbury Training Courses
SSIS - Shrewsbury SQL Server Integration Services Training Courses