Access Online Database - Microsoft Access Forum


	Back to Access Forum Comments List

Access Online Database

Jan Schoeman

6 years ago

Good afternoon Richard. I have been following the access 2013 beginner lessons. Currently on lesson 7. I need some advice, to see if I am on the right path. I want to create a data base where my insurance clients / insurance companies can login and create their own quote.

For example the client can enter the model or features relating to a Television. ( Brand name / screen size / Smart tv) My data base should show the client the options that are available. (Samsung UA43RU7100) There would be a variety of product to select from. TV, hi-fi, pc, appliances, etc. In a few months? time when there is a new model, the same info that the client entered before would give the new model as the correct replacement. (Samsung UA43TU7000)

Once the quote is generated, the client can pay and the quote can be printed or mailed to the client. The insurance companies or client can use this to cost an insurance claim or get an inventory value to confirm if they have the correct amount of cover. At the moment this is done manually via email. I want to automate the process and get the same results faster. Would I be able to achieve this with access?

Many thanks
Jan Schoeman

Richard Rost @Reply

6 years ago

Hi Jan. You can certainly build a database to track all of that information in Access, however Access by itself is NOT an online database. You have a couple of different options. You could build a web site with ASP and have your users enter information that way, and then you could pull the data down to your Access database for processing and then publish info back up to the web site. I cover this in my Web Database Seminar or my Web Sync Seminar. The downside of this is that it's more difficult to build. The upside is that they don't need any special software. They can just use a web browser.

Another option is that you could distribute a front-end copy of Access to your users and keep the data online. This way they are working in Access and you can use all of the functionality of Access (forms, reports, etc.) but your data is stored on a central server. I show how to do this in my Access Sharepoint Seminar and my upcoming Access Online SQL Server Seminar. The downside of this is that your users have to have Access or at least a Runtime copy. The pro is that it's easier to set up.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen