Course Description

Microsoft Office Specialist Access E-Learning

Pery Square Business College

Microsoft Office Specialist (MOS) Access Databases

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

Array

Array
Limerick City

Limerick, UK

View Phone Number

Book Course

Enquire for Info

View College Details Reviews

Add to Favourite

College Name	Pery Square Business College
Course Category	Computers & IT (Information Technology), Microsoft Access
Course Type	Online Learning
Course Qualification	Professional Qualification
Course Location	Limerick, UK
Course Start Date	13th January 2020
Course End Date	24th April 2020
Course Fee	€180
Course Duration	six months to complete
Course Times	Start Anytime - Contact College
Awarding Body	Microsoft
Title of Awarding	Microsoft Office Specialist Access
Entry Requirements	Good basic I.T. Skills
Career Path	Any industry requiring use and creation of databases