Enable Technology

ACCESS SOUTH WEST TRAINING COURSES 

ACCESS TRAINING COURSES SOUTH WEST




About Enable Technology South West Access Training Courses

Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in the South West. We are happy to modify the Access syllabus to match your teams training 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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Countrywide Homes Limited, Norfolk Police Constabulary, TalkTalk Direct Limited, Barclays Bank PLC, Vodafone Group Services, South Staffordshire Water PLC, West Bromwich Building Society and Queen's Medical Centre Nottingham.




Microsoft Access

  • 2 day course
  • Location: South West
  • Telephone on 01952 938014
  • 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 ...
  • Adding Transactional Records
    Importing and Exporting Records
    Data Validation
    Database Wellness
    Understanding VBA
    Working With Records
    Modifying Table Structures
    Adding Records to a Table
    An Introduction to VBA
    Creating Queries
    Querying Techniques
    Database Security
    Calculations in Queries
    DIY Forms
    Parameter Queries
    Using a Navigation Form
    Macro Techniques
    Getting to Know Access 
    Creating a Lookup Database
    Creating and Using Macros
    Navigation Pane Protection

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: South West
  • 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 ...
  • Understanding Collections
    Writing an Error-Handling Routine
    Working with Properties
    Stepping through Code
    Working with Variable Scope
    Using Intrinsic Functions
    Working with Boolean Expressions
    Understanding Constants
    Calling Procedures
    Understanding the Development Environment
    Working with Recordsets
    Determining the Value of Expressions
    Using Input Boxes
    Working with Inline Error Handling
    Understanding Modules
    Understanding the Order of Events
    Working with Methods
    Naming Procedures
    Locking Records for Updating

  • See Training Course Details...



Email us about this courses



Other South West Enable Technology Training Courses

SSIS South West Training Courses
VBA - South West Excel Training Courses
Oracle SQL - South West SQL Training Courses
JavaScript South West Training Courses
DAX South West Training Courses
Power BI - South West Microsoft Power BI Training Courses