Enable Technology

ACCESS GWYNEDD TRAINING COURSES 

ACCESS TRAINING COURSES GWYNEDD




About Enable Technology Gwynedd Access Training Courses

We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Gwynedd. The Access syllabus can be modified to accommodate your specific training needs.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Norfolk Police Constabulary, TalkTalk Direct Limited, Barclays Bank PLC, Royal Air Force, DHL Express, Lloyds TSB Bank PLC, Nationwide Building Society Limited and Birmingham City University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gwynedd
  • 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 ...
  • Guidelines for use of Branching Structures
    Understanding Errors
    Creating a Sub Procedure
    Using Message Boxes
    Working with Variable Scope
    Using Visual Basic Help
    Naming Procedures
    Using the CacheSize Property - Optional
    Why Program in Access?
    Declaring Variables
    Using the If...End If Decision Structures
    Understanding Error Handling
    Working with the Code Editor
    Understanding the DoCmd Object
    Handling Errors
    Specifying a Recordset Cursor Location - Optional
    Organizing Code and Procedures
    Working with Events
    Understanding Expressions and Statements
    Working with Methods

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Gwynedd
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Parameter Queries
    Relational Database Design
    Querying Techniques
    Sorting and Filtering
    Designing a Lookup Database
    Navigation Pane Protection
    Setting Table Relationships
    Understanding VBA
    Database Wellness
    Adding Records to a Table
    Macro Techniques
    Database Security
    Aggregation Queries
    DIY Forms
    Calculations in Queries
    Creating and Using Forms
    Creating a Relational Database
    Creating a Lookup Database
    Using a Navigation Form
    Modifying Forms
    Data Validation

  • See Training Course Details...



Email us about this courses



Other Gwynedd Enable Technology Training Courses

Oracle SQL Gwynedd Training Courses
JavaScript - Gwynedd JavaScript Training Courses
SSRS Gwynedd Training Courses
Excel 365 Intermediate - Gwynedd Excel Training Courses
Excel 365 Basic Gwynedd Training Courses
VBA Gwynedd Training Courses