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.’