... sum function which will recalculate the accounts on a daily basis. Graphs can be produced and relevant sections can be printed off. Microsoft access does not have the sum function and would be inappropriate to use for this task. The decision is made to use Microsoft excel for task 1. ? Task 2 - setting up a database to record customer details and to alert when direct debit payments are due from monthly contract customers. From the table Microsoft access is the best option for this task as a lot of information can be stored and data can be input, searched and sorted quickly and easily. The query function is available in Microsoft access but not in Microsoft excel and as this is a vital function, excel will not be suitable for this task. Microsoft access allows different queries to be made using the same parameter. By inputting different dates ...

See this essay or coursework document in full right now