|
CISA 322: Design and Development of Desktop Database
Applications
|
Units: |
3.00 |
Prerequisite: |
CISA 320 (Introduction
to Database Management) with a grade of "C" or
better |
Hours: |
36 hours lecture, 54
hours laboratory |
Description: |
This course covers
strategies for the design and development of desktop
database applications. Topics include database
objects, data types, data integrity, relational
tables, joins, relationships, domain constraints,
complex queries, forms, reports, sharing data with
other applications, and data maintenance. |
|
Section 3: Learning Outcomes and Objectives
Upon completion of this course, the
student will be able to:
- analyze needs and determine appropriate data
structures and solutions.
- create tables, queries, forms, and reports.
- formulate multiple table queries with complex
criteria.
- design forms for data entry and data views.
- interpret data with crosstab queries, pivot tables,
and reports.
- build tables by importing delimited data and
exporting data to spreadsheet applications.
- design and implement multiple table data management
systems involving custom forms, reports, and labels.
- manage, backup, and repair database objects.
|
Certificates requiring this course:
|