Databases, Spreadsheets and Templates
A guide to the business system development, and IT consultancy and training services offered by DMW Consultancy Ltd.
Last updated on 2018-08-01.
Databases, Spreadsheets and Templates
When you want to make the most of the information available to your business, DMW will work closely with you to increase productivity, to identify and exploit opportunities, and to improve earnings.
DMW designs, develops and implements databases, spreadsheets and templates as business solutions for clients determinied to maximise on their investment in IT.
For sole traders, SMEs and corporations, DMW has worked on databases and spreadsheet covering a wide range of business sectors, including automotive, aviation, commerce, construction, creative, distribution, education, finance, insurance, ITC, manufacturing, media, marketing, public services, publishing, training, transport, travel and retail.
From working on hundreds of diverse projects and decades of applying Access, Excel and Word since they first appeared in the UK, DMW has gained insights into many businesses — how they operate and how they use their software. Experience gained this way, means DMW offers you not only technical competence but also fresh ideas.
Support for Users — Software Training
If your preference is for company-specific training instead of scheduled public courses, then DMW supplies on-site tailored training courses and workshops in Microsoft Access, Excel, and Word.
To provide the training that suits your specific needs, you agree with DMW an appropriate pick-and-mix of topics from our introductory, intermediate and advanced level course content.
DMW matches practical aspects of any course to the activities for which you will use the software in your day-to-day work. Your needs for training of users, developers and programmers are catered for: Access Introduction, Intermediate and Advanced; Excel Introduction, Intermediate and Advanced; Word Introduction, Intermediate and Advanced; and VBA (Visual Basic for Applcations) across the Microsoft Office/Office 365 suite.
Preparing Specifications for ITTs
For the commission of a new database, say, you’ll get the best price when your ITT (Invitation to Tender) is accompanied by a comprehensive specification.
If your spec is sketchy then potential suppliers or contractors will be reckoning whether 20% or 30% added into their quote is enough to cover themselves against all eventualities.
A well-constructed spec should help in avoiding unfortunate situations, for example:
- Significant unprovided-for time spent to-ing and fro-ing on points of clarification. In DMW’s experience this can put great strain on the working relationship between client and supplier
- Your supplier or contractor invoices for what they claim was work not originally specified
- Failure in your effort to claim that the outsourced work has not been completed satisfactorily.
Please contact DMW if you need help preparing a tender. DMW can help by translating your description of your requirement into the language/jargon of the developer.
Conversion of Access Databases
Microsoft’s support for versions of Access earlier than 2010 is running out, if it didn't do so years ago.
This means no more security patches and therefore the possibility that without appropriate conversions databases will come to jeopardise a business’s accreditation or certification.
Microsoft recommend conversions to the latest version of Office.
If you need assistance with conversions, please put DMW on your list of potential suppliers.
Occasional Help On Demand
If you need a spot of help only, DMW offers support to users of Microsoft Access, Excel and Word, on an as-and-when-needed basis.
Additionally, DMW provides IT consultancy when you could do with assistance from an independent source. For instance, if you are putting an IT project out to tender and you require assistance with the preparation of technical specifications.
Working With Your IT People
Much of DMW’s work for large clients is on behalf of a department, or a local office, in making available to its users subsets of the information stored in centralised business systems. Users want to do their own thing (what-ifs, special reports and so on) with those data without fear of harming them.
Working closely with your IT people, DMW will secure the delivery of data and safeguard primary sources, while making as little extra work as possible for everyone involved.