Enable Technology

ACCESS SOUTHPORT TRAINING COURSES 

ACCESS TRAINING COURSES SOUTHPORT




About Enable Technology Southport Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Access courses are taught by a Microsoft Certified Solutions Expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. The Access course could also be scheduled at a socially distanced site near you in Southport. All Access courses can be customised to meet your particular requirements.

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.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Keele University, Carillion PLC, Aston University, Shell UK Oil Products Ltd, University of Birmingham, Canadian High Commission, Unipart Group and Royal & Sun Alliance Group PLC.




Microsoft Access

  • 2 day course
  • Location: Southport
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Action Queries
    Database Security
    Multi Table Queries
    Creating and Using Macros
    Aggregation Queries
    Modifying Forms
    Getting to Know Access 
    Adding Records to a Table
    Macros on Forms
    Data Validation
    Understanding VBA
    Database Wellness
    Relational Database Design
    An Introduction to VBA
    Sorting and Filtering
    Macro Techniques
    Modifying Table Structures
    Working With Records
    Calculations in Queries
    Navigation Pane Protection
    Importing and Exporting Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Southport
  • Telephone on 01952 305730
  • 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 ...
  • Using Intrinsic Functions
    Using the For...Next Structure
    Using Message Boxes
    Writing an Error-Handling Routine
    Trapping Errors with the On Error Statement
    Understanding Procedures
    Working with Methods
    Considering Variable Scope and Lifetime Together
    Using the Do...Loop Structure
    Locking Records for Updating
    Using Intrinsic Constants
    Navigating the Access Object Hierarchy
    Understanding Modules
    Understanding Objects
    Working with Procedures and Functions
    Declaring and Creating Object Variables
    Working with the ADODB Recordset Object
    Understanding Expressions and Statements
    Specifying a Recordset Cursor Type
    Understanding Control-of-Flow Structures

  • See Training Course Details...



Email us about this courses



Other Southport Enable Technology Training Courses

Project 2016 - Southport Microsoft Project Training Courses
SSAS 2005 Southport Training Courses
SSRS 2005 - Southport SQL Server Reporting Services Training Courses
Crystal 2011 - Southport Crystal Reports Training Courses
HTML Southport Training Courses
SSAS Tabular Southport Training Courses



North West - Possible Access Training Course Locations


Middleton Access Training Courses
Macclesfield Access Training Courses
Blackpool Access Training Courses
Lancaster Access Training Courses
Bury Access Training Courses
Carlisle Access Training Courses
Saddleworth Access Training Courses
Crewe Access Training Courses
Leyland Access Training Courses
Crosby Access Training Courses
Eccles Access Training Courses
Southport Access Training Courses
Wythenshawe Access Training Courses
Denton Access Training Courses
Sale Access Training Courses
Merseyside Access Training Courses
Bootle Access Training Courses
Preston Access Training Courses
Kirkby Access Training Courses
Chadderton Access Training Courses
Ellesmere Port Access Training Courses
Wigan Access Training Courses
Huyton Access Training Courses
Northwich Access Training Courses
Bolton Access Training Courses
Birkenhead Access Training Courses
Blackburn Access Training Courses
Farnworth Access Training Courses
Lancashire Access Training Courses
Chester Access Training Courses
Oldham Access Training Courses
Runcorn Access Training Courses
Manchester Access Training Courses
Chorley Access Training Courses
Skelmersdale Access Training Courses
Thornton-Cleveleys Access Training Courses
Prestwich Access Training Courses
Hyde Access Training Courses
Stretford Access Training Courses
Barrow-in-Furness Access Training Courses
Widnes Access Training Courses
Cheshire Access Training Courses
Altrincham Access Training Courses
Leigh Access Training Courses
Ashton-under-Lyne Access Training Courses
Liverpool Access Training Courses
Morecambe Access Training Courses
Winsford Access Training Courses
Rochdale Access Training Courses
Wallasey Access Training Courses
Warrington Access Training Courses
Lytham Urmston Access Training Courses
Stockport Access Training Courses
Accrington Access Training Courses
North West Access Training Courses
Salford Access Training Courses
Burnley Access Training Courses

Middleton, Macclesfield, Blackpool, Lancaster, Bury, Carlisle, Saddleworth, Crewe, Leyland, Crosby, Eccles, Southport, Wythenshawe, Denton, Sale, Merseyside, Bootle, Preston, Kirkby, Chadderton, Ellesmere Port, Wigan, Huyton, Northwich, Bolton, Birkenhead, Blackburn, Farnworth, Lancashire, Chester, Oldham, Runcorn, Manchester, Chorley, Skelmersdale, Thornton-cleveleys, Prestwich, Hyde, Stretford, Barrow-in-furness, Widnes, Cheshire, Altrincham, Leigh, Ashton-under-lyne, Liverpool, Morecambe, Winsford, Rochdale, Wallasey, Warrington, Lytham Urmston, Stockport, Accrington, North West, Salford, Burnley