ACCESS TRAINING COURSES CARMARTHEN
About Enable Technology Carmarthen Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite training location in Carmarthen. All Access courses can be customised to meet your particular 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Boots UK Limited, Aston University, Royal & Sun Alliance Group PLC, Total Telecommunications Limited, DHL Express, South Staffordshire Water PLC, Carillion PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Carmarthen
- 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 ... Creating a Relational Database
- See Training Course Details...
Formatting Tables
Creating Queries
Navigation Pane Protection
Using a Navigation Form
Parameter Queries
Action Queries
Designing a Lookup Database
Multi Table Queries
Sorting and Filtering
DIY Forms
Modifying Table Structures
Adding Transactional Records
Calculations in Queries
Modifying Forms
Creating and Using Forms
Creating and Using Macros
Relational Database Design
Creating and Using Reports
Aggregation Queries
Macros on Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Carmarthen
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Why Program in Access?
Working with the Code Editor
Working with Variable Lifetime
Working with Variable Scope
Using Intrinsic Functions
Working with Events
Controlling Program Execution
Declaring Variables
Working with the Application Object
Trapping Errors with the On Error Statement
Using the With Statement
Working with Procedures and Functions
Understanding the Err Object
Using the For Each...Next Structure
Using the Immediate Window to Call Procedures
Using the Do...Loop Structure
Working with Inline Error Handling
Understanding VBA's Error Trapping Options
Using Expressions, Variables, and Intrinsic Functions
Email us about this courses
Other Carmarthen Enable Technology Training Courses
Power Query Carmarthen Training Courses
SSIS - Carmarthen SQL Server Integration Services Training Courses
Oracle SQL - Carmarthen SQL Training Courses
Excel Power Pivot - Carmarthen Excel Training Courses
VBA Carmarthen Training Courses
TSQL Carmarthen Training Courses