Enable Technology

ACCESS POOLE TRAINING COURSES 

ACCESS TRAINING COURSES POOLE




About Enable Technology Poole Access Training Courses

We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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 Poole. 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.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: DHL Express, Cadbury PLC, Fujistu PLC, Royal & Sun Alliance Group PLC, Nationwide Building Society Limited, Unipart Group, Nuclear Engineering Services and Birmingham City University.




Microsoft Access

  • 2 day course
  • Location: Poole
  • Telephone on 01952 938014
  • 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 ...
  • Database Security
    Relational Database Design
    Database Wellness
    Creating and Using Macros
    Action Queries
    Macros on Forms
    Aggregation Queries
    Understanding VBA
    Creating and Using Reports
    Designing a Lookup Database
    Creating a Relational Database
    An Introduction to VBA
    Modifying Table Structures
    Modifying Forms
    Getting to Know Access 
    Querying Techniques
    Macro Techniques
    Data Validation
    Working With Records
    Setting Table Relationships
    DIY Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Poole
  • Telephone on 01952 938014
  • 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 ...
  • Understanding the Order of Events
    Using Debugging Tools
    Using the For Each...Next Structure
    Understanding the Err Object
    Understanding Data Types
    Declaring and Creating Object Variables
    Stepping through Code
    Understanding the Form Object
    Using the For...Next Structure
    Creating a Function Procedure
    Working with the Code Editor
    Understanding Recordset Cursor Properties - Optional
    Using the Object Browser
    Specifying a Recordset Cursor Type
    Using the Immediate Window to Call Procedures
    Guidelines for use of Branching Structures
    Introduction to Programming in Access
    Working with Boolean Expressions
    Understanding Procedures

  • See Training Course Details...



Email us about this courses



Other Poole Enable Technology Training Courses

Power BI Poole Training Courses
Excel 365 Basic Poole Training Courses
VBA Poole Training Courses
TSQL - Poole SQL Training Courses
SSAS Tabular - Poole SQL Server Analysis Services Training Courses
Excel 365 Intermediate Poole Training Courses