Atlanta Access Consultants  
Case Study : The Home Depot

Home Depot Guides Software

Synopsis

The Home Depot engaged New Frontiers International, Ltd. to upgrade and expand an Access application used by Store Planning to send data back and forth to AutoCad. The data includes Best Practices data and other data. It must be passed back and forth rapidly, accurately and shared among a large number of users.

Opportunity

The Home Depot had been using this application for three years, but it was in great need of an upgrade and user-proofing. Performance was sluggish, and the user community was dropping data or adding it incorrectly into the database.

Solution

NFI's solution was to split the application into two pieces (front-end and back-end), normalize the application, and make the user interface significantly more friendly and faster. More constraints were put on data integrity, and queries, forms and tables have been optimized for performance. Functionality has been increased. At the same time, the back-end database has been shrunk from a ponderous 260 mb to a streamlined 70 mb file. NFI also implemented security and disaster-recovery methodology. Finally, NFI helped The Home Depot by documenting large parts of the system that had previously been completely undocumented.

Functionality

Providing the necessary functionality and robust scalability involved the use of database technologies by New Frontiers International. The architecture was based on Access pulled and pushed to Autocad and other large databases such as Oracle and various mainframe systems.

User Experience

Users are experiencing less stress, shorter production times, and a great deal more flexibility in assembling data for reporting. Store Planning has already seen a decrease of several hours in the time to prepare a store for production, saving possibly millions of dollars for The Home Depot.

Return on Investment

NFI completed the project on budget, but also completed many additional tasks within that budget. Slighly different versions of the application were used for Home Depot Mexico and Home Depot Canada.


"You have done a great job."

Dee Richardson
Store Planning
The Home Depot

Data Management

Business Intelligence
Financial Reporting
Data Auditing
Data Security
Data Migration
Process Automation

Some of Our Clients

Turner Broadcasting System
Home Depot
Great Gatsbys
UPS
Price Waterhouse Coopers/CBRE
Deloitte-Touche
Atlantic Southeast Airlines (ASA)
MCI
Alltel
Coca-Cola
Cox Communications
Hewlett-Packard
Manhattan Associates