Course Description
Microsoft Access – IT Skills Course for Microsoft Office Specialist Test
Kilroy’s College
For FREE course brochure please visit www.kilroyscollege.ie/free_brochure
The 77-424 certification test is primarily intended for professionals who have experience with previous versions of Microsoft Office Access. The exam is designed for candidates who have a fundamental understanding of the Access 2013 environment and the ability to complete tasks independently. The candidates should know and demonstrate the correct application of the principal features of Access 2013.
The exam covers creating new databases, creating databases using templates, editing references between tables, navigating to specific records, creating new tables.
Course Contents
An Introduction to Database Development
Getting Started with Access
Creating Access Tables
Understanding Table Relationships
Working with Access Tables
Importing and Exporting Data
Linking to External Data
Selecting Data with Queries
Using Operators and Expressions in Access
Going Beyond Select Queries
Transforming Data in Access
Working with Calculations and Dates
Performing Conditional Analyses
Fundamentals of Using Access SQL
Subqueries and Domain Aggregate Functions
Running Descriptive Statistics in Access
Creating Basic Access Forms
Working with Data on Access Forms
Working with Form Controls
Presenting Data with Access Reports
Advanced Access Report Techniques
Using Access Macros
Getting Started with Access VBA
Mastering VBA Data Types and Procedures
Understanding the Access Event Model
Debugging Your Access Applications
Accessing Data with VBA Code
Advanced Data Access with VBA
Access and SQL Server
Customizing the Ribbon
Preparing Your Access Application for Distribution
Understanding Windows SharePoint Services
Integrating Access with SharePoint
Understanding Access Services
Deploying Access Applications to SharePoint
Using Access Data Macros
Our Microsoft Access course includes
Expert Instructor-Led Training
We use the content from the finest publishers and only the IT industry’s finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.
Interactive Exercises
Our courseware includes include real world, interactive exercises. The exercises always focus on real world scenarios and skill-set development.
Exercises, Quizzes & Flashcards
Exersizes, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcardsand exercises after each module to ensure you are confident on the topic you have completedbefore proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.
Practice Test Sets
Our course also include full length practice test sets designed to test your knowledge under real exam conditions. The course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.
Exam Simulators
There are online labs to supplement your training. These labs are inexpensive and way safe to explore and learn. They are versatile – labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.
Please note that this course is available for the following MS Office versions:
- Microsoft Office 2013
- Microsoft Office 2010
- Microsoft Office 2007
More about course:
For more information about this course please visit www.kilroyscollege.ie/ms_access
| College Name | Kilroy’s College |
| Course Category | Computers & IT (Information Technology), Microsoft Access |
| Course Type | Online Learning |
| Course Qualification | Award / Certificate |
| Course Location | Dublin, UK |
| Location Postcode | Dublin 2 |
| Delivery mode | Elearning |
| Course Fee | 225.00 |
| Course Duration | 12 months |
| Course Times | All year enrolling |
| Awarding Body | Microsoft |
| Title of Awarding | Microsoft Office Specialist |
| Entry Requirements | The good news is that you don’t need any previous experience or qualification to take this Microsoft Access course. |
Course Provider
