Access Database Development - Excel Model Conversion


- 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

About the Employer:
( 0 reviews ) United States

Project ID: #5156707

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


[login to view URL] 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
(492 Reviews)

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
(255 Reviews)

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
(81 Reviews)

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

$50 USD / hour
(81 Reviews)

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
(162 Reviews)

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
(147 Reviews)

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
(117 Reviews)

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
(95 Reviews)

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
(101 Reviews)

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
(26 Reviews)

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
(37 Reviews)

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
(12 Reviews)

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
(12 Reviews)

We have over 10 years in the software development field and a long list of satisfied customers and we have managed over 50 projects both in windows and web application development. We will be happy to provide additiona More

$33 USD / hour
(5 Reviews)

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)

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
(2 Reviews)

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
(6 Reviews)

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
(7 Reviews)

Hi, I am very much interested in your project. I am in IT profession for more than seven Years. I have done a lot of projects in different languages and databases. Recently, i developed a bid Financial Applicatio More

$41 USD / hour
(3 Reviews)

hi I am experienced developer. I can create database and form for you. I have one query , in skills you specified Visual Basic , Do you want to create form in Visual Basic 6 ? thanks

$25 USD / hour
(5 Reviews)