Evaluating a relational database solution

Authors Avatar

GCSE Project

Md. Shahajada Chowdhury 5613

Evaluation

Evaluating a relational database solution-

Performance criteria and desired outcomes-

The database will contain all required details:

The first part of this Task will be carried out in Microsoft Access

At the beginning of this project, I set the database some objectives that I hade hope would be achieved. Some of this were done with great success whereas others not so well. Here is how the user of the database found the database to be.

It took a long time and a lot of work to get the publication looking as it does now. By looking at the implementing design section and looking at the number of printout I have produced in order to see the progression of the publication itself, it can be seen that I encounter a few problems along the way. For example the printer firstly ran out of toner, and secondly on my home computer the colour ink cartridge ran out. But these were not too much of a problem as they were only rough designs and were not final; it just meant that by the time I needed to print out my final publication that this problem had been solved.

In Microsoft Access it was easy to do queries because all of the fields I needed to search for information in were laid out into a neat table and I could easily tell where to type the information I was looking for.  I could sort information by different fields just by selecting ‘ascending’ or ‘descending’.  Not only could I do simple searches, but complex searches were just as easy, I only had to type in a little more information.  Sometimes it was quite confusing when I was searching for specific dates, because I had to work out what the short date was, whether it was ‘<’ or ‘>’ sign, and where the boundaries where for different years.  ‘And’, ‘or’ and ‘not’ searches were easy to do as I only had to type ‘and’, ‘or’ or ‘not’ in from or between the information I was searching for. I could view all of my data inputted clearly and in the form of a table with columns.

Join now!

It was quite easy to produce tables and reports as outputs in Access. When I selected what query I wanted to use I then decided which fields I wanted to display in my output designs. This was easy as all I had to do was 'tick' or 'untick' the 'show' row in the query 'design view'. These made my output results clearer and contain only the information that I was searching for. It was easy to see what the table looked like by simply clicking on the datasheet view in the top left of the screen.

Producing, forms ...

This is a preview of the whole essay