• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Survey site for colleagues

 
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All,

My friend needs to create a questionnaire site for her colleagues. She knows just the basic javascript and also doesn't want to install third party tools unless really required.
I need your suggestions for the technology stack requirement.

Is it possible to use MS Access for storing answers for different employees ? If yes, can I simply create different pages using HTML & JS and use Access as DB?

Thank you !
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Why not just use one of the available survey services to create your own surveys?
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
But, to answer your question, Access is not a good choice for a database. There are plenty of freely available "real" databases out there; choose on of them if you decide to build something yourself.
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Bear.
The third party ready to use services are not allowed due to privacy issues. I want to build it myself. Could you please suggest on the required stack.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There is no one "required" stack. What are you familiar with?
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
For me, I'd create a RESTful API web service in Java to handle the back end, using JPA for persistence and likely using one of PostgreSQL or MariaDB. There are other free and easy to use databases available. Access is not suitable because it's not a real database with proper JDBC support.

For the front end, I'd use HTML5 and either jQuery, or AngularJS. And likely Bootstrap for out-of-the box styling.

But that's me. What are you already familiar with?
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm familiar with Java, Spring, HTML, CSS, JS, jQuery, Ajax, MySQL, Oracle etc. The thing here is that she doesn't want to install third party tools and want to make use of things that come pre installed on office computers like MS Access. I haven't used MS Access, so not sure about it. Can I store user answers in MS Access using js ?
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

pramod talekar wrote:Can I store user answers in MS Access using js ?


No.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You seem to be a tad confused here. You are planning this to be a web application, right? That's why you posted it in the HTML forum?

Then the only place any software needs to be installed is on the server, not on the office computers.

If you want to create a web application without any software, well, that's just not going to happen. You need a database, and you need a web server such as Tomcat at minimum.
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes Bear, I understand that at least a Tomcat instance will be required. But I want to make use of other available resources like MS Access if possible. I came across the below link but not sure if it really worked or not.

http://stackoverflow.com/questions/9777038/read-and-write-to-an-access-database-using-javascript

 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think that assumes that you will be using JavaScript on the server via something like NodeJS. I assume that's not the case? Besides, there didn't seem to be much success with that, was there? Do you really want to get involved with something that other people haven't been able to get working?

Looking at your technology list I'd be assuming you'd be using Java/Spring on the server.

Access does have an obsolete JDBC-ODBC bridge but it's not stable and not recommended. Why not look at the new and simple Java databases such as Derby? (I haven't used them myself yet but I hear good things.) If you are going to need Tomcat, having a database isn't much of an additional burden.

In my opinion, trying to shoehorn something unsuitable like Access into the mix will cost you more time and frustration than it'd be worth -- assuming you can get it working at all.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That all said, again, I'd just use an existing service such as SurveyMonkey which guarantees security, and will likely cost far less than the man-hours you'd need to put into this.
 
pramod talekar
Ranch Hand
Posts: 367
Eclipse IDE Opera Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot Bear for your suggestions!
I'm going ahead with Derby,Tomcat and Java.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Good luck with your project. And of course be sure to post back at the Ranch with any problems you come across.
 
reply
    Bookmark Topic Watch Topic
  • New Topic