Enable Technology

ACCESS BRISTOL TRAINING COURSES 

ACCESS TRAINING COURSES BRISTOL




About Enable Technology Bristol Access Training Courses

We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Bristol. 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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Cadbury PLC, Birmingham City Council, Birmingham Heartlands Hospital, Halfords Group PLC, West Bromwich Building Society, Nationwide Building Society Limited, Canadian High Commission and GKN PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bristol
  • 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 Data Types
    Introduction to Programming in Access
    Working with Events
    Using the With Statement
    Locking Records for Updating
    Creating a Sub Procedure
    Working with Methods
    Guidelines for use of Branching Structures
    Working with Variable Scope
    Using Message Boxes
    Understanding Expressions and Statements
    Using Expressions, Variables, and Intrinsic Functions
    Calling Procedures
    Specifying a Recordset Cursor Location - Optional
    Using the CacheSize Property - Optional
    Using the For...Next Structure
    Using the Object Browser
    Working with the Application Object

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Bristol
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Formatting Tables
    Multi Table Queries
    Sorting and Filtering
    Macro Techniques
    Setting Table Relationships
    Aggregation Queries
    Modifying Table Structures
    Database Security
    DIY Forms
    Creating and Using Reports
    Adding Transactional Records
    Understanding VBA
    Creating and Using Macros
    An Introduction to VBA
    Getting to Know Access 
    Using a Navigation Form
    Macros on Forms
    Parameter Queries
    Data Validation
    Database Wellness
    Querying Techniques

  • See Training Course Details...



Email us about this courses



Other Bristol Enable Technology Training Courses

Excel 365 Intermediate Bristol Training Courses
Excel 365 Basic - Bristol Excel Training Courses
Power Query Bristol Training Courses
Excel Power Pivot - Bristol Excel Training Courses
SSAS Bristol Training Courses
SSRS Bristol Training Courses