Enable Technology

ACCESS TREDEGAR TRAINING COURSES 

ACCESS TRAINING COURSES TREDEGAR




About Enable Technology Tredegar Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. Each person attending a course takes away Access courseware which can be used as reference materials after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in Tredegar. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: DHL Express, Wolverhampton City Council, Unipart Group, Homeserve PLC, Royal & Sun Alliance Group PLC, Cadbury PLC, Halfords Group PLC and Birmingham City University.




Microsoft Access

  • 2 day course
  • Location: Tredegar
  • 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
    Multi Table Queries
    Modifying Table Structures
    Macro Techniques
    Creating and Using Forms
    Macros on Forms
    Calculations in Queries
    Modifying Forms
    Getting to Know Access 
    An Introduction to VBA
    Working With Records
    Creating a Relational Database
    Formatting Tables
    Sorting and Filtering
    Database Wellness
    Parameter Queries
    Querying Techniques
    Database Security
    Adding Records to a Table
    Action Queries
    Aggregation Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Tredegar
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding the DoCmd Object
    Trapping Errors with the On Error Statement
    Working with Boolean Expressions
    Working with Methods
    Working with Variable Scope
    Using Break Mode during Run Mode
    Using Input Boxes
    Controlling Program Execution
    Using Visual Basic Help
    Understanding the Development Environment
    Locking Records for Updating
    Setting Breakpoints
    Working with the Code Editor
    Understanding Constants
    Using the Immediate Window to Call Procedures
    Writing an Error-Handling Routine
    Understanding the Err Object
    Working with Events
    Creating a Function Procedure

  • See Training Course Details...



Email us about this courses



Other Tredegar Enable Technology Training Courses

SQL Tredegar Training Courses
VBA - Tredegar Excel Training Courses
SSRS Tredegar Training Courses
Power Query Tredegar Training Courses
SSAS Tredegar Training Courses
Excel 365 Basic Tredegar Training Courses