• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

Simple Data Entry Website

I get around VBA and MS Access quite well but when it comes to the internet i have no idea where to start. I would like to build a simple, extremely simple website to collect some data from my Project managers. the would be accessing this site from their tablets.

Basically, i need 3 columns.
1st column is a label field only. used for grouping.
2nd columns would be text field and data would come from the project managers.
3rd column would be a number field and data would come from the project managers.

that's it in a nut shell.  Basically it's just an excel spreadsheet.

We have tried using spreadsheet applications with the tablets and they suck, data entry is difficult.

When they are done with the data entry for that session, the data would either be emailed as  a simple csv file or collected in a database somewhere where i could get to the data and import into my database.

I have looked at some of the free website builders and i can't find anything that would come close to what i need.

If i could just get pointed in the right direction i think i would be able to build something.

thanks everyone.
1 Solution
I don't consider Access web apps ready for prime time but for this application, it would probably do.  But - to do this, you need SharePoint and Access 2013.  A business Office365 subscription should give you what you need to build the app for $15 per month.  With the Access web app, your users all need to be known AND they need to have Access installed or the Access 2013 runtime.

The Access web app will use SQL Azure for the BE database and you can have a FE that links to the same database so the input from the notepads would be live and wouldn't need to be emailed.

One thing with the Access web app is that it doesn't support code.  There is no VBA at all.  Everything you need to do must be done with macros (which have been expanded to some degree).  You also don't have true reports or form events that you are used to.  But for something simple and straight forward, it should be fine once you get past the cost of entry.
jb702Author Commented:
The only person that would be building the application would be me, my project managers would just be entering data into the app/website. would they need subscriptions to office 365, or would they just have to go to a website and enter the data.
If you have a simple (32bit!) server running you can make it yourself easily. Remember the server must be connected to the internet, not just local.

On the server install the role: Webserver (IIS) and activate the option ASP.

When u finished creating the database (access: .mdb) you need the Data source connector called ODBC to make a System DSN, name it and locate your .mdb file. You can also use a DSN-less connection, examples are here: ODBC DSN-Less

To make a webpage you can consider using Adobe Dreamweaver. In Dreamweaver you can make a new ASP/VB file and connect it to the ODBC. Now you can make insert / update / edit and delete pages.
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Walter CurtisSharePoint AEDCommented:
Access has some built-in web page and site creation process, that are wizard based. You can have a site you describe created quickly using Access. Not sure what version you have, but Access 2007 /10 /13 all do this. You can also make the pages available to your users as you describe with not much effort.

Give it a try. Hope that point you in A direction. As you see with the good comments above, there are different ways to do this, and there is not just ONE right way to do it.
jb702 - only the developer needs the $15 per month Office 365 subscription but all the other users need either Access 2013 full version (which is not free) or the runtime engine (which is a free download from MS).

SneekCo.  I guess you didn't see my original suggestion.  But in addition to what I said I would not even consider attempting to build a web app with earlier versions of Access. MS has deprecated all the older features and what they do with A2013 is not compatible with older versions of Access.  The older versions do not include a subscription model so you would need to either host your own SharePoint site or get one at a third party (for more than $15 per month)
jb702Author Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now