Microsoft Access Trainingin Belfast City
Centre
|
|
|
Access Intro Course
Access Advanced Course
Access VBA Course
|
Public Schedule training course in Belfast in Microsoft Access
CITB Approved - Our courses are registered |
|
|
|
Mullan Training have been providing comprehensive training in Microsoft Access - Intro, Advanced and VBA Levels - for more than 15 years, and can help you get to know the product and utilize the many tools and techniques available within this vast application. Our training suites are in
Belfast
We can provide training in:
|
| ||
Click here to view our Public Course Schedule
and see the dates we are running our courses
on... |
||
|
Microsoft Access Course Description |
Introduction |
||
Our Introduction to MS Access course is suitable for complete beginners to Microsoft Access. PrerequisitesA working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Access is required. BenefitsAt the end of this course you will have a good working knowledge of MS Access. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports. After completing this course you will be prepared to attend the Advanced MS Access training course.
| |||
Course Outline - click
here to view online or download as a Word document from our
website | |||
Views Available Within Access
Create New Database File
Database Tables – Create
Database Tables – Manipulate Records
Define Relationships
|
Forms
Queries
Reports
Create User Interface
|
Microsoft Access
Course Description |
Advanced |
||
Our 1 day A dvanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features. PrerequisitesA working knowledge of Access or our Introduction to MS Access course will allow sufficient knowledge to attend our Advanced MS Access c ourse. BenefitsAt the end of this course you will have a complete understanding of the higher functions of Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources. You will then be qualified to progress to our VBA Access course.
| |||
Course Outline - click
here to view online or download as a Word document from our
website
| |||
Create Expressions
Forms
Reports
|
Macros
Queries
|
Microsoft Access Course Description |
VBA
|
||
This 2 day course is suitable for Advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data. PrerequisitesA high proficiency of Microsoft Access is essential, or completion of our Advanced MS Access course . BenefitsAt the end of the course the delegate will have covered the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.
| |||
Course Outline - click
here to view online or download as a Word document from our
website
| |||
The VBA Programming Environment
Programming in the VBA Language Code Compilation
Error Handling in VBA
Class Modules and Form-Event Procedures
|
Manipulating Data through Data Access Objects and SQL
Changing Database Definitions through VBA
|
| |
|
|
|