Enable Technology

ACCESS HALIFAX TRAINING COURSES 

ACCESS TRAINING COURSES HALIFAX




About Enable Technology Halifax Access Training Courses

Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the 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.

We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local venue in Halifax. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Queen's Medical Centre Nottingham, Fujistu PLC, Shell UK Oil Products Ltd, GKN PLC, DHL Express, National Power PLC, Countrywide Homes Limited and EDF Energy PLC.




Microsoft Access

  • 2 day course
  • Location: Halifax
  • 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
    Data Validation
    Aggregation Queries
    Getting to Know Access 
    Using a Navigation Form
    Understanding VBA
    Parameter Queries
    An Introduction to VBA
    Creating and Using Forms
    Macros on Forms
    Formatting Tables
    Creating a Lookup Database
    Creating and Using Reports
    Modifying Table Structures
    Multi Table Queries
    Calculations in Queries
    Importing and Exporting Records
    Setting Table Relationships
    Designing a Lookup Database
    DIY Forms
    Working With Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Halifax
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Organizing Code and Procedures
    Understanding the Err Object
    Using Message Boxes
    Using Visual Basic Help
    Working with Procedures and Functions
    Using the CacheSize Property - Optional
    Working with Variable Lifetime
    Understanding Procedures
    Understanding the Form Object
    Stepping through Code
    Using the If...End If Decision Structures
    Understanding Error Handling
    Understanding the DoCmd Object
    Naming Procedures
    Working with the Application Object
    Introduction to Programming in Access
    Understanding Expressions and Statements

  • See Training Course Details...



Email us about this courses



Other Halifax Enable Technology Training Courses

SSIS Halifax Training Courses
SSAS Tabular - Halifax SQL Server Analysis Services Training Courses
JQuery Mobile Halifax Training Courses
JavaScript Halifax Training Courses
SSRS - Halifax SQL Server Reporting Services Training Courses
Data Warehouse Halifax Training Courses