Business Office Technology - Microsoft Access

Microsoft Access (BTEC 2110)

Total Credits: 3
Lecture Credits: 3.00

Description: This Microsoft Office Access course is designed to cover all of the learning objectives for the Microsoft Office Specialist (MOS) exam. MOS-approved textbooks and courseware are used for this course. You will learn to create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Skills you will learn include: managing the access environment, building tables, building forms, creating and managing queries, and designing reports. Must be taken A-F.

Topical Outline:

Learning Outcomes:
1. 1. Identify Good Database Design
2. 2. Create, Sort, Query, and Print a Query, Form and Report
3. 3. Create and Use a Form to Add and Delete Records
4. 4. Filter Records, Modify and Customize the Design and Form of a Report
5. 5. Enhance and Manage Existing Tables and Use Microsoft Access Analysis Tools
6. 6. Encrypt and Decrypt, and Create a Locked Database

Prerequisites: 

BTEC 1020