Evaluation of a database set up in microsoft access.

Authors Avatar

Project 1b Evaluation        Charlotte Body        11J

30/04/2007                Mr. Webster

Evaluation

        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.

Producing graphs, forms and reports were easy because Microsoft Access has ‘wizards’ which take you stop my stop through the processes.  It helped me with such things like – how to design my output, what layout, what information I wanted to be displayed, what title I wanted to use and in what format I wanted my output to be in (Tables, records, graphs). Buttons and Macros were also easy to design as they also had ‘wizards’ to help you, and they also let you decide when designing the buttons which macros, forms or queries you want to use, and I could decide where I wanted the button to take me to e.g. next record, a welcome page. It was easy to see how outputs would look like with the ‘design view’ in Access.  It was easy to change what the output looked like because I could change the appearance of the information e.g. font size, colour. It was easy to create the different fields because I could chose what information I wanted to insert in them.  I could easily chose what I wanted other people to type into the fields as well, by setting up simple validation rules e.g. Maximum number of characters 15.’

Join now!

It was quite easy to produce tables, reports and graphs 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’. This 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.

...

This is a preview of the whole essay