Legal Watch

1. Legal Watch Made by Group 4 Jacob Brock Eric Li Andrew Schop

2. Origins of Legal Watch • Legal Watch was founded after our business expert (Andrew Schop) spent time working at a the law firm SchopPowell&Allen • The purpose of designing Legal Watch was to • Monitor the transactions between the Banks and Attorneys • Calculate the efficiency of those transactions

3. Why Design this Database? • The idea behind the database was to monitor and improve three aspects of the law firms business • The time an attorney spends with a specific document • Monitor the working pace and how long is the average turnaround per attorney on average • The time a bank spends with a specific document • Monitor the working pace and how long is the average turnaround per bank on average • The information showing all the relationship between attorneys, customers and banks

4. Legal Watch at a Glance • The design will show that the database is made up of five different forms and five different reports • Documents Specifications Form • Attorney Subform • Loan Officer Subform • Linked Bank Form • Linked Loan Officer Form

5. Legal Watch at a Glance (Cont.) • Attorney Efficiency Report • Bank Efficiency Report • Customer Information Report • Loan Officer Report • Transaction Status Report

6. How to Use Legal Watch • It’s Simple! • Simply follow the following steps • Open the database • Go to the Forms Menu (Open Document Spec. Form) • Enter all you needed information • Go back to Forms Menu (Open Linked Banks Form) • Enter all you needed information • Go to Report Menu (Report of your choice) • Print needed report

7. Conclusion • That is Legal Watch! • It will improve productivity (across many aspects of the business) • For HR hiring purposes • For business transactions and sales • For upper management to get a clear overview of their business

8. Questions?