Enable Technology

ACCESS STAFFORD TRAINING COURSES 

ACCESS TRAINING COURSES STAFFORD




About Enable Technology Stafford Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Access courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver Access courses at your site. The Access course could also be scheduled at a socially distanced site near you in Stafford. We are more than happy to incorporate additional topics to accommodate your organisations Access training 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 team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are National Power PLC, Birmingham Heartlands Hospital, Carillion PLC, TalkTalk Direct Limited, Canadian High Commission, Cadbury PLC, Loughborough University and EDF Energy PLC.




Microsoft Access

  • 2 day course
  • Location: Stafford
  • 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 ...
  • Calculations in Queries
    Adding Records to a Table
    Understanding VBA
    Parameter Queries
    Macros on Forms
    Data Validation
    Formatting Tables
    Aggregation Queries
    Getting to Know Access 
    Creating and Using Macros
    Action Queries
    Macro Techniques
    Database Wellness
    Modifying Forms
    Sorting and Filtering
    Relational Database Design
    Importing and Exporting Records
    An Introduction to VBA
    Designing a Lookup Database
    Working With Records
    Creating and Using Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Stafford
  • 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 ...
  • Why Program in Access?
    Declaring Variables
    Using the With Statement
    Working with the Code Editor
    Using the For Each...Next Structure
    Understanding Procedures
    Understanding Data Types
    Understanding the Form Object
    Using Input Boxes
    Using Break Mode during Run Mode
    Working with Methods
    Using Message Boxes
    Understanding Modules
    Using the CacheSize Property - Optional
    Understanding VBA's Error Trapping Options
    Using Visual Basic Help
    Setting Break Expressions
    Understanding Objects
    Declaring and Creating Object Variables
    Using the Immediate Window to Call Procedures

  • See Training Course Details...



Email us about this courses



Other Stafford Enable Technology Training Courses

JavaScript - Stafford JavaScript Training Courses
Report Builder - Stafford SQL Server Reporting Services Training Courses
SSRS Stafford Training Courses
VBA - Stafford Excel Training Courses
Oracle SQL Stafford Training Courses
JQuery Mobile - Stafford JavaScript Training Courses