ATTORNEY TRUST ACCOUNT

QUESTIONS AND COMMENTS ARE WELCOME USING ACCESS 2002 ATTACHED ARE ACCESS 2002 TABLES. 1) ESTABLISH RELATIONSHIPS BETWEEN THE TABLES SO THAT: A) CLIENTS AND ATTORNEYS NAMES ARE DISPLAYED WHEN THEIR NUMBERS ARE ENTERED OR ACCESSED B) DISPLAY ATTORNEYS AND CLIENTS NAMES AND NUMBERS SO THAT PERSON ENTERING DATA WILL SELECT FROM THE LIST OR ADD A NEW CLIENT OR ATTORNEY 2) DISPLAY AND/OR PRINT REPORTS FOR ALL OR SELECTED PERIODS(START, END): A) SORT BY CLIENT NUMBER, SUB TOTALS EACH CLIENT . B) SORT BY ATTORNEY NUMBER, SUB TOTALS EACH ATTORNEY. C) SORT BY TRANSACTION DATE, SUBTOTAL EACH DATE , D) TOTAL RECEIVED, TOTAL PAID, NET TOTAL EACH MONTH END E) SORT BY CHECK NUMBERSORT BY ATTORNEY NUMBER 3) PROVIDE A METHOD OF HEADING REPORTS WITH THE THE ATTORNEYS NAME (SUGGEST USE ATTORNEY # 001 FOR HEADE 4) PROVIDE FORMS FOR EASY DATA ENTRY. 5) TELEPHONE NUMBER ENTRY WILL BE DIGITS ONLY. case nummber is unique. It is associated with one client and one attorney. On data entry, if the case number is entered, display the client and attorney names. if the client number is entered dispaly the possible case numbers and attorneys. If the attorney number s entered display the possible cases and clients. If a partial client name is entered, display the possible names. same for attorneys. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform WIN 95 AND LATER. ACESS 2002 NOT NETWORKED