Enable Technology

ACCESS SALE TRAINING COURSES 

ACCESS TRAINING COURSES SALE




About Enable Technology Sale Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology training courses are delivered as instructor led courses. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Sale. 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 been delivering technical training in the Midlands for twenty years. Our clients include: Lloyds TSB Bank PLC, Halfords Group PLC, West Bromwich Building Society, Birmingham City Council, Loughborough University, Barclays Bank PLC, Homeserve PLC and Wolverhampton City Council.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sale
  • 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 ...
  • Organizing Code and Procedures
    Specifying a Recordset Cursor Type
    Working with the ADODB Recordset Object
    Using Visual Basic Help
    Understanding Recordset Cursor Properties - Optional
    Using Message Boxes
    Working with Recordsets
    Introduction to Programming in Access
    Working with Procedures and Functions
    Using the Select Case...End Select Structure
    Guidelines for use of Branching Structures
    Understanding Classes and Objects
    Specifying a Recordset Cursor Location - Optional
    Stepping through Code
    Considering Variable Scope and Lifetime Together
    Using the If...End If Decision Structures
    Using Intrinsic Functions
    Using the For...Next Structure
    Using Intrinsic Constants

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Sale
  • Telephone on 01952 938014
  • 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 ...
  • Navigation Pane Protection
    Database Security
    Querying Techniques
    Data Validation
    Formatting Tables
    Getting to Know Access 
    Creating and Using Reports
    Relational Database Design
    Understanding VBA
    Creating and Using Forms
    Working With Records
    Creating Queries
    Aggregation Queries
    An Introduction to VBA
    Setting Table Relationships
    Creating a Relational Database
    Modifying Forms
    Designing a Lookup Database
    Sorting and Filtering
    Adding Transactional Records
    Calculations in Queries

  • See Training Course Details...



Email us about this courses



Other Sale Enable Technology Training Courses

Data Warehouse Sale Training Courses
Oracle SQL Sale Training Courses
Report Builder Sale Training Courses
SQL Sale Training Courses
Excel 365 Intermediate Sale Training Courses
Excel Power Pivot Sale Training Courses