Enable Technology

ACCESS OXFORD TRAINING COURSES 

ACCESS TRAINING COURSES OXFORD




About Enable Technology Oxford Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. 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. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Oxford. Every Access course can be modified to meet your bespoke requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have operated primarily in the West Midlands for twenty years. Our clients include: Keele University, Norfolk Police Constabulary, Nuclear Engineering Services, Royal & Sun Alliance Group PLC, Queen's Medical Centre Nottingham, Yell Group PLC, Halfords Group PLC and Capita Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Oxford
  • 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 ...
  • Considering Variable Scope and Lifetime Together
    Working with Methods
    Working with the Code Editor
    Using the For Each...Next Structure
    Using the If...End If Decision Structures
    Understanding Error Handling
    Using Visual Basic Help
    Using Debugging Tools
    Using Intrinsic Constants
    Working with the ADODB Recordset Object
    Working with Recordsets
    Working with Events
    Using the CacheSize Property - Optional
    Understanding Expressions and Statements
    Using Break Mode during Run Mode
    Understanding the Development Environment
    Understanding Control-of-Flow Structures
    Using Message Boxes
    Working with Inline Error Handling
    Working with Variable Scope
    Declaring and Creating Object Variables

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Multi Table Queries
    Sorting and Filtering
    Creating and Using Macros
    Formatting Tables
    Using a Navigation Form
    Data Validation
    Navigation Pane Protection
    Adding Records to a Table
    Importing and Exporting Records
    Getting to Know Access 
    Working With Records
    Designing a Lookup Database
    Creating and Using Forms
    Modifying Table Structures
    Macro Techniques
    Creating Queries
    Action Queries
    Database Wellness
    Querying Techniques
    Creating a Relational Database
    Database Security

  • See Training Course Details...



Email us about this courses



Other Oxford Enable Technology Training Courses

Oracle SQL - Oxford SQL Training Courses
JQuery - Oxford JavaScript Training Courses
Excel Power Pivot Oxford Training Courses
TSQL Oxford Training Courses
SSAS Oxford Training Courses
VBA - Oxford Excel Training Courses