Enable Technology

ACCESS SPLOTT TRAINING COURSES 

ACCESS TRAINING COURSES SPLOTT




About Enable Technology Splott Access Training Courses

We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local socially distanced venue in Splott. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Keele University, Shell UK Oil Products Ltd, University of Birmingham, Dollond & Aitchison Limited, GKN PLC, National Power PLC, Vodafone Group Services and Nationwide Building Society Limited.




Microsoft Access

  • 2 day course
  • Location: Splott
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Creating and Using Forms
    Aggregation Queries
    Parameter Queries
    Getting to Know Access 
    Modifying Forms
    Multi Table Queries
    Macro Techniques
    Querying Techniques
    Importing and Exporting Records
    Creating and Using Reports
    Formatting Tables
    Database Security
    Database Wellness
    Calculations in Queries
    Designing a Lookup Database
    Using a Navigation Form
    DIY Forms
    Creating a Lookup Database
    Creating Queries
    Working With Records
    Setting Table Relationships

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Splott
  • 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 ...
  • Locking Records for Updating
    Working with Variable Lifetime
    Understanding Constants
    Understanding the Form Object
    Understanding the DoCmd Object
    Using the CacheSize Property - Optional
    Understanding Errors
    Using the For...Next Structure
    Declaring Variables
    Understanding Procedures
    Using Debugging Tools
    Using the Do...Loop Structure
    Guidelines for use of Branching Structures
    Setting Breakpoints
    Using Intrinsic Constants
    Introduction to Programming in Access
    Creating a Function Procedure
    Understanding Modules
    Debugging Code

  • See Training Course Details...



Email us about this courses



Other Splott Enable Technology Training Courses

SSAS - Splott SQL Server Analysis Services Training Courses
JQuery - Splott JavaScript Training Courses
Power Query Splott Training Courses
VBA - Splott Excel Training Courses
JQuery Mobile - Splott JavaScript Training Courses
DAX Splott Training Courses