Enable Technology

ACCESS WINSFORD TRAINING COURSES 

ACCESS TRAINING COURSES WINSFORD




About Enable Technology Winsford Access Training Courses

Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology offers instructor led training taught by technology specialists. 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 course at a local venue in Winsford. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: West Bromwich Building Society, Unipart Group, Halfords Group PLC, Loughborough University, DHL Express, Yell Group PLC, Nationwide Building Society Limited and Fujistu PLC.




Microsoft Access

  • 2 day course
  • Location: Winsford
  • 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 ...
  • Relational Database Design
    Understanding VBA
    Aggregation Queries
    Formatting Tables
    Getting to Know Access 
    Modifying Forms
    Creating Queries
    Using a Navigation Form
    Creating and Using Macros
    Data Validation
    Parameter Queries
    Creating and Using Reports
    Database Security
    Working With Records
    Importing and Exporting Records
    Macros on Forms
    Designing a Lookup Database
    DIY Forms
    Creating and Using Forms
    Setting Table Relationships
    Navigation Pane Protection

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Winsford
  • 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 the Code Editor
    Working with the Application Object
    Understanding Errors
    Locking Records for Updating
    Calling Procedures
    Using Visual Basic Help
    Working with Variable Lifetime
    Using the Immediate Window to Call Procedures
    Trapping Errors with the On Error Statement
    Using Intrinsic Constants
    Understanding Recordset Cursor Properties - Optional
    Setting Breakpoints
    Working with Methods
    Determining the Value of Expressions
    Guidelines for use of Branching Structures
    Debugging Code
    Working with Properties
    Using the Object Browser
    Stepping through Code
    Using the For Each...Next Structure
    Using Message Boxes

  • See Training Course Details...



Email us about this courses



Other Winsford Enable Technology Training Courses

SQL - Winsford SQL Training Courses
Excel 365 Basic - Winsford Excel Training Courses
SSAS Tabular - Winsford SQL Server Analysis Services Training Courses
Oracle SQL - Winsford SQL Training Courses
Power Query - Winsford Excel Training Courses
VBA Winsford Training Courses