Excel and Access Work
- or -
Post a project like this3156
$200
- Posted:
- Proposals: 13
- Remote
- #878314
- Completed
Description
Experience Level: Intermediate
General information for the business: Construction Company
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: I have a spreadsheet (2 actually) that we use to track the sales of each sales rep in our company. As the sales rep meets with a potential client, they enter the pertinent information into an excel spreadsheet. The spreadsheet allows them to track job/quote status, etc. When a job is marked sold, a separate, linked spreadsheet allows the owners to see the commission due. I want to take those two spreadsheets, and keep the interface basically the same, but make a few back end changes. The main change is that I want all the sales reps to be able to have the data entry interface (Excel) open at the same time. The file is stored on a network drive, but as it is now, only one rep can have the file open and make changes to it at a time. I want them to be able to make changes and updates all at the same time.
Extra notes:
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: I have a spreadsheet (2 actually) that we use to track the sales of each sales rep in our company. As the sales rep meets with a potential client, they enter the pertinent information into an excel spreadsheet. The spreadsheet allows them to track job/quote status, etc. When a job is marked sold, a separate, linked spreadsheet allows the owners to see the commission due. I want to take those two spreadsheets, and keep the interface basically the same, but make a few back end changes. The main change is that I want all the sales reps to be able to have the data entry interface (Excel) open at the same time. The file is stored on a network drive, but as it is now, only one rep can have the file open and make changes to it at a time. I want them to be able to make changes and updates all at the same time.
Extra notes:
Michael E.
100% (5)Projects Completed
8
Freelancers worked with
7
Projects awarded
55%
Last project
3 Aug 2019
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies