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 been using the mountain bike uplift. 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
Jay is thinking about starting a competition to encourage more people to hire bicycles.
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 Cwm Bryn.
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
Jay has been thinking about the competition and thinks it will be more exciting if there are more people involved. He has finally decided to hold a mountain biking race for the 16- 25 year olds from Cwm Bryn and Donafon.
Create a new query, this time list everyone who is
From Cwm Bryn OR Dunafon
betwen the ages 16-25
in alphabetical order by surname ascending.
Name the query Competition Entries
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
Jay has written a letter to the people he wants to invite to the competition. Download the letter from the files area.
Put the details of the letter into a blank letterhead that you prepared in the earlier task. Jay has made two spelling mistakes; put them right.
Task 6 Files
Task 7 Instructions
Mail merging
Now the hard part. Jay wants you to mailmerge the letter with the Competition Entries 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 Competition Entries query. Make sure the report is in the form of address labels. Call the report Competition 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 Competition Entries query
The merged letter showing the fields
The merged letters to each of the competition entrants
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!
|
