Querying A Database

In this activity, we are required to make queries which is basically searching for information in the databases that we have made in the previous activity.

We had to open up Microsoft Office Access
and under the 'Objects' column, click on 'queries' and click on 'Create Query in Design View'.

Q) 7&8

By dragging the Surname, First name and Postcode on the 'Field' rows, the program will know which field that we want to search in.

As shown in the picture, the numbers 2145 is typed into the Criteria row and This means that we are querying/searching for people in the address book that lives in the postcode 2145.

Q) 9-11

By clicking on 'save' and then 'open', you can see that the people listed are those in the database with the postcode of 2145.


Q) 12

This time, the number 2766 was typed in the 'or' row.

These are the results for the query.
The information that the second query selected are those with the postcode 2766.
Therefore, my results display the people who live 2154 OR 2766.
(I use microsoft office 2007 at home)


Q13)

In the 'criteria' row, I typed in *2 which searches for phone numbers ending with 2.


I also typed in *3* which searches for phone numbers with a 3 in it.

The query *2 didn't come up with any results,
so I just included the results of the *3* query.

Q) 14
A- Postcode of 2145 or 2146


Results:



B- Postcode between 2145 and 2146

Results:



C- Surnames starting with S


Results:



D- Surnames or first names containing M


Results:



E- Surnames and first names containing A


Results: