1 / 20

Developing and Maximizing the Potential of A QA/QI Database

Learn how to develop and maximize the potential of a QA/QI database, including selecting a database model, translating customer needs into a design, creating queries, and more.

grimm
Download Presentation

Developing and Maximizing the Potential of A QA/QI Database

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. Developing and Maximizing the Potential of A QA/QI Database Michele Gomez, CIP Senior QA/QI Analyst Partners Healthcare Quality Improvement Program

  2. Outline • Developing A QA/QI Database • An Insightful Tale • Quality as Defined by the QA/QI Customer • Selecting a Database Model • Translating Customer Needs into a Design • Additional Design Considerations for QA/QI Databases • Using MS Access Wizards to Develop Database Objects • Maximizing the Potential of a QA/QI Database • Splitting a Database • Creating Queries in MS Access • Practical Advantages of Queries • Re-inventing the Wheel • Helpful Resources

  3. The Ice Cream Maker • Subir Chowdhury’s insights into quality: • Quality is defined by the customer and you can get their definition only by listening to them • The real key isn’t so much to fix things as it is to design them right in the first place…(Chowdhury, 2005)

  4. Quality as defined by the QA/QI Customer

  5. Selecting a database Model • Relational Databases • A database model developed by E. F. Codd that makes it simple for end users to efficiently “store, modify and access data” through a collection of linked tables (Chappell & Trimble Jr, 2002) • Database Terms • Tables • Fields • Keys • Relationships • Examples • FileMaker 8 • MS Access • MS SQL Server

  6. Translating Customer Needs into a Design • Peter Chen’s Entity Relationship Diagram (ERD) • Visual representation of a database’s tables, fields and relationships (Shiflet, 2002) • ERD symbols and description

  7. ERD Example QA/QI Need Design Dept ID Dept Name Types of IRB submissions by department Protocol # Dept ID 1 Department Associated with 1 Protocol 1 can have Submission ID Protocol # M IRB Submissions Submission Type

  8. Additional Design Considerations Considerations • Fields • Audit (type, date, conducted by) • Observation (description, corrective action, references) • Conclusion/concerns QA/QI Needs • Count of audits by type • Observations by rank • Summary of findings

  9. Using MS Access Wizards to develop database objects • MS Access contains built-in support (Wizards) for creating database objects: • Tables (main and lookup) • Forms • Reports • Wizards provide sample layouts for data entry forms and printed reports • Using Wizards does not require prior programming experience (e.g. Visual Basic for Applications) Database Window

  10. The Ice Cream Maker • Subir Chowdhury’s insights into quality: • Encourage each other in a way that lets everyone know they are part of ... the team • Get a few people around a table, pick a concern and generate as many ideas for solving it • If you want to stay ahead in your business…you need to keep re-inventing the wheel (Chowdhury, 2005)

  11. Back End (BE) Front End (FE) Splitting a Database Susan Desktop copies of linked tables and FE John Sally Password Protected Data Warehouse Joe Dan

  12. Creating Queries in MS Access • Options • Built-in Query Wizard • Screen for developing SQL statements • Types of Queries • Select Query (select, sort, group, calculate) • Cross-tab Query (summarize) • Selection criteria • Operators Design View

  13. Practical Advantages of Queries • Provide education • Develop resources • Close gaps • Develop customized solutions

  14. Group Discussion

  15. Re-Inventing the Wheel • Version 2.0 • Sustainable system • Online request forms for IRB members & study staff • Web-based interfaces for QA/QI staff • Instruction Manual

  16. Bibliography • Chappell, D., & Trimble Jr., H. J. (2002). A Visual Introduction to SQL. New York: John Wiley & Sons. • Chowdhury, S. (2005). The Ice Cream Maker An Inspiring Tale about Making Quality the Key Ingredient in Everything you Do. New York: Currency Doubleday. • Shiflet, A. (2002). Entity Relationship Model. Retrieved April 2014, from Data and Visualization : http://wofford-ecs.org/DataandVisualization/ermodel/material.htm Other Resources Choosing between Microsoft Access and FileMaker Pro by Miriam Engelberg Splitting a Microsoft Access Database http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx

  17. Questions

  18. Hyperlinks

More Related