1 / 13

Database Design: Procedural Aspects and VBA Training

Learn about the procedural aspects of database design, including SQL transactions and VBA scripting. Explore control and event properties, macros, and more. Access online resources for solutions and practical demonstrations. Prepare for the final exam with exercises and Q&A sessions.

shen
Télécharger la présentation

Database Design: Procedural Aspects and VBA Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design 1 CMS 476 Fall 1, 2007 Dr. Karl Horak, Instructor

  2. Session 7 • International Talk Like a Pirate Day • Week in Review • Application du Jour • Lecture: Procedural Aspects • Demonstration: VBA • Exercises

  3. Week in Review Chemical Weapons Convention InterLab IRP Proposals

  4. 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/

  5. Gatekeeper.asp (pending)

  6. 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

  7. Procedural SQL • What kind of situations require procedural solutions? • Complex calculations with multiple dependencies • Time-dependent transactions • Workflow issues • Automated data conversion

  8. Transaction Processing • Beginning a transaction • Setting rollback points • Ending a transaction • Rollback • Commit

  9. 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

  10. 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

  11. 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)

  12. 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

  13. 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.

More Related