Course Description

Microsoft Access - IT Skills Course for Microsoft Office Specialist Test



Microsoft Access - IT Skills Course for Microsoft Office Specialist Test is a course run by Kilroy's College, Dublin. It is a Online Learning course with a duration of 12 months. Microsoft Access - IT Skills Course for Microsoft Office Specialist Test gives a Course Qualification of Award / Certificate, awarded by Microsoft. For more information about Microsoft Access - IT Skills Course for Microsoft Office Specialist Test at Kilroy's College, please review the details below.

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


The Microsoft Access - IT Skills Course for Microsoft Office Specialist Test course at Kilroy's College is listed in Courses.ie's national courses finder.
Training ProviderKilroy's College
Course LocationDublin
Location PostcodeDublin 2
Course TypeOnline Learning
Course QualificationAward / Certificate
Awarding BodyMicrosoft
Awarding Body DetailsMicrosoft Office Specialist
Course Duration12 months
Course TimeAll year enrolling
Course Fee225.00
Entry RequirementsThe good news is that you don’t need any previous experience or qualification to take this Microsoft Access course.
Phone(01) 639 4660
For more information about Kilroy's College, please visit our College page on Courses.ie by clicking here.

Course Provider

Kilroy's College



Wentworth House, Dublin City South, Dublin, Republic of Ireland. Eircode: D02 Y970

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Kilroy's College
Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the Courses.ie community.
 

Map

Kilroy's College
Wentworth House
Dublin City South, Dublin
Dublin
Visit Website