Central Arizona College Back
CBA 134A Database Management in Access
Credit Hours:  3
Effective Term: Fall 2010
SUN#: None
Credit Breakdown: 2 Lectures, 3 Labs
Times for Credit: 1
Grading Option: A/F

Description: Design and create relational databases. Query, report and produce forms on the data and publish to the Web. Skills learned will cover the Core Level skills for Microsoft Certified Application Specialist (MCAS): Microsoft Office Access 2007.

Prerequisites: Basic Windows and file management knowledge

Corequisites: None

Recommendations: None

Measurable Student Learning Outcomes
1. (Synthesis Level) Design and create relational databases.
2. (Application Level) Modify a database design.
3. (Application Level) Implement- Define relationships between tables.
4. (Application Level) Use logical operators and arithmetic expressions in queries, filters, and reports.
5. (Application Level) Use multiple tables in a database for calculations and queries.
6. (Synthesis Level) Design a Customized form for efficient input of data using OLE Fields, Hyperlinks, and Sub forms.
7. (Application Level) Use printer to obtain hard copy output of database objects such as reports and file structures.
8. (Synthesis Level) Create formatted reports with controls.
9. (Application Level) Use Switchboards, Pivot Tables, and Pivot Charts.
10. (Synthesis Level) Integrate database with other applications.
11. (Synthesis Level) Manage-Maintain a database Using the Design and Update Features of Access.
12. (Knowledge Level) Duplicate - Visual Basic for Applications (VBA) code.
Internal/External Standards Accreditation
Successful completion of a Microsoft (MCAS) Access exam with 80% accuracy or:

1. Plan and design a database to determine appropriate data input and output. Create tables using the Table Wizard, set primary keys, modify field properties and input data to meet specific criteria.
2. Modify tables by correctly using the lookup wizard and input mask wizard.
3. In a given database, establish relationships and enforce referential integrity between tables.
4. Find and sort records, apply and remove filters, specify criteria in a query to produce requested information.
5. In a given database, display related records in a sub-datasheet; create a calculated field and create and modify a multi-table select query.
6. Create user friendly business forms using the Form Wizard and add controls, modify field properties, use multiple data types, and modify using Design View to add grouping and sorting levels, and calculated controls.
7. Correctly use print options, print reports, tables, and other database objects.
8. Produce professional quality reports using the Report Wizard, add headers, footers, groups, sorting and detail sections.
9. Produce reports that demonstrate how to correctly add, move and resize a control, modify format properties, use report sections and use a calculated control in a report.
10. Import specified data to a new table and append records to an existing table from a spreadsheet, a text file, a word processor, and another database; save and publish to the Web, and add hyperlinks.
11. Use database tools to print database relationships, backup and restore a database, compact and repair a database.