Enable Technology

ACCESS DONCASTER TRAINING COURSES 

ACCESS TRAINING COURSES DONCASTER




About Enable Technology Doncaster Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.

Access courses are taught by a Microsoft Certified Solutions Expert. 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. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training needs.

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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are EDF Energy PLC, DHL Express, South Staffordshire Water PLC, Lloyds TSB Bank PLC, Royal Air Force, Boots UK Limited, Capita Group PLC and Nuclear Engineering Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Doncaster
  • 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 ...
  • Understanding Constants
    Using Visual Basic Help
    Working with Variable Scope
    Setting Breakpoints
    Using the With Statement
    Determining the Value of Expressions
    Declaring and Creating Object Variables
    Understanding Classes and Objects
    Understanding Recordset Cursor Properties - Optional
    Understanding Error Handling
    Stepping through Code
    Specifying a Recordset Cursor Type
    Using Message Boxes
    Controlling Program Execution
    Working with Properties
    Working with Recordsets
    Locking Records for Updating
    Understanding Errors
    Working with Boolean Expressions
    Introduction to Programming in Access

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Doncaster
  • 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 ...
  • Creating a Relational Database
    Understanding VBA
    DIY Forms
    Sorting and Filtering
    Using a Navigation Form
    Data Validation
    An Introduction to VBA
    Adding Records to a Table
    Working With Records
    Aggregation Queries
    Creating Queries
    Relational Database Design
    Creating and Using Reports
    Macro Techniques
    Creating and Using Macros
    Setting Table Relationships
    Modifying Table Structures
    Calculations in Queries
    Multi Table Queries
    Getting to Know Access 
    Database Security

  • See Training Course Details...



Email us about this courses



Other Doncaster Enable Technology Training Courses

JQuery Mobile Doncaster Training Courses
Excel Power Pivot - Doncaster Excel Training Courses
Oracle SQL - Doncaster SQL Training Courses
DAX Doncaster Training Courses
Data Warehouse - Doncaster SQL Training Courses
JQuery - Doncaster JavaScript Training Courses