SME Topic: Automating Work flow through Database Development Thursday, November 30th, 2006
We all do repetitive tasks at work, creating documents, spreadsheets, e-mails and recording information about the products and services that are sold.
A Document would be created in Microsoft Word.
A Spreadsheet would be created in Microsoft Excel.
An E-mail would be created in Microsoft Outlook.
Customer Data Might is stored in Microsoft Access.
Now it’s not uncommon for small to medium sized businesses to have their own way of doing things that is typically thrown together with the skills available to them at the time.
Here are your tops tips your small business could be better organised.
You don’t have a database.
You don’t have a server.
Documents are not created in a consistent manner.
E-mails are not created in a consistent manner.
Not everyone uses the same standard forms or documents.
People spend all day going in and out of different applications that don’t talk to each
other.
You copy and paste a lot.
The list could go on…….
In this weeks articles I describe how I solve these Small business problems for clients.
Advice on Automating Work flow through Database Development
I have many jobs, too many to list here but one of them is proudly being a Microsoft Office Developer. I can review your work flow and design automation around existing business tasks.
In simple terms you host your customer data in a Microsoft Access Database and use the automation that Access allows to make creating documents, spreadsheets and e-mails based on the customer data so much quicker and in a consistent way.
Work flow automation is quite a rewarding part of being a Microsoft Office Developer when you know you have created a more streamlined way of working. Over the years I have created many varied database/work flow solutions for clients all of which are still being used today.
I have been a database developer for nearly 15 years. So my developing experience predates even Microsoft Windows back in the old DOS days.
I have a unique way of delivering training for the work flow solutions I create. I issue a full on-screen video tutorial about how to use the database the people will use.
This is a great tool for new people who join later, they can sit and watch the guy who developed it tell them how to use it properly.
If you’re a North West based business looking help and advice about work flow and databases issues then get in touch I can help you. Tel: 01606-841587.
Link: http://www.481.co.uk





Office2007 User Interface


