Enable Technology

ACCESS MANCHESTER TRAINING COURSES 

ACCESS TRAINING COURSES MANCHESTER




About Enable Technology Manchester Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Shell UK Oil Products Ltd, Keele University, Carillion PLC, National Power PLC, Wolverhampton City Council, Yell Group PLC, Halfords Group PLC and Norfolk Police Constabulary.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Manchester
  • Telephone on 01952 938014
  • 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 ...
  • Specifying a Recordset Cursor Type
    Working with Variable Scope
    Understanding Control-of-Flow Structures
    Working with the Application Object
    Creating a Sub Procedure
    Understanding the Order of Events
    Writing an Error-Handling Routine
    Setting Breakpoints
    Understanding Error Handling
    Working with the ADODB Recordset Object
    Understanding Constants
    Understanding the Err Object
    Stepping through Code
    Using Debugging Tools
    Understanding Modules
    Using Intrinsic Constants
    Understanding Procedures
    Using the CacheSize Property - Optional
    Locking Records for Updating
    Considering Variable Scope and Lifetime Together

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Manchester
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Setting Table Relationships
    Multi Table Queries
    Using a Navigation Form
    Data Validation
    Adding Transactional Records
    Macro Techniques
    Getting to Know Access 
    Action Queries
    Sorting and Filtering
    Calculations in Queries
    Creating Queries
    Understanding VBA
    DIY Forms
    Aggregation Queries
    Importing and Exporting Records
    Creating and Using Reports
    Querying Techniques
    Designing a Lookup Database
    An Introduction to VBA
    Modifying Table Structures
    Creating a Relational Database

  • See Training Course Details...



Email us about this courses



Other Manchester Enable Technology Training Courses

SQL - Manchester SQL Training Courses
VBA Manchester Training Courses
JQuery Manchester Training Courses
TSQL - Manchester SQL Training Courses
Excel 365 Basic Manchester Training Courses
SSAS - Manchester SQL Server Analysis Services Training Courses