Central Arizona College Back
CBA 134B Advanced Database Management in Access
Credit Hours:  3
Effective Term: Fall 2016
SUN#: None
AGEC: None  
Credit Breakdown: 2.75 Lectures, 1 Lab
Times for Credit: 1
Grading Option: A, B, C, D, F

Description: Use of advanced features of software to customize a database, do advanced queries and reports, automate tasks and prepare supporting documentation.

Prerequisites: CBA134A

Corequisites: None

Recommendations: None

Measurable Student Learning Outcomes
1. (Synthesis Level) Analyze, design, plan and document a database system, determining appropriate data inputs, outputs, fields, files, tables and relationships.
2. (Comprehension Level) Identify data requirements in case studies and specify field parameters as part of record layout design process.
3. (Synthesis Level) Design report layouts and implement information management filing systems using computer software.
4. (Application Level) Use import wizards, advanced queries, and SQL statements to create tables; append, delete, and update data; and create crosstabs.
5. (Synthesis Level) Design complex forms.
6. (Synthesis Level) Create complex reports.
7. (Synthesis Level) Create and customize a graphical user interface using navigation forms and dialog boxes.
8. (Application Level) Apply customization to database tables, forms and reports.
9. (Application Level) Apply enhancement techniques for user interaction with advanced calculations and controls.
10. (Synthesis Level) Create macros to automate tasks.
11. (Application Level) Produce visual basic code for customization.
12. (Analysis Level) Examine object models and secure the database.
13. (Application Level) Prepare the database to connect to the World Wide Web.
14. (Synthesis Level) Design and implement a database project solution.
Internal/External Standards Accreditation