Inventory and Usage Database

Requirement

The main function of these databases was to automate files exported from SAP into Access, manipulating the data in Access and in turn exporting the data back into Microsoft Excel.

Industry: Major Airline

Company Size:
Thousands

Functionality

• Import functionality was created by way of a form driven system whereby the user was able to browse the computer and selected the required text file that had previously been exported from SAP.     This file was then imported into Access.
   
• Once imported, the file went through a "clean up" process, removing all unnecessary information from the text file. This included information such as leading spaces and non-alphanumeric characters.
   
• The information was then analysed through queries and SQL code resulting in inventory and usage information being obtained.
   
• The data was then exported to Microsoft Excel.
   

Outcome

The requirement was to automate a process which took at least a week of man hours each month. The process was totally automated to take less than 1 hour, with man hours of less than 10 minutes.