MOS Access E-Learning ( 2 Options ) See Options/Register  

  • MOS Access E-Learning

    Microsoft Office Specialist - Access Core 2016 E-Learning Package
    This course is aimed at participants who wish to gain an industry qualification in the Access database environment.  Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, and Viewing System Information.

  • Understanding Databases

    • Starting and Opening an Existing Database
    • Moving Around in Access
    • Understanding Datasheet View & Design View
    • Using the Mouse Pointer to Navigate
    • Using the Keyboard to Navigate

    Creating Tables

    • Creating a Database
    • Creating a Table Using the Wizard
    • Creating and Modifying a Table 
    • Adding Fields to Tables
    • Adding and Editing Records
    • Printing Tables
    • Moving and Deleting Fields
    • Deleting Records

    Working With Tables

    • Formatting a Table
    • Modifying Field Properties
    • Sorting Records in a Table
    • Finding Records in a Table
    • Using Filters with a Table
    • Establishing Relationships Between Tables
    • Creating Subdatasheets
    • Importing Records From an External Source

    Creating and Using Queries

    • Creating and Running a Query
    • Specifying Criteria in a Query
    • Using Comparison Operators
    • Creating a Calculated Field
    • Creating a Multiple-Table Query
    • Printing a Query

    Designing a Form

    • Creating a Form Using AutoForm
    • Creating a Form Using the Form Wizard
    • Adding Controls to a Form
    • Modifying Control Properties
    • Resizing and Moving Controls
    • Entering Records into a Form
    • Creating Calculated Controls

    Designing a Report

    • Creating a Report Using AutoReport
    • Creating a Report Using Report Wizard
    • Adding a Control to a Report 
    • Formatting a Report
    • Resizing and Moving Controls 
    • Creating Calculated Controls
    • Previewing and Printing
  • Exam:  You will complete an online test which must be taken at Pery Square Business College.   You will have 50 minutes to complete the MOS Online test.  Exams held on alternate Friday Afternoons from 2pm - Must book 1 Week in Advance.

    * subject to pass mark of 70% or more

     Exam results are displayed on your screen immediately after you complete an exam. Those who pass will receive (by post) an official certificate within approximately two to three weeks.

    While you can view the Learning Materials on any device, you will need a Microsoft Windows PC and Microsoft Office 2016 in order to complete the practice exams.

MOS Access Learning & Exam

MOS Access Learning & Exam
Includes E-Learning
Plus Practice Test & Exam & Free Resit
1 Week Advance Booking Required for Materials.
Start learning when you want - just contact College.
Exams carried out on Fridays at 2pm or 3.30pm.
Online Course Exams to be completed in our centre
Individual Price €180.00
€180.00

MOS Access Exam

MOS Access Exam 
Sit Exam on Fridays 2pm or 3.30pm.  
Call our office or email to Arrange Exam & cost
Price subject to requirement for exam voucher or not
Online Course Exams to be completed in our centre
Individual Price Free
Pery Square Business College & Staff Agency.
4 Pery Square, Limerick, Ireland.
Telephone: +353 (0)61 310155
Email:
Call or Email to discuss the right course for you.
European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)