Queries

[[image:Search.jpg width="122" height="88"]]
One of the main benefits of creating and electronic database is that we can quickly search through all of the records. A search is also known as a query.

A simple query searches through one field in a database table. e.g. surname = Smith

A complex query searches through more than one field in a database table e.g. surname = Smith AND age > 40

Now complete the following exercises on searching.

Search Criteria

Artists and Bands

Flight Bookings

Music Lessons

Game Console Stocks