Enable Technology

ACCESS MOUNTAIN ASH TRAINING COURSES 

ACCESS TRAINING COURSES MOUNTAIN ASH




About Enable Technology Mountain Ash Access Training Courses

We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a Access course will be provided with training materials and practice files to retain after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Mountain Ash. We are happy to discuss customising the course content should you have particular Access 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Nationwide Building Society Limited, Royal & Sun Alliance Group PLC, Halfords Group PLC, Birmingham City University, Barclays Bank PLC, Shell UK Oil Products Ltd, Total Telecommunications Limited and Birmingham City Council.




Microsoft Access

  • 2 day course
  • Location: Mountain Ash
  • 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 ...
  • Data Validation
    DIY Forms
    Parameter Queries
    Understanding VBA
    Modifying Forms
    Creating a Relational Database
    Creating and Using Forms
    Sorting and Filtering
    Adding Records to a Table
    Macro Techniques
    Macros on Forms
    Creating Queries
    Database Security
    Navigation Pane Protection
    Creating and Using Macros
    Database Wellness
    Getting to Know Access 
    Designing a Lookup Database
    Querying Techniques
    Working With Records
    Setting Table Relationships

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Mountain Ash
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Declaring and Creating Object Variables
    Understanding Constants
    Understanding Collections
    Naming Procedures
    Understanding the DoCmd Object
    Why Program in Access?
    Declaring Variables
    Using Expressions, Variables, and Intrinsic Functions
    Setting Breakpoints
    Trapping Errors with the On Error Statement
    Understanding the Form Object
    Working with Methods
    Understanding Data Types
    Using the Object Browser
    Guidelines for use of Branching Structures
    Locking Records for Updating
    Working with Boolean Expressions
    Working with Variable Lifetime
    Writing an Error-Handling Routine

  • See Training Course Details...



Email us about this courses



Other Mountain Ash Enable Technology Training Courses

JQuery Mobile Mountain Ash Training Courses
SSAS Tabular Mountain Ash Training Courses
SSIS - Mountain Ash SQL Server Integration Services Training Courses
SSRS - Mountain Ash SQL Server Reporting Services Training Courses
SSAS Mountain Ash Training Courses
JavaScript Mountain Ash Training Courses