Unit 1f
Unit 1f - Using a database
Now that we are using more ICT, we decided to sort out some computerised customer lists. Liz has used a database to record the names and addresses of some people who have registered on the website. However, not all of the information is up to date. I want to start using the information in the database to help me run the business better. We were hoping that you could help. |
Task 1 Instructions
Adding data to a database
Download the database containing customer details.
Mr Khan is a new customer. Add him to the database.
Task 1 Files
customers.mdb
Task 1 Help
Watch this short video to find out some simple database techniques.
Task 2 Instructions
Mangaging data in a database
Mr A Smith has written to us to say he is moving abroad. There is no point keeping his information in the database. Remove A Smith from the database
Miss K Harris has returned from her honeymoon. She called in today to say that she is now Mrs Forrest. Update her details in the database.
Task 3 Instructions
Create a simple query
Dave is thinking about having a promotional party evening to raise awareness of i-downloads.
He wants to start it off small, so only wants to invite local customers.
Create a query in the database to list only the customers who live in Tarnstan.
Name the query Local Customer query
Screenshot the query in design view
Task 3 Files
screenshots.doc
Task 4 Instructions
Create a simple report
The list of local customers will need to be printed later. Create a report based on the local customers query
Name the report
Local Customer List
Task 5 Instructions
Complex queries
Dave has been thinking about the party and thinks it will be more exciting if there are more people involved. He also wants to have alcohol at the party so he doesn't want to invite people under 18. He has finally decided to hold the party for the 18-35 year olds from Tarnstan and Chapham.
Create a new query, this time list everyone who is
From Tarnstan OR Chapham
betwen the ages 18-35
in alphabetical order by surname ascending.
Name the query Party List
Screenshot the query in design view
Task 5 Files
Task 5 Help
See if you can adapt these instructions of how to do an OR query from the teach-ict website.
See if you can adapt these instructions of how to do a between query from the teach-ict website.
Task 6 Instructions
Using business documents
Dave has written a letter to the people he wants to invite to the party. Download the letter from the files area.
Put the details of the letter into a blank letterhead that you prepared in the earlier task. Dave has made two spelling mistakes; put them right.
Task 6 Files
Task 7 Instructions
Mail merging
Now the hard part. Dave wants you to mailmerge the letter with the Party List query that you have created in the database. This way, each person will get a personal letter. Make sure each persons name and address appears on the letter.
Save the mailmerged letter with a sensible filename.
Save the final completed merged letters with a different filename.
Task 7 Help
If you don't remember how to maimerge, try the
Microsoft Website for a step-by-step guide
Or you could watch this video
of a mailmerge
Task 8 Instructions
Complex Reports
Now that the letters are finished, he needs address labels to put on the envelopes.
Go back to the database and create
a new report based on the Party list query. Make sure the report is in the form of address labels. Call the report Party address labels.
Task 8 Help
This video shows how to create address labels in Access.
Task 9 Instructions
Final Printing Checklist
Print out
The Customers table from the database
The two screenshots showing queries
The Local Customer List report
from the database
The output from the Party List query
The merged letter showing the fields
The merged letters to each of the people invited
The Address Labels report from the database
Task 9 Files
checklist.pdf
Task 9 Help
You can compare your work to this portfolio.
Thanks for your help so far, its time to move on. You can go straight to the next task from here See you there!
|
