ACCESS TRAINING COURSES NEWCASTLE UNDER LYME
About Enable Technology Newcastle Under Lyme Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Newcastle Under Lyme. All Access courses can be customised to meet your particular requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Norwich Union PLC, South Staffordshire Water PLC, Halfords Group PLC, Wolverhampton City Council, Lloyds TSB Bank PLC, Fujistu PLC, Royal & Sun Alliance Group PLC and Loughborough University.
Microsoft Access
- 2 day course
- Location: Newcastle Under Lyme
- 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 ... Parameter Queries
- See Training Course Details...
Creating and Using Macros
DIY Forms
Querying Techniques
Creating and Using Forms
Action Queries
Macro Techniques
Adding Transactional Records
Navigation Pane Protection
Creating a Lookup Database
Modifying Table Structures
Data Validation
Adding Records to a Table
Database Wellness
Macros on Forms
Setting Table Relationships
Sorting and Filtering
Creating and Using Reports
Understanding VBA
An Introduction to VBA
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Under Lyme
- 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 ... Stepping through Code
- See Training Course Details...
Understanding the Order of Events
Using Visual Basic Help
Understanding Modules
Using the For Each...Next Structure
Understanding Procedures
Using the With Statement
Naming Procedures
Working with Properties
Navigating the Access Object Hierarchy
Debugging Code
Understanding Control-of-Flow Structures
Locking Records for Updating
Setting Breakpoints
Understanding Errors
Understanding Recordset Cursor Properties - Optional
Declaring Variables
Why Program in Access?
Working with Recordsets
Organizing Code and Procedures
Using the Immediate Window to Call Procedures
Email us about this courses
Other Newcastle Under Lyme Enable Technology Training Courses
Excel 365 Intermediate - Newcastle Under Lyme Excel Training Courses
SQL - Newcastle Under Lyme SQL Training Courses
Report Builder - Newcastle Under Lyme SQL Server Reporting Services Training Courses
JQuery Newcastle Under Lyme Training Courses
Excel Power Pivot - Newcastle Under Lyme Excel Training Courses
Excel 365 Advanced Newcastle Under Lyme Training Courses