Choice of front end and back end for mini project

Question

0.00/5 (No votes)

See more:

I'm a college student planning to do a mini project. I'v decided to link the college database with the bar code that is already present in our id cards. By using a bar code scanner the bar code can be scanned to retrieve that particular student's data alone..
I'm wary of which database to use as back end, access or sql. Moreover I have the student details stored as excel files.People suggested I use access, as it is easier to convert excel files to access database.But I'm not sure if access would support client server model because the database will be accessed by all departments simultaneously.
I'm also not sure of which front end to use to display the data in forms format.Can I use vb or any other front end??? The data of the database should be modifyable from the front as well as the back end.. I read someone's reply for a access question in which they suggested they could display the details in access database without any special frontend...Some others say that we could use excel as backend and use html to display the data as front end....Is it possible???
I have little knowledge of vb,sql. But i must admit i'm only a Amateur.. I'm totally confuse. Please suggest a front and back end which is compatible with windows xp OS.........

Posted 16-Jan-14 3:11am

Geeky hackling

Updated 16-Jan-14 3:13am

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2014-01-16T05:10:00

This question is impossible to answer in a Quick Answers forum. The best I can do is suggest for backend you use SQL; Microsoft offers various versions and you could start with the Express or Compact editions for simplicity. However, you still need to design the actual tables in the database so you will need to do some analysis of the data you expect to hold and how you need to process it. You can convert an Excel file to SQL by the use of OLEDB as described in Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]. As for the front end, you need to decide whether this will be Windows Form or Web application, and which language you are going to use to code in.

As I said, it's not an easy one to answer.

Christian Graus · Answer 2 · 2014-01-16T10:33:00

The number one answer is always 'what do you know'. If you have no clue what you're doing, then this is going to end badly. I don't get all the people doing 'college projects' that start with 'I have no idea what I'm doing'.

Access is nearly always a bad choice though, because your goal is surely to develop skills that will matter in the real world. If you want to show data via the web, ASP.NET MVC is the way to go. But, of course, you can't run a barcode scanner from a website. So I think this is a client app, AND a website to view the data, at most.

Start by feeling sure you know enough about what you're about to attempt, that you'll be able to finish it. Don't think you can choose something and get people online to do all the work, that's not learning.

Choice of front end and back end for mini project

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Choice of front end and back end for mini project

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us