Enable Technology

ACCESS NEWPORT TRAINING COURSES 

ACCESS TRAINING COURSES NEWPORT




About Enable Technology Newport Access Training Courses

We have a twenty year history of providing skills based Access industry training. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

We provide instructor led training coupled with hands on training. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local training site in Newport. We are happy to modify the Access syllabus to match your teams training requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Carillion PLC, Nuclear Engineering Services, Lloyds TSB Bank PLC, Dollond & Aitchison Limited, Cadbury PLC, Total Telecommunications Limited, Wolverhampton City Council and Fujistu PLC.




Microsoft Access

  • 2 day course
  • Location: Newport
  • 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 and Using Forms
    Creating a Lookup Database
    Multi Table Queries
    Modifying Table Structures
    Action Queries
    Getting to Know Access 
    Calculations in Queries
    Creating and Using Macros
    Aggregation Queries
    Setting Table Relationships
    Data Validation
    Macros on Forms
    Formatting Tables
    Querying Techniques
    Designing a Lookup Database
    Database Wellness
    Navigation Pane Protection
    Understanding VBA
    Creating and Using Reports
    Creating a Relational Database
    Creating Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Newport
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Using the If...End If Decision Structures
    Declaring and Creating Object Variables
    Calling Procedures
    Understanding the DoCmd Object
    Working with Events
    Using Break Mode during Run Mode
    Understanding Control-of-Flow Structures
    Specifying a Recordset Cursor Type
    Understanding Collections
    Considering Variable Scope and Lifetime Together
    Working with the ADODB Recordset Object
    Determining the Value of Expressions
    Using Input Boxes
    Trapping Errors with the On Error Statement
    Debugging Code
    Specifying a Recordset Cursor Location - Optional
    Using Intrinsic Functions
    Understanding Modules

  • See Training Course Details...



Email us about this courses



Other Newport Enable Technology Training Courses

Excel 365 Advanced Newport Training Courses
Power Query Newport Training Courses
JQuery Mobile - Newport JavaScript Training Courses
Report Builder - Newport SQL Server Reporting Services Training Courses
JQuery - Newport JavaScript Training Courses
SSIS - Newport SQL Server Integration Services Training Courses