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

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: This email address is being protected from spambots. You need JavaScript enabled to view it.
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)