Let me start by defining the general problem I am aiming to solve:
PartA: Create a weekly reporting form(s) for 4 sections: Service, Sales, Credit, Costs (this one is monthly or "4 weekly").
PartB: From the forms that are submitted, an excel or access program should create visual reports (charts, pivot tables) using ...