Enable Technology

ACCESS STRATFORD UPON AVON TRAINING COURSES 

ACCESS TRAINING COURSES STRATFORD UPON AVON




About Enable Technology Stratford Upon Avon Access Training Courses

We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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. Another way we could deliver the Access course is at a local training site. The Access syllabus can be modified to accommodate your specific training needs.

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.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are EDF Energy PLC, Nuclear Engineering Services, Carillion PLC, GKN PLC, Birmingham City Council, National Power PLC, Halfords Group PLC and Shell UK Oil Products Ltd.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Stratford Upon Avon
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Locking Records for Updating
    Working with Inline Error Handling
    Controlling Program Execution
    Working with Events
    Working with Procedures and Functions
    Using Visual Basic Help
    Using the With Statement
    Determining the Value of Expressions
    Navigating the Access Object Hierarchy
    Creating a Standard Module
    Using Debugging Tools
    Naming Procedures
    Working with Variable Scope
    Organizing Code and Procedures
    Introduction to Programming in Access
    Working with Properties
    Setting Break Expressions
    Considering Variable Scope and Lifetime Together
    Using Expressions, Variables, and Intrinsic Functions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Stratford Upon Avon
  • 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 ...
  • Data Validation
    Parameter Queries
    Sorting and Filtering
    Using a Navigation Form
    Adding Records to a Table
    Macros on Forms
    Creating a Relational Database
    Modifying Table Structures
    Adding Transactional Records
    Formatting Tables
    Designing a Lookup Database
    Creating and Using Forms
    Action Queries
    Multi Table Queries
    Macro Techniques
    Calculations in Queries
    Setting Table Relationships
    Querying Techniques
    Creating a Lookup Database
    Navigation Pane Protection
    Understanding VBA

  • See Training Course Details...



Email us about this courses



Other Stratford Upon Avon Enable Technology Training Courses

PL/SQL - Stratford Upon Avon SQL Training Courses
Power BI Stratford Upon Avon Training Courses
VBA - Stratford Upon Avon Excel Training Courses
SSRS - Stratford Upon Avon SQL Server Reporting Services Training Courses
Report Builder Stratford Upon Avon Training Courses
SSAS Stratford Upon Avon Training Courses