Contact DataMouse

Send me an email and I'll try and get back to you within 24-hours.

Client Login

Enter username and password to view your work

Username:

Password:

 

Archive for the ‘Database Design’ Category

Microsoft Access Shortcuts

Jun 1st

Microsoft Access is a database management system that allows you to create and process data in a database, which has rapidly become the database of choice for Windows based database development. If you are self taught and have not had any Microsoft Access training you are probably unaware of the many shortcuts available within Access. This article aims to provide some useful tips and shortcuts to help you when using Access.

Access Database Basic Tips and Tricks

Apr 7th

We have seen some truly horrific database designs! This section contains a few suggestions and hints to try and prevent some of these and to make your database development work that much easier. Be warned however, Access is deceptively easy to get into. To use an analogy; Access is rather like a gently sloping sandy [...]

Best Practice Designing

Apr 6th

Software, database and web development all have documented best practices and industry standards and conventions, but these are often easy to neglect in favour of a quick solution. But what exactly do we mean by ‘Best Practice Design’? The following article explains these techniques and what they mean to you, the customer.
The Importance of Best [...]

Database Fundamentals

Apr 5th

Database Fundamentals must be prepared to all the computer professionals and users. If you lack in their actual meaning of terms, you would always find an uneasiness and discomfort when these jargons come to you. This article is targeted to a novice and expert both, so that novice can prepare and an expert can revise [...]

Choosing a Developer

Apr 3rd

So you’ve decided to go ahead a commission a bespoke IT solution, but who do you get to develop it, and what should you be asking for? No points for guessing that we’d like you to considerDataMouse. However, this article looks at what you should be asking for and how to communicate your needs to [...]

How to Write a Specifications Document

Apr 2nd

This document is intended to help you to write the Terms of Reference under which you want a simple database development to be undertaken. It only covers general development terms. When putting work out to tender you will also require a Functional Specification. The sample clauses on this page, which are shown in italics, [...]

Start Using Microsoft Access

Apr 2nd

Thinking of developing your Access skills? New to Microsoft Access and don’t know where to start? Want to know more about what Access can do for your business?
Microsoft Access is a popular application designers often use to store and retrieve information. It is a database management software application (DBMS) used by small businesses, large corporations [...]

Database Optimisation

Apr 1st

There is a common “patchwork” philosophy in IT departments throughout the world that gives the idea that altering, changing, and fixing poorly designed databases is how you correct the problems – as opposed to starting from the ground-up and re-working a system.
While Relational Database Design gets thrown out the window, a terrible side effect of [...]

Testing Software

Oct 28th

Testing Software
Any bespoke system needs to be tested thoroughly before you sign the project off and begin to use it in a ‘live’ environment. This article looks at what testing involves, whose responsibility it is, and how to implement your own testing programme.
Isn’t up to the developer to test the software?
The obvious answer would be [...]

5 Simple Rules for Preventing Corruption in Microsoft Access

Sep 19th

Having spent many hours fixing Access databases during the past 10 years of my life, I’ve put together this short list of 5 Simple Tips to Prevent MS Access Database Corruption. While the potential causes are numerous, I’ve found that the majority of actual cases can be prevented by following these 5 simple tips.
It’s important [...]