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.
For information about Kilroy’s College, please visit our college page on www.nightcourses.co.uk by clicking here.

Course Provider

Kilroy’s College



(01) 662 0539
Wentworth House, Dublin, Republic of Ireland

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 Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

Kilroy’s College
Wentworth House
Dublin
Dublin
Visit Website