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.
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
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.
Our courseware includes include real world, interactive exercises. The exercises always focus on real world scenarios and skill-set development.
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.
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.
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:
For more information about this course please visit www.kilroyscollege.ie/ms_access
| Location Postcode | Dublin 2 |
| Course Category | Microsoft Access, Computers & IT (Information Technology) |
| Course Type | Online Learning |
| Course Qualification | Award / Certificate |
| Awarding Body | Microsoft |
| Awarding Body Details | Microsoft Office Specialist |
| Course Duration | 12 months |
| Course Time | All year enrolling |
| Course Fee | 225.00 |
| Entry Requirements | The good news is that you don’t need any previous experience or qualification to take this Microsoft Access course. |
The objective of this Business Administration distance learning course is to develop your understanding of the administration of an organization, enabling you to appreciate the impacts of the factors which may affect a business.
Would you like to see your writing in print? Could you write a best seller? Our experienced Creative Writing tutor will guide and help you to develop your writing skills throughout your Kilroy’s College Creative Writing course.
This general Education Studies course will provide you with a sound basic knowledge in Mathematics, Written English and recent Irish History.
By studying our Nail Technician course you will learn the skills and acquire the knowledge you will need to succeed in the nail business.
