Category Archives: Database Design

The Importance of a Booking Confirmation and Careful Communication

With booking systems there are a lot of important things that will make a system successful – good operational speed – a well designed table structure – great UI and good stability but without really really great communication and confirmation … Continue reading

Posted in All, Database Design, General Opinion, User Interface Design | Comments Off on The Importance of a Booking Confirmation and Careful Communication

MS Access SQL for randomising the results from a query

I was wanting to randomize the source of a form so that I could test myself on some Russian within a table. Turns out its very simple. Basing a Query on the following SQL will achieve it. SELECT TableName.PKID, TableName.Field1, … Continue reading

Posted in All, Database Design, MS Access, Programming, SQL MS Access | Comments Off on MS Access SQL for randomising the results from a query

Wanting to demonstrate a database and need to scramble the data?

Here’s a nice function I found that will completely randomize information within fields of a database. Data will not be recoverable from this process which of course is its strength. Good if you are wanting to demonstrate a database to … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Wanting to demonstrate a database and need to scramble the data?

Attaching Databases to SQL Server 08R2 Express

It should be noted that the following although the easiest way to get a new database into an instance it should not be used in a production environment. In fact doing so may get you sacked. If experimenting though this … Continue reading

Posted in All, Configuration, Database Design, SQL 08 R2, SQL Server, SSMS | Comments Off on Attaching Databases to SQL Server 08R2 Express

SQL Saturday is coming to Edinburgh

Pretty lucky really some of the worlds most talented DBAs hosting an event about 1km up from my flat. More details can be obtained here. http://www.sqlsaturday.com/281/eventhome.aspx There is a waiting list but might be something for you to think about … Continue reading

Posted in All, Database Design, SQL 08 R2, SQL Server, SSMS, The future of software | Comments Off on SQL Saturday is coming to Edinburgh

Using VBA to open URL in chrome

Haven’t tried this out but could be useful. I have a digital mapping web application that I link to from a database and it has issues with IE but works perfectly in Chrome… shell(“C:\Program Files (x86)\Google\Chrome\Application\chrome.exe -url http:google.ca”) Update : … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Using VBA to open URL in chrome

Scope of variables – And Getting Confused

Note to self If you are wanting to pass parameter values between forms ensure that you place public variables in a module outside of the form. IMPORTANT – additionally ensure that the same variable names are NOT also listed in … Continue reading

Posted in All, Configuration, Database Design, VBA Code MS Access | Comments Off on Scope of variables – And Getting Confused

Code for altering tables on the fly

Most of the time when you are wanting to enter information automatically in fields as a result of a user interaction it is easiest to use some kind of event trigger from the form. Regularly you want to close down … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Code for altering tables on the fly

Building Timing Software for Athletic Races

A while back I got the opportunity to work with a friend who times athletic races. After a bit of questioning he showed me some of his equipment and how it worked. I realised I could probably put together some … Continue reading

Posted in All, Database Design, Problem Solving | Comments Off on Building Timing Software for Athletic Races

An example application for use learning Русский

I quite often put together various databases / applications to help me with my side projects. This is a good example. In an effort to help me remember my Russian verbs I put together a small database to assist in … Continue reading

Posted in All, Database Design, MS Access, Русский | Tagged | Comments Off on An example application for use learning Русский

BANISH DOUBLE CLICKING – My UI Design Patterns

I eluded to it in my last post but when I have tabulated forms I like to have the labels activated and set to sort alphabetically ascending on left click and descending on a right click. I use the mouse … Continue reading

Posted in All, Configuration, Database Design, MS Access, My UI Design Patterns, User Interface Design, VBA Code MS Access | Comments Off on BANISH DOUBLE CLICKING – My UI Design Patterns

Towards the best Table Design for Addresses

Floor Reference or Flat No Building Name or House Name House/Building/Unit Number Street Name Through Street Locality Town or City Country Postcode A designer knows he has achieved perfection not when there is nothing left to add, but when there … Continue reading

Posted in All, Database Design | Comments Off on Towards the best Table Design for Addresses