Hardware Retailer Sales Report Builder


Client
National Hardware Retailer

Problem
The sales manager for a national hardware retailer needed a variety of sales reports.
The only source of data available were extracts generated by an IBM AS/400 from the IT department.

Solution
The solution was a simple MS Access database which could easily import the text files and generate the required reports.
The import feature allowed extracts to be re-imported (as end-of-month sales figures were often revised).
The sales manager has a variety of reports available which could be customised with simple parameters.
The reports could be printed or saved as PDF documents to email.

Technology
MS Access, VBA
* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.
PROFESSIONAL PROJECT PORTFOLIO
Get this FREE Portfolio of VBA Projects
Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.
Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.
Click the Download button to get instant access to this project summary as a PDF you can print or share.

BENEFIT FROM EXPERIENCE
Save time, money & stress
Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.
Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.
