Course Number: CAS 140
Transcript Title: Beginning Access
Created: September 1, 2012
Updated: December 19, 2014
Total Credits: 3
Lecture Hours: 10
Lecture / Lab Hours: 40
Lab Hours: 0
Satisfies Cultural Literacy requirement: No
Satisfies General Education requirement: No
Grading options: A-F (default), P-NP, audit
Introduces the basics 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.
Upon successful completion of this course, student will be able to:
- Use Microsoft Access to create personal and/or business databases following current professional and/or industry standards.
- Use critical thinking skills to design and create database objects.
- 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.
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.