Enable Technology

ACCESS SCARBOROUGH TRAINING COURSES 

ACCESS TRAINING COURSES SCARBOROUGH




About Enable Technology Scarborough Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. 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. Alternatively we could schedule a Access course at an alternative training site in Scarborough. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Birmingham Heartlands Hospital, University of Birmingham, Yell Group PLC, Nuclear Engineering Services, South Staffordshire Water PLC, Wolverhampton City Council, Canadian High Commission and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Scarborough
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Action Queries
    Multi Table Queries
    Creating a Relational Database
    Creating a Lookup Database
    Macro Techniques
    Creating and Using Reports
    Database Security
    Understanding VBA
    Creating and Using Macros
    Calculations in Queries
    Macros on Forms
    Adding Transactional Records
    Creating and Using Forms
    Parameter Queries
    Relational Database Design
    Querying Techniques
    Data Validation
    Using a Navigation Form
    Importing and Exporting Records
    Aggregation Queries
    Database Wellness

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Scarborough
  • 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 Boolean Expressions
    Understanding Data Types
    Understanding Errors
    Calling Procedures
    Understanding the Err Object
    Working with Events
    Using the Select Case...End Select Structure
    Understanding Objects
    Handling Errors
    Introduction to Programming in Access
    Using the For Each...Next Structure
    Declaring Variables
    Working with the Application Object
    Understanding the Development Environment
    Organizing Code and Procedures
    Using Input Boxes
    Using Message Boxes
    Using Debugging Tools
    Understanding Collections

  • See Training Course Details...



Email us about this courses



Other Scarborough Enable Technology Training Courses

Oracle SQL Scarborough Training Courses
Data Warehouse Scarborough Training Courses
TSQL Scarborough Training Courses
SSIS - Scarborough SQL Server Integration Services Training Courses
Power BI - Scarborough Microsoft Power BI Training Courses
JQuery Scarborough Training Courses