130 likes | 217 Views
Database Design 1. CMS 476 Fall 1, 2007 Dr. Karl Horak, Instructor. Session 7. International Talk Like a Pirate Day Week in Review Application du Jour Lecture: Procedural Aspects Demonstration: VBA Exercises. Week in Review. Chemical Weapons Convention InterLab IRP Proposals.
E N D
Database Design 1 CMS 476 Fall 1, 2007 Dr. Karl Horak, Instructor
Session 7 • International Talk Like a Pirate Day • Week in Review • Application du Jour • Lecture: Procedural Aspects • Demonstration: VBA • Exercises
Week in Review Chemical Weapons Convention InterLab IRP Proposals
Application du Jour • ACE-IT • Online onsite inspection training • ASP-based (VB Script) • Embedded iPix • Database-driven VR image control • http://poirot.cmc.sandia.gov/aceit5/
Gatekeeper.asp (pending)
Tonight’s Lecture Topic:Properties & Procedural Aspects • More about control properties • Data properties • How to mix data from multiple sources • Event properties • OnClick • OnDoubleClick • OnUpdate • OnCurrent
Procedural SQL • What kind of situations require procedural solutions? • Complex calculations with multiple dependencies • Time-dependent transactions • Workflow issues • Automated data conversion
Transaction Processing • Beginning a transaction • Setting rollback points • Ending a transaction • Rollback • Commit
Workflow Submit item for approval • Procedural rules outline who does what in which order • For example, document review & approval by several managers Manager Approval No Yes Classification Review No Yes Item Approved
Macros—A Procedural Environment for Access • Macros essentially record keystrokes • Access macro editor • Don’t forget to disable/turn off alerts, confirmation messages, and all that jazz
VBA—A Procedural Language for Access • A subset of Visual Basic • Extensible with the addition of extra references (dll’s) • Many common problems have been already solved • Solutions are online • Woody’s Access Watch is my favorite go-to resource—check their archives first (http://office-watch.com/access/index.asp)
Demonstration • Useful properties • Responding to user choices • Radio buttons and frames • Combo-box coordination • Subforms • Macros • Echo • SetWarning • VBA • The sky is the limit • Think long and hard about deployment environment http://70.56.215.209/khorak/CSF/SQLexercises.mdb
Exercises and Q&A • Homework #3 is the Daisy Hill Puppy Farm design, due by midnight Thurs. Sept. 26 after Session 8. • The final exam will be posted after Session 8 (early Fri. Sept. 28) and will be due by the end of class Session 9.