ACCESS TRAINING COURSES NEWPORT
About Enable Technology Newport Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. If you prefer we can offer an offsite training location in Newport. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Norfolk Police Constabulary, Total Telecommunications Limited, Fujistu PLC, Norwich Union PLC, Queen's Medical Centre Nottingham, Homeserve PLC, Wolverhampton City Council and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Newport
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Working With Records
- See Training Course Details...
Modifying Forms
Navigation Pane Protection
Relational Database Design
Creating Queries
Adding Records to a Table
Creating and Using Reports
Aggregation Queries
Sorting and Filtering
Adding Transactional Records
Database Wellness
Modifying Table Structures
Creating and Using Forms
Action Queries
Calculations in Queries
Creating a Lookup Database
Designing a Lookup Database
Using a Navigation Form
Macros on Forms
Setting Table Relationships
Importing and Exporting Records
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 ... Working with Procedures and Functions
- See Training Course Details...
Stepping through Code
Debugging Code
Controlling Program Execution
Working with the Code Editor
Specifying a Recordset Cursor Type
Working with the Application Object
Why Program in Access?
Specifying a Recordset Cursor Location - Optional
Understanding Modules
Determining the Value of Expressions
Using Expressions, Variables, and Intrinsic Functions
Working with Inline Error Handling
Understanding Objects
Understanding Classes and Objects
Understanding Control-of-Flow Structures
Understanding VBA's Error Trapping Options
Calling Procedures
Using Visual Basic Help
Understanding Collections
Creating a Function Procedure
Email us about this courses
Other Newport Enable Technology Training Courses
Data Warehouse - Newport SQL Training Courses
TSQL Newport Training Courses
SSAS Newport Training Courses
Excel 365 Advanced - Newport Excel Training Courses
Excel Power Pivot Newport Training Courses
VBA Newport Training Courses