|
Standard |
|
R State Standard £ Developed College: n/a |
|
BUS 1150 - 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 |
Suggested Resources include textbooks shown
below or most current edition.
|
Media |
|
|
Print |
Cable, S. (2007). Succeeding in Business with Microsoft Office Access 2007: A Problem-Solving Approach. Mason,
OH: Cengage
Learning. |
|
Finnegan, K. & Adamski,
J. (2007). New Perspectives on
Microsoft Office Access 2007-Introductory. Mason, OH: Cengage
Learning. |
|
|
Friedrichsen, L. (2007). Illustrated Course
Guide: Microsoft Office Access
2007-Basic. Mason, OH: Cengage Learning. |
|
|
Gaskin, S. & Marks, S. (2007). GO! With Microsoft Access 2007-Brief.
New Jersey: Prentice Hall. |
|
|
Grauer, R., Lockley, M., Mulbery,
K. (2008). Microsoft Access 2007
Comprehensive. Upper Saddle River: Prentice Hall. ISBN: 13: 978-0-13-156788-7. |
|
|
Rutkosky, N., Seguin, D., Rutkosky, A. (2008). Microsoft Access 2007. St. Paul:
Paradigm Publishing. |
|
|
Rutkosky, R. (2007). Microsoft Access
2007: Level 1 Benchmark Series,
Minnesota: EMC Paradigm. |
|
|
Shelly, G., Cashman, T.,
Pratt, P., Last, M. (2007). Microsoft
Office 2007: Complete Concepts and
Techniques. Mason, OH: Cengage Learning. ISBN:
10: 1-4188-4340-3. |
|
|
Toliver, P. (2007). Microsoft Access
2007: Level 1. California: Labyrinth Learning. |
Posted: 10/22/08