TRI-COUNTY TECHNICAL COLLEGE

 

COURSE SYLLABUS

 

Course Prefix & Number: AOT 263

Course Title: Office Database Applications (On-line Course)

 

Credits

Awarded: 3

 

 

 

 

Catalog Description:

 

This course introduces the concepts and structures of a database and the application of the concepts in an office environment (MS Access).

 

Entry Level Skills: None

 

Pre-requisites: AOT 105-Keyboarding

 

 

Co-requisites: None

 

 

Text(s)/Required Materials:

 

GO! with Microsoft Access 2007, Volume 1

Gaskin, Marks, and Townsend

 

Storage media: USB flash drive

 

Hardware & Software Requirements:

 

Regular and reliable access to a computer with at least the following:

 

         An Internet-connected PC running Windows XP with Internet Explorer 7.0 and MS Office 2007 installed
(Students who do not have access to a PC configured as above may use the campus Open Computer Lab to complete coursework)

 

         Stereo headphones (1/8 jack) (optional)

 

Course Competencies and Objectives:

 

Upon successful completion of this course, the student should be able to:

 

1.      Create a database.

2.      Sort and query a database.

3.      Maintain a database.

4.      Create reports and forms to present data.

5.      Design and build a relational database.


 

Major Course Topics:

 

1.      Creating and Using a Database

2.      Sorting and Querying a Database

3.      Creating Forms, Filters, and Reports

4.      Designing and Building a Relational Database

5.      Automating Data Entry with Forms

6.      Creating Advanced Reports

 

Grade Calculation Method:

 

Assignments

Project Tests

 

 

= 40 percent

= 60 percent

100 percent

 

Prepared by: Administrative Office Technology Faculty Date written or revised: June 2008


 

Tri-County Technical College

Course Syllabus Approval Form

 

Course Prefix and Number: AOT 263

 

Course Title: Office Database Applications (On-line Course)

 

 

Syllabus prepared by: Administrative Office Technology Faculty

 

Date written or revised: May 2008

 

Approved: _______________________________ _____________

(Department Head) (Date)

 

Approved: _______________________________ _____________

(Dean, Business and Public Services) (Date)