Enable Technology

ACCESS RISCA TRAINING COURSES 

ACCESS TRAINING COURSES RISCA




About Enable Technology Risca Access Training Courses

Enable Technology specialise in succinct skills based Access training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Risca. The Access syllabus can be modified to accommodate your specific training needs.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We have operated primarily in the West Midlands for twenty years. Some of our clients are West Bromwich Building Society, Cadbury PLC, Vodafone Group Services, Fujistu PLC, Lloyds TSB Bank PLC, Yell Group PLC, University of Birmingham and Queen's Medical Centre Nottingham.




Microsoft Access

  • 2 day course
  • Location: Risca
  • 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 ...
  • An Introduction to VBA
    Relational Database Design
    Importing and Exporting Records
    Database Wellness
    Calculations in Queries
    Creating Queries
    Understanding VBA
    Creating a Relational Database
    Designing a Lookup Database
    Creating and Using Forms
    Adding Transactional Records
    Parameter Queries
    Setting Table Relationships
    Creating and Using Macros
    Sorting and Filtering
    Using a Navigation Form
    Formatting Tables
    Adding Records to a Table
    Macros on Forms
    Querying Techniques
    Navigation Pane Protection

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Risca
  • Telephone on 01952 938014
  • 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 ...
  • Understanding Recordset Cursor Properties - Optional
    Creating a Standard Module
    Understanding Procedures
    Using the CacheSize Property - Optional
    Introduction to Programming in Access
    Using the If...End If Decision Structures
    Using Input Boxes
    Why Program in Access?
    Understanding Modules
    Determining the Value of Expressions
    Using Expressions, Variables, and Intrinsic Functions
    Organizing Code and Procedures
    Calling Procedures
    Using the With Statement
    Creating a Sub Procedure
    Specifying a Recordset Cursor Type
    Considering Variable Scope and Lifetime Together
    Using the For...Next Structure
    Debugging Code

  • See Training Course Details...



Email us about this courses



Other Risca Enable Technology Training Courses

Excel 365 Advanced - Risca Excel Training Courses
Oracle SQL Risca Training Courses
Excel Power Pivot - Risca Excel Training Courses
PL/SQL Risca Training Courses
Excel 365 Intermediate Risca Training Courses
Data Warehouse - Risca SQL Training Courses