About DMW
Having closed DMW Consultancy Ltd in June 2024, I'm keeping this website going to pass on some of what I've learnt in 36 years working as an independent IT consultant.
Through TIPS presented on this website and through mentoring, I want to help individuals and businesses bring skills on board so that they can look after their databases, spreadsheets and documents for themselves.
Last updated on 2024-10-10.
Databases and Spreadsheets
My experience in applying Microsoft® Access and Excel to best meet specific business objectives has come from working with hundreds of clients across a wide range of fields:
- Accountancy
- Advertising and PR
- Aviation
- Art and design
- Asset management
- Banking
- Buildings management
- Construction and civil engineering
- Customer Relationship Management (CRM)
- Education
- Electronics
- Events booking
- Film industry
- Fitness industry
- Forestry and landscaping
- Fund management
- Health and safety
- Hospitality and amenities
- Insurance
- IT and ICT
- Interior design
- Law
- Leasing
- Marketing and public relations
- Manufacturing
- Medical products
- Motor dealerships and motor manufacturers
- Oil industry
- Packaging
- Property development
- Recruitment
- School governance
- Software training
- Sub contracting
- Transport.
Databases and spreadsheets remain the most common and popular tools for storing and processing business information on a computer. Yet skills in these area remain, I believe, far below what is good for business.
Database Creations
Fully–fledged databases I developed and implemented included these:
- Complaints
- Contracts
- Enquiry management
- Financial market intelligence
- Human resources
- Insurance premiums claims
- Leads and tenders
- Manufacturing
- Marketing
- Packaging
- Product returns tracking
- Sales orders
- Supply chain management
- Time tracking.
All these were in mixes of Microsoft Access and SQL Server, and intended for multiple concurrent users.
Document Production
The DOS version of Word was my first-choice word processor on early PCs. But it wasn't until the Windows versions that I started getting requests to provide training courses.
From interest expressed on those courses and from visits to my website, I picked up commissions for work on everything from letters to refined reports.
I have assisted scores of businesses, from SMEs to multinationals, to improve productivity through what I regard as the proper use of Word.
Though it is such a widely used piece of software, Word's features that lead to the greatest efficiency in document production remain, it appears to me, to be mostly under exploited.