The last week (Friday), my short-term contract was concluded.
I completely redesigned SQL Server Database of the Client’s Inventory Replenishment (Vendor Managed Inventory - 3rd Party Logistics) Management and Reporting Tools with building normalized database design preventing suppliers’ duplicating, providing efficient suppliers selection tools by various criteria, developed SQL Stored Procedures, SSIS packages for importing data from various sources, compactly and eye-friendly redesigned User Interface with presenting most important data on one screen, automated repetitive users’ tasks with Access Macros and VBA.
The simplified Database redesign is presented below.
In the old database Suppliers were duplicated.
I am working with Microsoft Access 2013 and came to conclusion that Grey Background "MS-DOS style" (Colors "Text 2, Lighter 60%" or "Text 2, Lighter 80%") is much more eye-friendly (for example, for sales persons spending 8 hours daily) than a white or bright background. About Font Color: it's #17365D (dark-blue).
Would you agree with my choice or you know better (for users' eyes) combination?
I continue working on a contract position related to redesign of SQL Server and Access based Supply Replenishment Reporting Tools.