 |
 |
| Solvers |
| Puzzles |
| Latest Apps |
| Str8ts |
| Other |
|
This is a page I have built to show a gallery of database applications that I am the author of. Most of these applications are available for demonstration in person on my laptop. Access is a brilliant program for designing database front-ends - not just as a data storage medium. Many of these apps use SQL server or Oracle and interface with other Office apps such as Excel. I am the sole author of these examples.
| Company Accounts Database This is a database I have used for about eight years to print invoices, purchase orders and create management reports for my consultancy company. It has a large range of reporting features. |
 Click on image to expand |
| Company Accounts Database Within the database is an address book and contacts management system. |
 Click on image to expand |
| QES Project Administration Database This is the main screen for QES - a division of Mott MacDonald dealing with project quality and management. There is a neat document tree in the bottom left hand corner. On the lower right is a tab control allowing access to all the child records. |
 Click on image to expand |
| QES Project Administration Database There are three layers of divisions and sub divisions within the company and this tree control manages them. This populates pull down menus used in data entry. |
 Click on image to expand |
| QES Project Administration Database Here is a screen shot of one of the tabs dealing with sites owned by a project. The pop up on the left is for selecting a staff member which ensures that a proper record is related in the database rather than a simple name being typed in. The back end is partially access and partially Oracle. There is also a web version of the system which I also wrote. |
 Click on image to expand |
| Abu Dhabi Water Resources Database Mott-Macdonald posted me to Abu Dhabi to design a Water Resources model using Access as the database and model system. This shot shows the model interface where individual demand sites are supplied from a variety of sources - graphed over a 20 year period. |
 Click on image to expand |
| Abu Dhabi Water Resources Database The screen displays the demands (yellow) and the supplies (green) and allows the user to join them with pipes (or links - blue). It is hierarchical and each record has its own popup for entering time-series data such as population of capacity. |
 Click on image to expand |
| Abu Dhabi Water Resources Database Here is one such popup for a link - it automatically tries to graph the supply and demand from the data in other records. |
 Click on image to expand |
| Customer and Sales Database This was designed to be the management tool for runningan e-commerce web site. Data would be pulled from the web server and displayed for further processing off-line in an office. New data is then pushed up to the web server. This database has two sides - products and customers. This shot shows the customer records and lists purchases. |
 Click on image to expand |
| Customer and Sales Database This is an example of the invoice report produced from the database. |
 Click on image to expand |
| Book List Database A simple - and early database - that allowed a book shop to manage stock. The owner simply uploads the database to a web server where the website displays the information. You can see this in action by visiting www.junepress.com |
 Click on image to expand |
| Risk Survey Database A Risk Management company based in London commissioned a web site and database from me to manage all the hundreds surveys they do each year. This is a shot of the main screen. There are tabs and buttons to many pop-ups allowing access to the child records and contact management system. There is also a web version (in ASP) to allow remote users access to the system. |
 Click on image to expand |
| Risk Survey Database Here is an example popup which allows a manager to enter invoice details and create a printable invoice. |
 Click on image to expand |
| Risk Survey Database These are the pop-up screens allowing address details to be seen and edited. The original specification called for a minimum of data duplication to much of the work involved designing easy to use look ups. |
 Click on image to expand |
| Risk Survey Database Many reports -including the surveys and invoices - need to be emailed to a client so there are screen to automate this and interface with email programs such as Exchange and Outlook. |
 Click on image to expand |
| Customer Services Issue Log This is a small database application used by a group of employees to track issues with suppliers and customers. They have a response time and ownership policy to allow performance checking and management reports on efficiency. This is all built into the system. |
 Click on image to expand |
| Customer Services Issue Log This shot shows the details of a particular issue. The form includes fields for assigning an issue to a person and logging the actions taken. |
 Click on image to expand |