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
- See Training Course Details...
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
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
- See Training Course Details...
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
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