Enable Technology

ACCESS UTTOXETER TRAINING COURSES 

ACCESS TRAINING COURSES UTTOXETER




About Enable Technology Uttoxeter Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. We also offer the option of scheduling of Access course at a venue near you in Uttoxeter. All Access courses can be customised to meet your particular 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.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Birmingham City Council, TalkTalk Direct Limited, Queen's Medical Centre Nottingham, Carillion PLC, EDF Energy PLC, Dollond & Aitchison Limited, DHL Express and Nuclear Engineering Services.




Microsoft Access

  • 2 day course
  • Location: Uttoxeter
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating and Using Macros
    Modifying Table Structures
    Working With Records
    DIY Forms
    Adding Transactional Records
    Calculations in Queries
    Creating and Using Forms
    Creating and Using Reports
    Database Security
    Parameter Queries
    Navigation Pane Protection
    Getting to Know Access 
    Creating a Relational Database
    Querying Techniques
    Modifying Forms
    Using a Navigation Form
    Creating a Lookup Database
    Data Validation
    Relational Database Design
    Database Wellness
    Setting Table Relationships

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uttoxeter
  • 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 ...
  • Using the Object Browser
    Setting Break Expressions
    Guidelines for use of Branching Structures
    Creating a Standard Module
    Using the Do...Loop Structure
    Working with Procedures and Functions
    Working with Events
    Understanding Recordset Cursor Properties - Optional
    Why Program in Access?
    Understanding Collections
    Understanding the Form Object
    Specifying a Recordset Cursor Location - Optional
    Using the For Each...Next Structure
    Calling Procedures
    Understanding VBA's Error Trapping Options
    Considering Variable Scope and Lifetime Together
    Declaring Variables

  • See Training Course Details...



Email us about this courses



Other Uttoxeter Enable Technology Training Courses

Report Builder - Uttoxeter SQL Server Reporting Services Training Courses
SSRS - Uttoxeter SQL Server Reporting Services Training Courses
Excel 365 Advanced - Uttoxeter Excel Training Courses
DAX - Uttoxeter Excel Training Courses
SSAS - Uttoxeter SQL Server Analysis Services Training Courses
Oracle SQL Uttoxeter Training Courses