I offer a solution to a problem which might, sort of, sneak up on you when you’re developing your database. Imagine this scenario. Your organisation helps disadvantaged families and received support from government and other organisations. One of the requirements of this support is an annual report on how many people have been helped by your organisation. You’ve been using Excel for this however it’s becoming apparent that Excel doesn’t have all the features you require. You turn to MS Access to emulate a form provided by the government, and it has lots of checklists on it. The main form has a section for collects information on the families, family name, address, etc… under this section you have set up a subform which offers the user a set of combo boxes where they can choose a question and provide an answer. In other words the user interface is awful! A user interface requiring the operator to take several steps on each and every entry, unnecessary steps, something crying out for automation! Instead of the operator manually choosing the question and providing the answer, you would like all the combo boxes to be filled automatically! Hence my Checklist solution… See how to automatically create a Checklist on my website HERE:-

How to add a Checklist to MS Access

This Advanced but simple to use Checklist is easy to set-up. You Just need 3 Tables, a main form and a Subform. Follow the comprehensive Video Instructions, which demonstrate how to add this incredible utility to your database. Establish yourself as the “Go To” person in your organisation for database improvements! “Nifty Access” will quickly elevate you to “Power User Level!”