Enable Technology

ACCESS BEDWAS TRAINING COURSES 

ACCESS TRAINING COURSES BEDWAS




About Enable Technology Bedwas Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with Access training materials which they keep 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.

Courses are instructor led and groups sizes small. 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. We also offer the option of scheduling of Access course at a socially distanced venue near you in Bedwas. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

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.

We have operated primarily in the West Midlands for twenty years. Our clients include: Loughborough University, National Power PLC, Capita Group PLC, Birmingham City University, Canadian High Commission, Countrywide Homes Limited, GKN PLC and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: Bedwas
  • Telephone on 01952 938014
  • 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 ...
  • Creating a Relational Database
    Modifying Table Structures
    Database Security
    Using a Navigation Form
    Getting to Know Access 
    Data Validation
    Adding Transactional Records
    DIY Forms
    Creating a Lookup Database
    Designing a Lookup Database
    Creating Queries
    Adding Records to a Table
    Querying Techniques
    Calculations in Queries
    Sorting and Filtering
    Working With Records
    Modifying Forms
    Setting Table Relationships
    Relational Database Design
    Macro Techniques
    Formatting Tables

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bedwas
  • 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 ...
  • Setting Break Expressions
    Guidelines for use of Branching Structures
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Constants
    Working with Boolean Expressions
    Working with Inline Error Handling
    Using the If...End If Decision Structures
    Using the For Each...Next Structure
    Declaring and Creating Object Variables
    Understanding VBA's Error Trapping Options
    Understanding the Development Environment
    Working with Variable Scope
    Working with Methods
    Creating a Sub Procedure
    Navigating the Access Object Hierarchy
    Setting Breakpoints
    Naming Procedures
    Using the For...Next Structure
    Understanding Error Handling
    Declaring Variables

  • See Training Course Details...



Email us about this courses



Other Bedwas Enable Technology Training Courses

SSAS Tabular Bedwas Training Courses
JavaScript Bedwas Training Courses
Oracle SQL Bedwas Training Courses
SSRS Bedwas Training Courses
VBA Bedwas Training Courses
Excel 365 Intermediate - Bedwas Excel Training Courses