Enable Technology

ACCESS FARNWORTH TRAINING COURSES 

ACCESS TRAINING COURSES FARNWORTH




About Enable Technology Farnworth Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Farnworth. We are happy to modify the Access syllabus to match your teams training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Countrywide Homes Limited, TalkTalk Direct Limited, GKN PLC, Boots UK Limited, Nationwide Building Society Limited, Wolverhampton City Council, Aston University and Royal & Sun Alliance Group PLC.




Microsoft Access

  • 2 day course
  • Location: Farnworth
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Modifying Table Structures
    Parameter Queries
    Data Validation
    Modifying Forms
    Importing and Exporting Records
    Setting Table Relationships
    Designing a Lookup Database
    Database Wellness
    DIY Forms
    Creating and Using Macros
    Relational Database Design
    Multi Table Queries
    Macro Techniques
    Adding Transactional Records
    Action Queries
    Adding Records to a Table
    Creating a Relational Database
    Sorting and Filtering
    Querying Techniques
    Aggregation Queries
    Creating a Lookup Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Farnworth
  • 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 ...
  • Working with Properties
    Working with Variable Scope
    Using Expressions, Variables, and Intrinsic Functions
    Debugging Code
    Using Intrinsic Constants
    Understanding Collections
    Handling Errors
    Understanding Classes and Objects
    Understanding the Development Environment
    Understanding Error Handling
    Creating a Standard Module
    Understanding VBA's Error Trapping Options
    Understanding the Order of Events
    Trapping Errors with the On Error Statement
    Considering Variable Scope and Lifetime Together
    Understanding Procedures
    Using the CacheSize Property - Optional
    Using Intrinsic Functions
    Using Visual Basic Help
    Using Break Mode during Run Mode

  • See Training Course Details...



Email us about this courses



Other Farnworth Enable Technology Training Courses

SSRS - Farnworth SQL Server Reporting Services Training Courses
TSQL - Farnworth SQL Training Courses
SQL Farnworth Training Courses
Excel 365 Intermediate - Farnworth Excel Training Courses
Data Warehouse Farnworth Training Courses
PL/SQL Farnworth Training Courses