Task 7 - Use a Database
You need to make some amendments to a database and create some queries aned reports.
Pass
Open the database and carry out some amendments:
A1 - Add a record
• A new customer has contact the estate agents hoping to sell their house.
The Estate Agents has asked you to add their details to the Database.
| Customer Name | Area | Address | Postcode | Price | Number of Bedrooms |
Style | Garden | Garage | Heating | Bathroom Details |
|---|
| Mr Magoo | Hindley Green | 49 Lulworth Drive | WN8 9OP | £72,000 |
4 | Detached | Y | Y | G | BT |
A2 - Delete a record
• The property in Scholes, Hesley Grange has been sold.
• Remove this property from the Database.
A3 - Amend a record
The estate agent has had trouble selling the property in South View rise, Loxley.
They have therefore decided to reduce the price.
Change the price from £64,995 to £60,500.
A4 - Create a query that uses a single search criterion.
For example:
• Create one query showing all of the customers that live in Walton.
Merit
B1 - Create a query
your query must:
- use a single search criterion
- be sorted on at least one field
B2 - Create a report to print out selected data for a specific need.
For example:
• Create a report using the query that shows all the customers who live in Walton.
Distinction
C1 - Create a query
Your query must:
- use two search criterion
- be sorted on at least one field.
For Example:
Houses in Holmewood
• Create a new query showing all the detached houses in Holmewood, priced between £60,000 & £70,000.
• Sort this query on the price field
C2 - Create a report & print as address labels.
Address label hints.