• Set up a database for a company that sells tools and equipment.  
• Your customers have an account with this company. 
• They pay for their goods AFTER the goods have been delivered.  
• Make up a name for this company.

Some customers are in credit. They have money in their account.

Some customers are in debt. They owe you money for an item that they have bought.

Create a database with records for 10 customers with the following fields.

Make up the names and addresses of your customers and the items that they have bought.    Your customers can have between £500 in credit to £500 in debit. They might have bought this item up to six months ago.

Create three filters for customers who owe:

•  more that £50
•  more than £100
• more that £300.

EXTRA You can include criteria for date if you want to. Also create a filter for customers that have some money in their account.

Task 2

Using the Microsoft Works Word Processor write a letter to your customer reminding them of the need to clear the debt on this account.

Sample text.

Dear Sir/Madam

According to our records you purchased a ??? on the ??? which cost ???.

This item has been delivered so could you please promptly pay for this item either by cheque or by arrangement with our accounts department.

Please contact us if you have any problems with this matter.

Yours truly,

Merge your filters into this letter.

<< Back