Enable Technology

ACCESS MALVERN TRAINING COURSES 

ACCESS TRAINING COURSES MALVERN




About Enable Technology Malvern Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a socially distanced venue near you in Malvern. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City University, TalkTalk Direct Limited, Vodafone Group Services, Boots UK Limited, Norwich Union PLC, Homeserve PLC, Lloyds TSB Bank PLC and DHL Express.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Malvern
  • 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 ...
  • Locking Records for Updating
    Understanding Collections
    Using Expressions, Variables, and Intrinsic Functions
    Why Program in Access?
    Understanding Constants
    Calling Procedures
    Naming Procedures
    Using Intrinsic Constants
    Navigating the Access Object Hierarchy
    Stepping through Code
    Understanding Error Handling
    Understanding Classes and Objects
    Trapping Errors with the On Error Statement
    Understanding Expressions and Statements
    Specifying a Recordset Cursor Location - Optional
    Using Break Mode during Run Mode
    Organizing Code and Procedures
    Working with Variable Scope
    Using the Do...Loop Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Malvern
  • 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 ...
  • Modifying Forms
    Creating a Lookup Database
    Creating Queries
    Data Validation
    Database Security
    Parameter Queries
    Designing a Lookup Database
    Using a Navigation Form
    Creating and Using Macros
    Getting to Know Access 
    Relational Database Design
    Macro Techniques
    Aggregation Queries
    Adding Records to a Table
    Creating and Using Reports
    Formatting Tables
    Calculations in Queries
    Macros on Forms
    An Introduction to VBA
    Understanding VBA
    Querying Techniques

  • See Training Course Details...



Email us about this courses



Other Malvern Enable Technology Training Courses

Oracle SQL - Malvern SQL Training Courses
JavaScript Malvern Training Courses
Excel Power Pivot - Malvern Excel Training Courses
SSRS - Malvern SQL Server Reporting Services Training Courses
JQuery - Malvern JavaScript Training Courses
Report Builder Malvern Training Courses