Excel/visual basis/access demo

In Progress

I need a demo application so that when a excel user enters data that it gets saved into an access database that is on a network drive.

The same application needs to be able to query the information from an access database to display in a different excel spreadsheet.

So, basically I need a demo of crud operations (create, review, update and delete) from excel to an access database using Visual Basic.

Details.

So, since this is a demo, I will randomly create some passing criteria.

Lets say that user 1 enters monthly sales total data for store 1 into an excel spreadsheet.

Lets say that user 2 enters monthly sales totals for store 2 into an excel spreadsheet

Both user 1 and user 2 use the same spreadsheet and setup.

Behind the scenes, their monthly sales data is being stored in an access database. The database consists of a store table and sales table.

The store table simply has a name and an id

Ther should be an excel spreadsheet with a name entry field with a button to create a store

After the store name and store is created a different excel spreadsheet would be populated with the name and is of the store with 12 places to enter the totals for every month of the year. If an amount is entered. The amount will be automatically stored in the database for that date.

The sales table has a store id, a date and an amount.

User 3 has a totally different spreadsheet which shows the totals of store 1 and 2

User 3 has a spreadsheet for store totals per month. User 3 has a spreadsheet for all totals.

Extra credit and bonus for somebody who can display the totals of both in a pie chart and a bar chart with the totals of store 1 and store 2

This may be a bad demo but the demo doesn't matter. All I care about is a demo of how todo insert update create delete from excel to access using Visual Basic. They key is that the access database needs to be located on a network drive.

Ill look forward to your bids and your comments because I'm not sure if this is a good enough demo project. Maybe you can think of something better to demonstrate crud how I want it.

Skills: Excel, Microsoft Access, Visual Basic

See more: demo excel access, want to create a chart, pie database, excel to application, create a table chart, create a bar chart, Visual Basic Excel, excel visual basic, excel to access, database crud, access 2013 insert button, excel database visual basic, create access database spreadsheet, access delete, excelchart, setup database excel, excel access table, chart bar chart, access chart, project 2013 access, visual basic database excel database, access query table, excel project use database, table crud, visual basic access application

About the Employer:
( 3 reviews ) Union City, United States

Project ID: #4509805

Awarded to:

pddonnelly

Hi actifectcorp, Thanks for this, it was a very interesting piece of work! I've already built a fully functioning sample based on the requirements you specified in your bid, and full details can be found in the PM I s More

$277 USD in 1 day
(1 Review)
2.9

27 freelancers are bidding on average $426 for this job

illuminesoft

Do you want to use Excel as front-end just because its demo ? we can create using MS Access as well for demo. But if the target PCs won't have MS Access installed, your decision to go with Excel front-end is right. More

$405 USD in 7 days
(275 Reviews)
7.5
HussienSharaf

Dear Sir, I can make a perfect solution using Access and allow for multi-user via network. The data can be migrated from excel to Access once.

$800 USD in 3 days
(60 Reviews)
6.6
Premshanks

This is how I shall help you with the demo of CRUD from excel to access (in network drive) a. create a ms excel form where the store information can be entered and it would be stored in the ms access b. And anoth More

$332 USD in 3 days
(186 Reviews)
6.0
Nhcuong

Hi, i can do it. Please give more detail about: Excel version used Access version used Any network accessibility specification. Best regards, Cuong NH

$277 USD in 10 days
(28 Reviews)
4.9
DenisSmolentsev

Hello! Let me propose you all the best of my experience with Excel, Access and Visual Basic programming. Thank you! Denis Smolentsev.

$555 USD in 10 days
(39 Reviews)
4.5
pesek

You could use VSTO for sycing between excel worksheet and ms access database.

$526 USD in 3 days
(6 Reviews)
4.4
oFAZo

I am an expert at MS Access & MS Excel, communicate well and work under strict timelines. This is quite an easy project and rest assured will be done within 2 days. Looking forward to working with you!

$333 USD in 2 days
(16 Reviews)
4.2
fabest

Dear, I am Excel/Access/VBA automation expert since 11 years. I already develop kind of tool with excel link to Access DB. If you are interested please let me know, I will provide short example. Regards, Fabrice

$494 USD in 3 days
(5 Reviews)
4.1
emakis

Over 20 years of experience in organization environments with much pressure and critical situations. SQL Server, VB.NET, MSAccess, ASP.NET, HTML5, Javascript, jQuery, CSS3 at your disposal.

$277 USD in 3 days
(3 Reviews)
3.9
PerfectSquare

Hi I am experience programmer. I can do this Let Start Thanks

$526 USD in 6 days
(29 Reviews)
4.0
parsermonster

Dear Project Manager, Let me discuss my super secret CRUD recipe with you. Please look in your in box. Regards, Mitchell Allen

$555 USD in 3 days
(8 Reviews)
3.8
srdas2012

Ho We are Expert in Similar Type of Applications,Exeprts in VB/Vb.Net/VBA/Access ,Please see attached sample

$650 USD in 8 days
(11 Reviews)
3.5
geogeorge2

Very experienced database, excel and vba developer.

$298 USD in 10 days
(1 Review)
1.7
anomanpk

I would like to offer my services for this job.

$555 USD in 15 days
(1 Review)
1.4
bryant1003

Hi, In my professional line of work I employ the use of Excel and it's integration with various database platforms and perform CRUD operations using the interfaces that I develop from scratch on a daily basis. These More

$250 USD in 3 days
(2 Reviews)
1.1
vaibhav585

Ready to start , expert in Microsoft Application ( EXCEL and ACCESS) ,this is cake walk , and you are paying much more than required $ amount , Please see PM for detail for our approach and quotation !!

$250 USD in 3 days
(1 Review)
1.0
amitchaps

Interested.Expert in Excel/Access applications.Kindly check my PM for details.Thanks,Amit

$500 USD in 7 days
(1 Review)
1.0
onlineupdatebd

100% Job Satisfaction will be provided. Check PMB Thanks.

$277 USD in 7 days
(1 Review)
0.0
tarakeaziz

Please check your PMB.Thanks

$449 USD in 30 days
(2 Reviews)
0.0
athaulsl

100% Job Satisfaction will be provided. Check PMB Thanks.

$277 USD in 3 days
(1 Review)
0.0