Case Tracking System – A Real Estate Legal Firm
Industry: Legal & Litigation
Solution: Case Tracking System
Technologies: Microsoft Access
Solution Type: Technical Support; Database Migration
The real estate law firm specializes in real estate foreclosure cases. The company manages the legal process of auctioning foreclosed properties.
The firm needed to upgrade their aging PCs but was using an old Microsoft Access 1997 database to manage their foreclosure cases. This old database prevented them from replacing their aging PCs with new PCs containing Windows Vista and Microsoft Access 2007. It was critical that their Microsoft Access 1997 database be converted to Access 2007 so that new PCs could be purchased. After the database was converted to Access 2007, more of the company’s staff began to use the database.
As activity increased, the need for being able to manage customer billing became a priority. It was important that the company manage their cases along with the billing.
The Microsoft Access 1997 database was converted to the latest version of Microsoft Access. The database was enhanced to manage billing functions. The company now operates the database on all PCs in the organization. The company also manages their cases and billing in one system where they previously needed two systems.
Converting to the latest version of Microsoft Access
The database was converted to the Microsoft Access 2007 platform.Having the system in the most recent version of Access granted user permissions to all company staff. This also allowed the company to replace their aging PCs with new ones. Their staff could now operate the database using Access 2007 on the latest Windows
The ability to generate invoices and track payments was added to the database. Company staff could now manage their cases and billing details in one system.