Computer Information Science American River College
Courses

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: