ACCESS TRAINING COURSES PRESTON
About Enable Technology Preston Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each Access training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We can also deliver the Access course at a local training venue in Preston. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Carillion PLC, Dollond & Aitchison Limited, Keele University, Homeserve PLC, University of Birmingham, Canadian High Commission, GKN PLC and Fujistu PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Preston
- Telephone on 01952 938014
- 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 ... Organizing Code and Procedures
- See Training Course Details...
Using Message Boxes
Using Input Boxes
Working with Events
Understanding the Form Object
Debugging Code
Using Expressions, Variables, and Intrinsic Functions
Specifying a Recordset Cursor Type
Declaring Variables
Using Intrinsic Constants
Calling Procedures
Writing an Error-Handling Routine
Working with Methods
Using Visual Basic Help
Understanding the DoCmd Object
Handling Errors
Using the For...Next Structure
Understanding Data Types
Understanding the Development Environment
Microsoft Access
- 2 day course
- Location: Preston
- 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 ... Working With Records
- See Training Course Details...
Modifying Forms
DIY Forms
Adding Records to a Table
Designing a Lookup Database
Database Security
Macros on Forms
Creating a Relational Database
Creating a Lookup Database
Using a Navigation Form
Creating Queries
Calculations in Queries
Understanding VBA
Setting Table Relationships
An Introduction to VBA
Macro Techniques
Importing and Exporting Records
Creating and Using Reports
Relational Database Design
Database Wellness
Adding Transactional Records
Email us about this courses
Other Preston Enable Technology Training Courses
SSAS Tabular Preston Training Courses
DAX Preston Training Courses
VBA Preston Training Courses
JavaScript Preston Training Courses
JQuery Preston Training Courses
Excel 365 Intermediate - Preston Excel Training Courses