Need a small access database tweaked
- or -
Post a project like this2997
£150(approx. $188)
- Posted:
- Proposals: 9
- Remote
- #1022220
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Database for call centre requires couple of tweaks
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: i have an Access Database developed in version 2010. Its a very basic database designed to be used by a call centre for an interim period for logging information. There are a 5 bits of developments that I need fairly urgently.
1. I would like an additional field to be added on a table. The field will use a simple lookup table, and be accessible on two forms. It will also need to added in an export routine that I think was developed in VBA.
2. There is an Form Export routine that caters for searching by one of two dates. When the 2nd date field is selected, and a date range is applied, it is not pulling the right records out. I think this was also developed in VBA.
3. Deployment needs to be executable because there will be multiple users . With over 400K names, the file is too large to make a Exe - I get an error.
I've tried using the Database Splitter tool within Access and just making the Forms part of the DB into an EXE, that fails too with the same error. From Googling (see http://firstblogofvarun.blogspot.co.uk/2010/02/microsoft-access-was-unable-to-create.html), its possible to still create the EXE through the VBA module, but I dont know how!!
4. The database window appears too big for a standard monitor.
5. If possible, I'd be happy for you to make other recommendations on improving look and feel.
I can provide a dropbox link, the database is around 150mb. Also happy to screenshare over skype.
Extra notes:
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: i have an Access Database developed in version 2010. Its a very basic database designed to be used by a call centre for an interim period for logging information. There are a 5 bits of developments that I need fairly urgently.
1. I would like an additional field to be added on a table. The field will use a simple lookup table, and be accessible on two forms. It will also need to added in an export routine that I think was developed in VBA.
2. There is an Form Export routine that caters for searching by one of two dates. When the 2nd date field is selected, and a date range is applied, it is not pulling the right records out. I think this was also developed in VBA.
3. Deployment needs to be executable because there will be multiple users . With over 400K names, the file is too large to make a Exe - I get an error.
I've tried using the Database Splitter tool within Access and just making the Forms part of the DB into an EXE, that fails too with the same error. From Googling (see http://firstblogofvarun.blogspot.co.uk/2010/02/microsoft-access-was-unable-to-create.html), its possible to still create the EXE through the VBA module, but I dont know how!!
4. The database window appears too big for a standard monitor.
5. If possible, I'd be happy for you to make other recommendations on improving look and feel.
I can provide a dropbox link, the database is around 150mb. Also happy to screenshare over skype.
Extra notes:
Reza I.
100% (4)Projects Completed
7
Freelancers worked with
6
Projects awarded
25%
Last project
16 Sep 2016
United Kingdom
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