Cookies on the Belfast Met website

We use cookies to ensure that you receive the best experience of our website. By continuing to use our website you are agreeing to our use of cookies. For more information about cookies and how to manage them, read our Cookie Policy.

Microsoft Office Specialist Access 2016

Course Code: C3215
Campus: Titanic Quarter
Week Commencing: 29 Jan 18
End Date: 23 Jun 18
Time: 17:30-19:30
Day of Week: Tuesday
Whilst no formal entry qualifications are required, it is expected that applicants will be confident computer users and desirably have experience of MS Office (any version) within the working/home environment. Students who have Microsoft Office Specialist qualifications in earlier versions may wish to update to the new version.
This course is not suitable for absolute beginners.
The course content consists of:
1. Structuring a Database
1.1. Define data needs and types
1.2. Define and print table relationships
1.3. Add, set, change, or remove primary keys
1.4. Split databases
2. Creating and Formatting Database Elements
2.1. Create databases
2.2. Create tables
2.3. Modify tables
2.4. Create fields and modify field properties
2.5. Create forms
2.6. Create reports
2.7. Modify the design of reports and forms
3. Entering and Modifying Data
3.1. Enter, edit, and delete records
3.2. Navigate among records
3.3. Find and replace data
3.4. Attach documents to and detach from records
3.5. Import data
4. Creating and modifying queries
4.1. Create queries
4.2. Modify queries
5. Presenting and Sharing Data
5.1. Sort data
5.2. Filter data
5.3. Create and modify charts
5.4. Export data
5.5. Save database objects as other file types
5.6. Print database objects
6. Managing and Maintaining Databases
6.1. Perform routine database operations
6.2. Manage Databases

Places remaining: 16

Download enrolment form

Career Opportunities / Progression

Microsoft Office Specialist (MOS) is a globally recognised standard that validates skills in Microsoft Office 2016 and the Windows operating system. This MOS credential meets the demand for the most up-to-date skills using the latest technologies from Microsoft.


Tuition Fee


All fees are set in accordance with DfE regulations.

Other Information

The MOS exams are taken at the end of the course. This on-line exam consists of practical tasks using MS Office 2016 and the results are displayed on completion.