Enable Technology

ACCESS SCARBOROUGH TRAINING COURSES 

ACCESS TRAINING COURSES SCARBOROUGH




About Enable Technology Scarborough Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 Scarborough. 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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Halfords Group PLC, Queen's Medical Centre Nottingham, Cadbury PLC, Birmingham City University, Homeserve PLC, Nationwide Building Society Limited, DHL Express and Canadian High Commission.




Microsoft Access

  • 2 day course
  • Location: Scarborough
  • Telephone on 01952 305730
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Querying Techniques
    Setting Table Relationships
    Using a Navigation Form
    An Introduction to VBA
    Aggregation Queries
    Understanding VBA
    Importing and Exporting Records
    Creating and Using Forms
    Adding Transactional Records
    Creating Queries
    Sorting and Filtering
    Getting to Know Access 
    Creating and Using Macros
    Adding Records to a Table
    Data Validation
    Action Queries
    Parameter Queries
    Database Security
    Navigation Pane Protection
    Macros on Forms
    Macro Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Scarborough
  • 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 ...
  • Writing an Error-Handling Routine
    Understanding Collections
    Understanding the DoCmd Object
    Using Debugging Tools
    Using the CacheSize Property - Optional
    Working with Events
    Specifying a Recordset Cursor Type
    Using the For Each...Next Structure
    Understanding Errors
    Using the Do...Loop Structure
    Setting Breakpoints
    Working with Boolean Expressions
    Using the For...Next Structure
    Understanding the Order of Events
    Locking Records for Updating
    Using the If...End If Decision Structures
    Using Message Boxes
    Understanding the Form Object

  • See Training Course Details...



Email us about this courses



Other Scarborough Enable Technology Training Courses

Microsoft Project Level 2 Scarborough Training Courses
PowerPoint Basic - Scarborough Office Training Courses
SSRS 2008 - Scarborough SQL Server Reporting Services Training Courses
Data Warehouse - Scarborough SQL Training Courses
Power BI - Scarborough Microsoft Power BI Training Courses
SSIS 2005 - Scarborough SQL Server Integration Services Training Courses



North - Possible Access Training Course Locations


Pudsey Access Training Courses
Newcastle Upon Tyne Access Training Courses
Doncaster Access Training Courses
Scarborough Access Training Courses
Rotherham Access Training Courses
Sheffield Access Training Courses
York Access Training Courses
Keighley Access Training Courses
Leeds Access Training Courses
Batley Access Training Courses
Sunderland Access Training Courses
Halifax Access Training Courses
Huddersfield Access Training Courses
Barnsley Access Training Courses
South Shields Access Training Courses
Castleford Access Training Courses
Wakefield Access Training Courses
Normanton Access Training Courses
Dewsbury Access Training Courses
Wetherby Access Training Courses
Bridlington Access Training Courses
Harrogate Access Training Courses
Yorkshire Access Training Courses
Durham Access Training Courses
Scunthorpe Access Training Courses
North East Access Training Courses
Hartlepool Access Training Courses
Gateshead Access Training Courses
Hexham Access Training Courses
Middlesbrough Access Training Courses
Grimsby Access Training Courses

Pudsey, Newcastle Upon Tyne, Doncaster, Scarborough, Rotherham, Sheffield, York, Keighley, Leeds, Batley, Sunderland, Halifax, Huddersfield, Barnsley, South Shields, Castleford, Wakefield, Normanton, Dewsbury, Wetherby, Bridlington, Harrogate, Yorkshire, Durham, Scunthorpe, North East, Hartlepool, Gateshead, Hexham, Middlesbrough, Grimsby