Searching+(Queries)+-+Access

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

Task
Now complete the following exercises on searching.

Search Criteria

Artists and Bands

Flight Bookings

Music Lessons

Game Console Stocks