The owner of Downloadable Tunes has created an electronic database to record customer details. The database will be used to efficiently store and maintain customer details and to target advertising to specific customer groups.
An electronic version of the database is available here (opens in Microsoft Access) – save this to an appropriate place in your folder. You will need to use it to complete this task.
Produce screenshots to show you have completed each task in a blank word document.
Enter the following customer details into the database:
“A Smith” has been asked to be removed from the database – delete this record.
“T Park” had remarried and is now “T Forrest”. Amend this record to reflect this change.
|Create a query to show all customers that live in “Leeds”.
|Click here to see a video on how to create a query in Access.|