Enable Technology

ACCESS SOUTH GLAMORGAN TRAINING COURSES 

ACCESS TRAINING COURSES SOUTH GLAMORGAN




About Enable Technology South Glamorgan Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Loughborough University, Wolverhampton City Council, Keele University, GKN PLC, Cadbury PLC, Birmingham Heartlands Hospital, Vodafone Group Services and Dollond & Aitchison Limited.




Microsoft Access

  • 2 day course
  • Location: South Glamorgan
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Creating and Using Forms
    Working With Records
    Using a Navigation Form
    Calculations in Queries
    Aggregation Queries
    Getting to Know Access 
    Relational Database Design
    DIY Forms
    Macro Techniques
    Macros on Forms
    An Introduction to VBA
    Adding Transactional Records
    Importing and Exporting Records
    Action Queries
    Designing a Lookup Database
    Database Security
    Creating a Lookup Database
    Formatting Tables
    Creating Queries
    Sorting and Filtering
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: South Glamorgan
  • 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 ...
  • Working with the Code Editor
    Creating a Standard Module
    Understanding Collections
    Understanding the DoCmd Object
    Using the Do...Loop Structure
    Stepping through Code
    Organizing Code and Procedures
    Working with Recordsets
    Working with Boolean Expressions
    Understanding the Form Object
    Using the CacheSize Property - Optional
    Using Intrinsic Constants
    Declaring Variables
    Using Visual Basic Help
    Trapping Errors with the On Error Statement
    Working with Variable Scope
    Using Intrinsic Functions
    Understanding Data Types
    Why Program in Access?
    Working with Events
    Understanding the Err Object

  • See Training Course Details...



Email us about this courses



Other South Glamorgan Enable Technology Training Courses

Oracle SQL South Glamorgan Training Courses
Report Builder South Glamorgan Training Courses
Power Query - South Glamorgan Excel Training Courses
Excel 365 Basic - South Glamorgan Excel Training Courses
JQuery South Glamorgan Training Courses
SQL - South Glamorgan SQL Training Courses