Task 7 - Use a Database

You need to make some amendments to a database and create some queries and reports.

Pass

Open the database and carry out some amendments:
Example 1
Example 2

A1 - Add a record

• A new order has been received; enter the following customer details into the database

Customer number	Title	Forename	Surname	Address1	Address2	Town	Postcode	Age
	Mr	Stuart	Magoo	31	Haystings Close	York	Y04 2TT	21

A2 - Delete a record

• Andrew Smith has asked to be removed from the database. Delete this record.

A3 - Amend a record

• Teresa Park has recently married and is now Mrs Forrest. Amend this record to reflect this change.

A4 - Create a query that uses a single search criterion.

• Create one query showing all of the customers that live in Leeds.

Merit

B1 - Create a query

your query must:
- use a single search criterion
- be sorted on at least one field

For Example:
• Create one query showing all of the customers that live in Leeds.
• Sort the query alphabetically by surname.

B2 - Create a report to print out selected data for a specific need.

For Example:
• Create a report to show the address of all customers that live in Leeds.
• You can use the query from B1 to make the report.

Distinction

C1 - Create a query

Your query must:
- use two search criterion
- be sorted on at least one field.

For example:
• Create a new query showing all the customers that live in Durham, aged between 16 & 25.
• Sort this query on the age field.

C2 - Create a report & print as address labels.

Address label hints.