Standard

 

 R State Standard         £  Developed          College: n/a

 

ACC 105 - Database Applications

 

Course Description

Emphasizes use of database management software packages to access, manipulate, and create file data. Topics include: database concepts structuring databases, entering data, organizing data, and managing databases.

 

Competency Areas

Hours

Database Concepts

Class

1

Structuring Databases

D. Lab

4

Entering Data

P. Lab/O.B.I.

0

Organizing Data

Credit

3

Managing Databases

 

 

 

Prerequisite:

SCT 100

Corequisite:

     

 

Course Guide

 

Competency

After completing this section, the student will be able to:

Hours

Class

D.Lab

P.Lab/

O.B.I.

DATABASE CONCEPTS

1

4

0

Terminology

Define basic terminology relating to database software.

 

 

 

 

Describe differences between database and spreadsheet applications.

 

 

 

 

Describe basic relational database design principles and components.

 

 

 

STRUCTURING DATABASES

5

20

0

Creation

Create databases.

 

 

 

 

Create and modify tables.

 

 

 

 

Define and modify field types.

 

 

 

 

Modify field properties (input masks, data types, etc.).

 

 

 

 

Create and modify one-to-many relationships.

 

 

 

 

Enforce referential integrity.

 

 

 

 

Create and modify queries.

 

 

 

 

Create and modify forms.

 

 

 

 

Create and modify reports.

 

 

 

Entering Data

1

4

0

Navigation

Find and move among records.

 

 

 

 

Enter, edit, and delete records.

 

 

 

 

Import data into the database from another source.

 

 

 

ORGANIZING DATA

2

8

0

 

Create and modify calculated fields and aggregate functions.

 

 

 

 

Modify form layout.

 

 

 

 

Sort and filter records.

 

 

 

 

Modify report layout and page setup.

 

 

 

 

Format datasheets.

 

 

 

MANAGING DATABASES

1

4

0

 

Print reports and labels.

 

 

 

 

Print database objects and data.

 

 

 

 

Export data from the database to other applications.

 

 

 

 

Backup, compact and repair a database.

 

 

 

 

Database security concepts.

 

 

 

 

Suggested Resources

 

Media
(Print
Audio/Visual
Web
Other)

Note: Please adhere to the APA Formatting and Style Guidelines.
Examples:
   Author, A. A. (Year of publication). Title of work: Capital letter also for subtitle. Location: Publisher.

   Duncan, G.J., & Brooks-Gunn, J. (Eds.). (1997). Consequences of growing up poor. New York: Russell Sage Foundation.

Print

Cable, S. (2007). Succeeding in Business with Microsoft Office Access 2007:  A Problem-Solving Approach. Mason, OH:  Cengage Learning.

Print

Finnegan, K. & Adamski, J. (2007). New Perspectives on Microsoft Office Access 2007-Introductory. Mason, OH: Cengage Learning.

Print

Friedrichsen, L. (2007). Illustrated Course Guide:  Microsoft Office Access 2007-Basic. Mason, OH:  Cengage Learning.

Print

Gaskin, S. & Marks, S. (2007). GO! With Microsoft Access 2007-Brief. New Jersey:  Prentice Hall.

Print

Grauer, R., Lockley, M., Mulbery, K. (2008). Microsoft Access 2007 Comprehensive. Upper Saddle River: Prentice Hall. ISBN:  13: 978-0-13-156788-7.

Print

Reding, E. & Wermers, L. (2008).  Illustrated Series, Microsoft Office Excel 2007 Coursecard Edition (Expert Complete). Mason, OH.:  Cengage

Print

Rutkosky, N., Seguin, D., Rutkosky, A. (2008). Microsoft Access 2007. St. Paul: Paradigm Publishing. ISBN: 978-0-76383-004-5.

Print