Access Database Development - Excel Model Conversion

Closed

Qualifications:

- Exceptional Microsoft Access DB construction skills, particularly when data is will be originating from complex, multi-tabbed Excel files

- Adept in using VBA coded macros to aid in the data load/export process

- Ability to organize and quickly analyze data

- IMPORTANT NOTE: Needs to be available immediately, potential 2-3 day turn-around for a functional example "test run", 5-7 day turn around for final product

Job Description:

Looking for an Access developer who will me able to quickly create a database with a form that will allow the user to:

(1) upload a raw data file (that currently exists as an Excel file with one summary page and 30 supporting input/calculation tabs),

(2) select one of 18 different companies,

(3) select one of 78 insurance products, and then

(4) select location for export file, and

(5) click "generate RBC" button to execute the calculations.

The data that will need to be imported and tabled currently exists as 4 separate excel files, one reference file, and 3 others, each with a summary page and 30 supporting input/calculations tabs.

These 3 summary tabs (or the 3 consolidated into 1 tab) will be the final product that is ultimately exported after the database runs, therby reducing these projection files from approximately 90 Excel tabs (30 X 3) to 1-3 Excel tabs.

Skills: Excel, Microsoft Access, Visual Basic

See more: visual basic developer job, vba load, vba access developer, microsoft access job, microsoft access database development, microsoft access database developer, looking for a job in developer companies, job aid example, excel vba developer job, excel vba developer, excel vba db, description of product development, vba and macros, microsoft skills test, microsoft excel vba, microsoft excel test, microsoft excel skills, microsoft access test, excel test for job, excel 2013 vba, developer in excel, adept with, microsoft access developer, vba macros, vba access excel

Project ID: #5156707

42 freelancers are bidding on average $33/hour for this job

illuminesoft

We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years. ID : 5156707 Greetings, We are interested to work on this project, please find my comments in More

$25 USD / hour
(276 Reviews)
7.5
Prashantskin

Res.Buyer I have gone through your project requirements. I will develop access application to import from excel files with 1 summary and 30 supporting sheets and export the data with changes to excel files.. I hav More

$27 USD / hour
(478 Reviews)
6.9
svet63

Excel/Access developer since 1997. Can do. What version of Access do you need it for? Regards, Svet.

$50 USD / hour
(80 Reviews)
6.8
torajiv

Please send me your source files with complete specs. I can start immediately as I do not have any pending projects as of today. I would be willing to do the functional example test run before you accept or reject my More

$25 USD / hour
(80 Reviews)
5.9
finecodervw

The bid might look higher, but once I see the Excel sheet and understand the finer details. I am sure we can discuss and also agree on kind of milestones required. Looking forward to your response. Thanks. ==== Hi, More

$60 USD / hour
(93 Reviews)
5.9
bouslimi1979

Dear, I m VBA Expert and have a good experience in Excel/Access application. I will create the form that will allow you to select the Excel source files and create the DB. I m ready to start today and we should have More

$25 USD / hour
(40 Reviews)
5.3
superior5

I have already done similar project and expert in desired technologies for your project. I will not ask for any upfront payment, pay me only after you are satisfied with the progress. Hope to hear back to discuss.

$46 USD / hour
(8 Reviews)
6.8
KellogITSolution

Hello I am working with MS-Access database and VBA for the past 12 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce More

$27 USD / hour
(34 Reviews)
4.9
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$27 USD / hour
(23 Reviews)
4.9
adaytay

Hi - I'd like to help. I'm a UK-based Access Developer with over 15 years experience in application design and system building. I've worked extensively with Excel and Access at an advanced level, and can do what yo More

$28 USD / hour
(11 Reviews)
4.8
expertcoder1vw

Hi, I'm an expert Access / Excel / VBA developer and am interested in this job. I read andunderstood the specifications. I am interested in a fixed-price job valued at $600 for this job. I can start immediatel More

$25 USD / hour
(17 Reviews)
4.7
habibjanjua

Dear Sir, Please review my sample work and CV on following links, I request to schedule a meeting using teamviewer remote session and skype voice call to demonstrate you my enterprise level relevant projects. htt More

$25 USD / hour
(14 Reviews)
4.6
fabest

Dear, I am Access automation Expert since 11years. I am used to extract data from xls file, and import them into access. I can start right now, please let me know. I will be available after development, as support. More

$25 USD / hour
(9 Reviews)
4.6
CARLOSHUGGINS

Hi your search is over.... I'm a 12 year experienced VBA developer....I will deliver high quality results... and fill all your profile requirements..... I' m also availabe ata 16 USD / Hr rate... the best value for yo More

$25 USD / hour
(8 Reviews)
4.3
mail2vimalarora

Hi... Since I have worked on MS Access database which includes complex queries, forms and reports including VBA coding, and also feel comfortable in connecting MS Excel to MS Access and vice versa. Also can deliver you More

$25 USD / hour
(9 Reviews)
3.7
nmcdorman

craniusmaximus1, My name is Nathan. I am a full-time DBA and VBA developer. I have a lot of experience creating applications within Excel & Access and Importing/Exporting data from databases including Access and MS SQ More

$42 USD / hour
(1 Review)
3.6
esadeghi59

I have over 10 years experience in MS-Access & ready to start working. My services are fast & reliable and you can trust me to do your project.

$25 USD / hour
(6 Reviews)
3.5
juan1matos

Hello there, I'd like to work on this Access project. I'm good with Access/Excel VBA and understand that you need a test run version in 2 - 3 days. I'm going to step out now and won't be able to check my email unt More

$41 USD / hour
(13 Reviews)
3.4
elboukharimu

Hi, I'm very interested helping you creating your Access database, I have more then 7 years of experiences on SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, t More

$39 USD / hour
(3 Reviews)
3.4
AccuPro

Hello, I can definitely help. This project is interesting and it belongs one of my strongest skill sets. Let me know if you are interested. As requested, we will first do a test run and then the final. Best regar More

$25 USD / hour
(4 Reviews)
3.1