Contact DataMouse


Database Design

More than just a briefcase full of data...

Store, access and question your information

A database is, in its simplest form, a system for holding information.

This could be paper-based, such as a telephone directory, held on a server or stored in a computer programme such as Microsoft Excel or Microsoft Access.

A database is an organized collection of data for one or more purposes, usually in digital form.

With databases that are stored electronically, there are two main versions:

  • Server-side – Databases that reside on a server

For example, a website – such as Facebook – will have a database stored on a server. The user will access this database through a web site, which connects to the database and returns the information (data) that is required.

  • Client-side – Databases that reside on your computer

For example, you may keep a record of your finances for the month on an Excel document on your PC. You would only access this from your computer, and would also require the application (Excel) to open the document. If you were to send the document to a user that did not have Excel, they would not be able to read the data.

Both methods have their pros and their cons.

Client-side databases:

  • usually require the user to have the software to read the database installed on their computer
  • tend to be far less secure, as all security measures have to be set on your computer
  • can only be accessed by users that have a connection to your computer

However, they also:

  • tend to be quicker to develop
  • are less expensive (due to development time)


With server-side databases, there are also some downsides. They:

  • take longer to develop
  • cost more to develop
  • require additional work to design the security aspects

However, they also:

  • can be accessed by anyone with a connection. In the case of a web-server database, this means that anyone with a web connection can use the database
  • are far more secure, as all security is handled by the server


I specialise in client-side databases, built with Microsoft Access.

Additionally, I also create server-side databases for websites, most notably with WordPress and osCommerce installations for online stores.

HTML By Hand


Design-only project, which needed to be a simple layout to test the client’s offered service.




A modern law firm layout for a client that required a site to hold a large aount of content.


Vacation Rentals, Kemah


A holiday home rental property web site, with fully customisable layout including jQuery effects.


Want to see what I can do for your web site? Take a look...
Show me