Unit 1f
Unit 1f - Using a database
Now that we are using more ICT, we decided to sort out some computerised donar lists. Liz has used a database to record the names and addresses of some people who have given money to the shelter as a charitable donation in the past. 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 shelter 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
donors.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
Rob is thinking about having a special fund-raising evening. Perhaps a charity auction.
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 Tilsham.
Name the query Local Donars 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 Donars List
Task 5 Instructions
Complex queries
Rob has been thinking about the evening and thinks it will be more exciting if there are more people involved. He thinks the people who might enjoy an auction are the older generation.
Create a new query, this time list everyone who is
From Tilsham or Chapham
betwen the ages 40-65
(inclusive)
in alphabetical order by surname ascending.
Name the query Auction 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
Rob has written a letter to the people he wants to invite to the auction. Download the letter from the files area.
Put the details of the letter into a blank letterhead that you prepared in the earlier task. Rob has made two spelling mistakes; put them right.
Task 6 Files
Task 7 Instructions
Mail merging
Now the hard part. Rob wants you to mailmerge the letter with the Auction 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 Auction List query. Make sure the report is in the form of address labels. Call the report Auction 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 Auction 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!
|
