OADM 135 - Microsoft® Access

3 Credits: (3 lecture)

Course Description
This course provides a comprehensive knowledge of Microsoft® Access and its capabilities to create and utilize databases for professional purposes. Students will learn the proper procedures for database creation and management.

Note Mac and Chromebook computers ARE NOT recommended for this course due to software required in the course. A computer with a current WINDOWS operating system is highly recommended for off-campus work. Fall semester only.

Corequisite OADM 107 or COMP 210.

Text
Cable, S. & Monk, E. (2020). Shelly Cashman series® Microsoft® Office 365® & Access® 2019 comprehensive (1st ed.). Boston, MA: Cengage Learning.

Objectives
The student will be able to:

A. Create database objects: tables, reports, forms, and queries.

B. Modify database objects.

C. Use queries to gather information.

D. Maintain a database.

E. Employ integration tools to incorporate other Microsoft® applications.

F. Perform database administration tasks.

Content
A. Databases and database objects

B. Tables

C. Queries

D. Forms

E. Reports

Student Evaluation
Objectives A through F will be assessed through textbook and simulation software assignments, application and written tests and/or quizzes, and a comprehensive final exam.