Hardware Retailer Sales Report Builder


National Hardware Retailer


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.


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.


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.


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.


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.