Please CLICK HERE to read testimonials.

Excel

Excel is a component of Microsoft's Office suite of applications. It is primarily a 'what if' tool.

In it's simplest form it can be used as a glorified calculator. However, at its best it allows the user to perform many complex and dependent calculations at once. If an Excel spreadsheet has been well written, it is possible for the user to have no understanding of Excel, formulas etc. A good application may also have a user interface which makes it easier to use.

Excel can also be used as a simple database called a data list. These data lists can be filtered to show particular data and can be used in mail merge using MS Word to create bulk letters or envelopes/labels.

Top Ideas assists small businesses in South Australia to develop their own Excel solutions or create one for them.

Analysing, troubleshooting and converting Excel spreadsheets into applications with a user interface is a specialty.

Access

Acess is a relational database. This means that the repetitious typing of the same data (e.g. an address) is avoided.

A database can be simple or complex and can be used by a single user or by many across a network.

Top Ideas has years of experience in developing database applications for South Australian small businesses. If starting from scratch, a 'business analysis' is performed to see what the database is needed for and what processes are currently in place.

To reduce the user's knoweldge of Access and databases, a menu driven user interface can be developed.

Databases can also be used on websites - however, generally Access is not used on the web. Top Ideas converts Access databases to MySQL and uses PHP to design a webpage interface.


Pat Flood
Clare & Gilbert Valleys Council
admin@cgvc.sa.gov.au

Thank you, Roger, for your invaluable support in relation to our works request/ complaints database. Your troubleshooting skills and patient training techniques have been well recieved in our organisation. We look forward to a continued relationship in the future.


Ian Miller
Port Pirie Regional Development Board
board@pprdb.com.au

The Port Pirie Regional Development Board engaged Roger to update an existing Access database. This database was the main source of client contact and activity data for the PPRDB and provides a series of essential reports as well as critical mailout facilities.

The key features of Roger's input were -
      * Reviewing and understanding the existing database structure.
      * Assisting to scope the upgrade and added functionality.
      * Eliminating the data redundancy that had developed.
      * Interpreting our ideas and concepts that we had been unable to scope precisely.
      * Adapting the existing structure to incorporate the desired enhancements.

Roger quickly understood the quite complex structure of the existing database and was able to make the necessary modifications promptly, including efficient testing and debugging such that the enhancements were all available with the minimum of fuss.

This was achieved over a very short time frame and facilitated by the ease in which we could discuss issues and solution options with Roger and prototype some of the development. Roger creatively explored and employed advanced Access functions in order to provide us with the optimum solution.

We would use Top Ideas & Solutions for any further modifications to the database and most probably for future Access applications.


Trevor White
Hon. Secretary (Former)
Woodvile Historical Society
Brocase Musem
enquiries@thebrocasmuseum.com.au
www.thebrocasmuseum.com.au

On behalf of the Committee of Management and Membership of the Historical Society of Woodville, I convey our sincere thanks to Roger for establishing our up-to-date computer system for The Brocas Museum.

Your ability to analyse our circumstances and your skill in bringing together our three disparate data records into a functional data-base was very impressive.

Similarly your ability to interpret our operational needs and your skill in creating a system for accessing records by asset, donor, class, value, author etc.was appreciated and commented on by members.

Also your inclusion of the integrated reports for stocktake by asset,category, location, value etc. along with the form letter functions, has given us a Total Museum, client tailored and user friendly system that has the capacity to expand with our future increase in demand.

Your skill in training members and your provision of operating instructions and standard practices has enabled members to more quickly acquire confidence and will ensure a sustainable system.

I should also comment on your professional know-how in creating and hosting our new website with its embedded links that now provides us standing in the world wide web of information.

In conclusion you managed all of the fore-going without breaking our Bank.

Congratulations and thanks from all of us on achieving this most welcome and worthwhile outcome.