Sunday, 11 December 2011

Database queries

Databases are a collection of information. For the database to be useful the user must be able to extract particular bits information. To search information manually would be a difficult as you would have look at all the information in order to find what you intended to find  e.g you what to find out how many males rated over 7 out of ten [ 1- bad and 10-being good] for ice cream van prices it would take you forever to find all of them. To prevent this problem database queries are used . Queries is an effortless way of seeking required data , all the user has to do is enter what data is required in the table after pressing search all the data that you asked would have come up.

To make this simply press design quires [on Microsoft access] , to save the information gathered  press save as object then name it.
So quires are the solution to manually searching for information.

Below is an image of when entering data to a quire  the table near the bottom of the screen is where you enter
the question for the results to come up.