For ICT coursework, my sons have to create a digital system to manage customers, bookings and pitches for an imaginary 5- and 7- a-side football company. They have been given csv files for the customers, pitches and bookings. The system should allow users to to view information and generate reports on pitch use and customer bookings.
It then requires the boys to create a spreadsheet that will automatically generate invoices based on bookings and customer information stored.
The boys are really struggling and I have NO idea of how to help. I have tried to look at Microsoft Access and Excel but do not know which is best (easiest) and then, what steps to take.
Any guidance would be appreciated.