ACCESS TRAINING COURSES NEWCASTLE UPON TYNE
About Enable Technology Newcastle Upon Tyne Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the Access course is at a local training site. Every Access course can be modified to meet your bespoke 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 team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: University of Birmingham, Nationwide Building Society Limited, Lloyds TSB Bank PLC, Aston University, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Loughborough University and DHL Express.
Microsoft Access
- 2 day course
- Location: Newcastle Upon Tyne
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Importing and Exporting Records
- See Training Course Details...
Using a Navigation Form
Relational Database Design
Adding Transactional Records
Creating and Using Macros
Querying Techniques
Macro Techniques
Creating and Using Reports
Adding Records to a Table
Modifying Table Structures
Working With Records
DIY Forms
Action Queries
An Introduction to VBA
Creating and Using Forms
Multi Table Queries
Sorting and Filtering
Designing a Lookup Database
Parameter Queries
Database Wellness
Understanding VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Upon Tyne
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding Constants
- See Training Course Details...
Using the With Statement
Trapping Errors with the On Error Statement
Working with the ADODB Recordset Object
Using the Select Case...End Select Structure
Using the Object Browser
Working with Events
Declaring and Creating Object Variables
Working with the Code Editor
Debugging Code
Organizing Code and Procedures
Creating a Sub Procedure
Working with the Application Object
Controlling Program Execution
Understanding Classes and Objects
Working with Boolean Expressions
Understanding Modules
Using Intrinsic Constants
Understanding Procedures
Using Input Boxes
Email us about this courses
Other Newcastle Upon Tyne Enable Technology Training Courses
Oracle SQL - Newcastle Upon Tyne SQL Training Courses
DAX - Newcastle Upon Tyne Excel Training Courses
Excel 365 Intermediate - Newcastle Upon Tyne Excel Training Courses
JavaScript Newcastle Upon Tyne Training Courses
Excel 365 Advanced Newcastle Upon Tyne Training Courses
Report Builder Newcastle Upon Tyne Training Courses