Wednesday, 13 March 2013

Unit 2: Working With Databases

In this task I will be showing example of working with a database. The program I am going to be using to complete this task is Microsoft Access.


Here is a screenshot of the original database I am going to be using. The are 492 different attractions on the datasheet. Throughout the task I will narrow this number down. This narrowing down process is used to make it easier to locate and find what you are looking for within the database. This is helpful as there are so many different things in a database that it would be extremely time consuming if you couldn't filter it down.


This screenshot is the original database but it has been narrowed down to only show the attractions with an entry fee of less than £8.50. There are now 368 different attractions showing and this is 124 less than in the original database.


 
Here is a screenshot of all of the attractions the the in the East Anglia region. There are 61 different attractions which are shown in the list above. So this screenshot shows I have shortened the list of attractions by finding the ones specifically in this region.
 
 
In this screenshot I have narrowed the database down by using two search preferences. The first preference is the price. I have searched all of the attractions that cost more than £5. This function can be used to identify the attractions in someones specific price range. The second search preference I have used in the region South East. This can be used to find out the what the attractions are near where someone lives. This function makes it extremely easy to do this. By using more than one search preference you can massively shorten the amount of results so it is easier to find what you are looking for.


No comments:

Post a Comment