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)