MOS Access E-Learning Contact Us For Dates  

  • 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.

There are no events in the selected category

European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)