Excel and Access Work
- or -
Post a project like this3129
$200
- Posted:
- Proposals: 13
- Remote
- #878314
- Completed
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
Researcher, Data base building, Lead generation, E Mail database, Data Entry, Research base writing, Market Research,
Bay Minette
Project Manager / SAS Platform Administrator / web and mobile development & analytics
Manchester
1035303342420495724516719649532837804867068907095997331101504210328501034380
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