Microsoft Access

Students can enrol and start the course any time of the year.

€275

https://www.kilroyscollege.ie/enrol.php?del=10

Overview
Microsoft Access Course
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 environment and the ability to complete tasks independently. The candidates should know and demonstrate the correct application of the principal features of Access.

The exam covers creating new databases, creating databases using templates, editing references between tables, navigating to specific records, creating new tables.

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
Exercises, 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, flashcards and exercises after each module to ensure you are confident on the topic you have completed before 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.

Unit 1: An Introduction to Database Development
Unit 2: Getting Started with Access
Unit 3: Creating Access Tables
Unit 4: Understanding Table Relationships
Unit 5: Working with Access Tables
Unit 6: Importing and Exporting Data
Unit 7: Linking to External Data
Unit 8: Selecting Data with Queries
Unit 9: Using Operators and Expressions in Access
Unit 10: Going Beyond Select Queries
Unit 11: Transforming Data in Access
Unit 12: Working with Calculations and Dates
Unit 13: Performing Conditional Analyses
Unit 14: Fundamentals of Using Access SQL
Unit 15: Subqueries and Domain Aggregate Functions
Unit 16: Running Descriptive Statistics in Access
Unit 17: Creating Basic Access Forms
Unit 18: Working with Data on Access Forms
Unit 19: Working with Form Controls
Unit 20: Presenting Data with Access Reports
Unit 21: Advanced Access Report Techniques
Unit 22: Using Access Macros
Unit 23: Getting Started with Access VBA
Unit 24: Mastering VBA Data Types and Procedures
Unit 25: Understanding the Access Event Model
Unit 26: Debugging Your Access Applications
Unit 27: Accessing Data with VBA Code
Unit 28: Advanced Data Access with VBA
Unit 29: Access and SQL Server
Unit 30: Customizing the Ribbon
Unit 31: Preparing Your Access Application for Distribution
Unit 32: Understanding Windows SharePoint Services
Unit 33: Integrating Access with SharePoint
Unit 34: Understanding Access Services
Unit 35: Deploying Access Applications to SharePoint
Unit 36: Using Access Data Macros

About Our Course
Who Should Do This Course
The Kilroy's College Microsoft Office Specialist (MOS) course is ideal for people wanting to develop the basic desktop skills they've learnt from day to day work. The course is aimed at people looking to improve these vital skills as a general introduction to the world of IT, or for people who have specific computer requirements and want to use them more effectively as part of their current job.

Frequently Asked Questions
Can Anybody Take This Course?
A high level of computer skill is not required for this course, however students will require a basic knowledge of Microsoft Office. You will need to own or have access to a PC as the course is a computer based learning programme.

How Soon Can I Start?
Right away if you wish! This is the great advantage of home study.

What Do I Need To Do This Course?
This is an online course delivered over the internet so you will need to own or have access to a PC or tablet computer and the internet.

What Is Microsoft Office Specialist Certification?
Earning Microsoft Office Specialist(MOS) certification acknowledges that you have the expertise to work with Microsoft Office programs. Office Specialist certification sets you apart in today's competitive job market, bringing employment opportunities, greater earning potential and career advancement, in addition to increased job satisfaction.

Tailored To Your Individual Needs
The Microsoft Office Specialist (MOS) Training course include expert instructor-led training modules with customized presentations, practice exam simulators and learning supplements for an all-inclusive computer based training program that provides all the benefits of classroom training at your own pace.

Office Specialist exams are administered at authorised testing centres. To locate a testing centre near you, visit www.certiport.com

Remember, You Can Complete This Course Within Six Months Of Enrolling. So Take Your First Step By Contacting Us Now - You Won't Regret It!

Ph: 01 639 4660
Fax: 01 662 0539
Email: info@kilroyscollege.ie