Surgery and Sterile Processing OR Procedure Card Database

 

  1. Secure Password into Database:

 

  1. Security Switchboard:

 

  1. User Access (Can only Select and Print Procedure Cards):

 

  1. Edit Security Login (Cannot Edit/Add/Delete Tables, only Procedure Cards):

 

  1. Edit Form:

 

  1. Full Edit Security Login:

 

  1. Full Edit Main Form:

 

7-1. Full Edit Delete in Tables View:

 

7-2. Full Edit Add/Update in Tables View:

 

7-3. Full Edit Additional Information View:

 

7-4. Full Edit Graphics View:

 

7-5. Add New Procedure Card (Top of Full Edit Form):

 

7-5-1. Delete Line Report:

 

7-5-2.     Change Log for Table Changes:

 

7-6. Create A Report (Top of Full Edit Form):

 

7-6-1. Selected Procedure Card Report:

 

7-7. Specific Procedure Card Update (Top of Full Edit Form):

 

7-7-1. Specific Procedure Card Update Form:

 

7-8. Specific Procedure Card Delete (Top of Full Edit Form):

 

7-8-1. Specific Procedure Card Delete Form:

 

7-9. Procedure w/All Physicians Update/Delete (Top of Full Edit Form):

 

7-9-1. Select Procedure with All Physicians to Update:

 

7-9-2. Selected Procedure with All Physicians to Update Form:

 

7-9-3. Select Procedure with All Physicians to Delete (Top of Full Edit Form):

 

7-9-4. Selected Procedure with All Physicians to Delete Form:

 

7-10. Physician w/All Procedures to Update/Delete (Top of Full Edit Form):

 

7-10-1. Select Physician with All Procedures to Update:

 

7-10-2. Selected Physician with All Procedures to Update Form:

 

7-10-3. Select Physician with All Procedures to Delete:

 

7-10-4. Selected Proc. / Phys. To Delete Form:

 

7-11. List of Records (Top of Full Edit Form):

 

7-11-1. Equipment List (Example):

 

7-12. Open Complete Change Log (Middle of Full Edit Form):

 

7-12-1. Preview Selected User Report:

 

7-13. Edit Users Edit Table (Middle of Full Edit Form):

 

7-14.        Edit Users Full Edit Table (Middle of Full Edit Form):

 

7-15. Add/Update In Tables (Middle of Full Edit Form):

 

7-15-1. Selected Equipment Add/Update (Example):

 

7-16.        Delete in Tables (Middle of Full Edit Form):

 

7-16-1. Selected Equipment Delete in Table (Example):

 

7-17.        Additional Information Field in Tables (Bottom of Full Edit Form):

 

7-17-1. Selected Additional Info. Field in Tables:

 

7-18.        Graphics Picture Field in Tables (Bottom of Full Edit Form):

 

7-18-1.        Selected Graphic Field in Tables:

End of OR Procedure Card Database

 


Beginning of Sterile Processing Card Database

 

1. Sterile Processing (SPD) Check Lists Full Edit [Password] w/Pictures:

:

 

2. Instrument Check List Full Edit

 

2-1. Instrument Check List Main Form (SPD):

 

2-2.            Excel Query:

 

2-3.            Instrument Table:

 

2-4.            Select Instrument to Insert Picture:

 

2-5. Select Check List w/Picture:

 

2-6  Select Check List Report w/Pictures:

 

2-7.            Graph Insert Form Only:

 

2-8.            Create Report w/Pictures:

 

2-8-1. Instrument Checklist Report w/Pictures:

 

  1. Billing Instrument Category Lookup(SPD):

 

3-1.            Instrument Category Lookup Form:

 

4. Select Instruments to Preview/Print Pictures:

 

4-1. Instrument Pictures: