CSA 170 - Database: Access

3 Credits, 4 Contact Hours (2 lec., 2 lab)

Techniques for using Microsoft Access. Includes an overview of Microsoft Access, creating tables, working with tables, creating and using select queries, creating and using forms, creating and using reports, creating a report that contains totals, principles of table design and relationships, table design techniques, designing select queries, customizing form designs, working with data access pages, customizing reports, parameter and action queries, query joins and crosstab queries, using advanced form techniques, creating basic macros to automate forms, using macros to provide user interaction and automate tasks, using advanced report techniques, and Access, and the Internet.

Recommendation: Completion of CSA 089 or basic computer skills, completion of REA 091 or required score on the Reading assessment test before enrolling in this course. If any recommended course is taken, see a financial aid or Veteran’s Affairs advisor to determine funding eligibility as appropriate.