Course Content and Outcome Guide for CAS 140 Effective Winter 2016
- Course Number:
- CAS 140
- Course Title:
- Beginning Access
- Credit Hours:
- Lecture Hours:
- Lecture/Lab Hours:
- Lab Hours:
- Special Fee:
Course DescriptionIntroduces the basic features of Microsoft Access. Covers beginning database management concepts including tables, forms, reports, queries, and basic macros. Stresses a working knowledge of database management vocabulary. Emphasizes efficient use of Access toolbars and menus. Discusses database design issues. Recommended: Placement into RD 115 and WR 115. Audit available.
Addendum to Course Description
This course is presented in a hands-on lecture/lab format. Self-paced format and online instruction may also be utilized. Out-of-class preparation will be required.
Intended Outcomes for the course
Upon successful completion of this course, student will be able to:
1. Use Microsoft Access to create personal and/or business databases following current professional and/or industry standards.
2. Use critical thinking skills to design and create database objects.
3. Communicate in a business setting using database management vocabulary.
Outcome Assessment Strategies
A letter grade will be issued for this course based upon
- Performance tests
- May include objective tests, scored assignments, or projects
- May include the use of skill assessment software
Course Content (Themes, Concepts, Issues and Skills)
Themes, Concepts, Issues
- Communicate effectively using appropriate database management vocabulary.
- Use critical thinking and problem solving skills in designing databases for various business and personal projects.
- Proofread for accuracy in the entry of data and creation of database objects such as, tables, reports, forms and queries.
- Assess the databases for accuracy, readability, and appearance.
- Develop efficiency with specific sets of skills through repetitive reinforcement.
- Students will develop proficiency through reinforcement and assessment on the following skills:
- Creating tables by defining fields composed of various data types and entering text and numeric records.
- Creating and modifying forms including sub-forms.
- Creating, modifying and customizing basic, grouped and summary reports.
- Use queries to update and delete records, sort information and create reports.
- Designing and creating queries using wildcard characters, multiple criteria, joined tables, and calculated fields.
- Create and modify basic switchboard interfaces using simple macros
- Establish relationships between two tables to ensure integrity and accuracy
- Design and create a database management system from scratch using original information.
Students will be familiar with the following skills:
- Using help features.
- Establishing relationships between more than two tables
- Printing mailing labels
- Documenting and compacting databases
- Using additional functions such as combo boxes.
- Using additional field data types such as memo, OLE, and hyperlink fields
- Students may be exposed to additional database management skills/concepts as time allows.