Enable Technology

ACCESS BARROW-IN-FURNESS TRAINING COURSES 

ACCESS TRAINING COURSES BARROW-IN-FURNESS




About Enable Technology Barrow-in-furness Access Training Courses

We have a twenty year history of providing skills based Access industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in Barrow-in-furness. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Yell Group PLC, Queen's Medical Centre Nottingham, West Bromwich Building Society, Nuclear Engineering Services, Countrywide Homes Limited, EDF Energy PLC, Wolverhampton City Council and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Barrow-in-furness
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Adding Records to a Table
    Creating Queries
    Formatting Tables
    Sorting and Filtering
    Database Wellness
    Aggregation Queries
    Designing a Lookup Database
    Parameter Queries
    Relational Database Design
    Macro Techniques
    Querying Techniques
    Setting Table Relationships
    Data Validation
    Modifying Forms
    Database Security
    Getting to Know Access 
    Creating and Using Forms
    Action Queries
    Modifying Table Structures
    Adding Transactional Records
    Creating and Using Reports

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Barrow-in-furness
  • 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 ...
  • Working with Procedures and Functions
    Introduction to Programming in Access
    Using the For...Next Structure
    Trapping Errors with the On Error Statement
    Understanding Collections
    Stepping through Code
    Understanding Control-of-Flow Structures
    Working with Methods
    Why Program in Access?
    Using the Do...Loop Structure
    Declaring Variables
    Using the Object Browser
    Creating a Sub Procedure
    Working with Recordsets
    Creating a Function Procedure
    Setting Breakpoints
    Using the Immediate Window to Call Procedures

  • See Training Course Details...



Email us about this courses



Other Barrow-in-furness Enable Technology Training Courses

Crystal 2016 - Barrow-in-furness Crystal Reports Training Courses
Project 2016 L1 Barrow-in-furness Training Courses
SSIS 2014 - Barrow-in-furness SQL Server Integration Services Training Courses
Data Mining - Barrow-in-furness Data Analytics Training Courses
SSRS 2008 - Barrow-in-furness SQL Server Reporting Services Training Courses
Mobile Barrow-in-furness Training Courses