Central Arizona College Back
CBA 134B Advanced Database Management in Access
Credit Hours:  3
Effective Term: Fall 2010
SUN#: None
Credit Breakdown: 2.75 Lectures, 1 Labs
Times for Credit: 1
Grading Option: A/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. (Analysis Level) Analyze and document a database system.
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.
5. (Synthesis Level) Design complex forms.
6. (Synthesis Level) Create complex reports.
7. (Synthesis Level) Create and customize user interface.
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. (Application 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
1. Given a business situation, investigate/analyze the need for a database system and plan the design of the system, determine appropriate data inputs and outputs.
2. Produce supporting documentation for the database system design using standardized diagramming techniques.
3. Define fields, files and relationships between database tables for the database system design.
4. Create forms, queries and reports to support the analysis phase for the database system design.
5. Produce a graphical user interface for a given database using switchboards and dialog boxes.
6. Use advanced features to create a standard interface for the user.
7. Create crosstab, create tables, append, delete and update queries, using wizards and SQL statements.
8. For a specified database, use a macro to enhance the performance of the graphical user interface by attaching macros to command buttons, use macros to validate data and run, and add actions to a form.
9. Given a basic database, use visual basic code to add functionality to forms, switchboards and dialog boxes.
10. Work with a group to create an automated database and present the finished system.