MS Access / MS SQL DB Revamp, Tidy/Creation NEED ASAP

Ok, so here is the project.

I have a database I\'ve already started. But its got a little bit of work to be done.

I need to be able to generate profit/loss reports based on our different locations.

Each location has a total of 30 weeks .

I am currently able to generate reports with accurate revenue for each of the weeks at each of the locations. I need someone to take my database and redo it. Making it easy for a baby to enter data into it (forms, checkboxes, the whole nine yards). More specifically i need profit/loss for each location. Each week has a set amount of revenue (which i can already generate adn show), and each week has a set amount of expenses which i dont have completed yet. Subtract weekly expenses from weekly revenue and wha la you have your net profit for the week at the particular location.

Ive got an attached DB for you too look over. This is all in access however i would like to have this done in MS SQL, i have a server for you to use. I basically want it so people from more than one location can use the DB.


There are a few other odd scenerios that can be tackeled but that is the gist of it.