Enable Technology

ACCESS DURHAM TRAINING COURSES 

ACCESS TRAINING COURSES DURHAM




About Enable Technology Durham Access Training Courses

We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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.

We provide instructor led training coupled with hands on training. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in Durham. All Access courses can be customised to meet your particular requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Aston University, Dollond & Aitchison Limited, Nationwide Building Society Limited, Birmingham City Council, Birmingham City University, West Bromwich Building Society, Loughborough University and Lloyds TSB Bank PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Durham
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Understanding Procedures
    Using Visual Basic Help
    Setting Break Expressions
    Understanding Control-of-Flow Structures
    Working with the ADODB Recordset Object
    Specifying a Recordset Cursor Location - Optional
    Using Intrinsic Constants
    Specifying a Recordset Cursor Type
    Using the If...End If Decision Structures
    Working with Methods
    Considering Variable Scope and Lifetime Together
    Using Debugging Tools
    Understanding VBA's Error Trapping Options
    Understanding Collections
    Understanding the Order of Events
    Understanding the Form Object
    Working with Procedures and Functions
    Working with Variable Scope
    Understanding Errors
    Understanding Data Types

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Durham
  • 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 ...
  • Action Queries
    Getting to Know Access 
    Modifying Table Structures
    Adding Transactional Records
    Creating and Using Macros
    Working With Records
    Macros on Forms
    Modifying Forms
    Designing a Lookup Database
    Setting Table Relationships
    Creating a Relational Database
    Multi Table Queries
    Macro Techniques
    Aggregation Queries
    Data Validation
    Database Security
    Sorting and Filtering
    Creating and Using Forms
    Importing and Exporting Records
    Using a Navigation Form
    Creating and Using Reports

  • See Training Course Details...



Email us about this courses



Other Durham Enable Technology Training Courses

SQL - Durham SQL Training Courses
Data Warehouse Durham Training Courses
Excel Power Pivot Durham Training Courses
Oracle SQL - Durham SQL Training Courses
JQuery - Durham JavaScript Training Courses
Excel 365 Advanced Durham Training Courses