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... Is it possible???:confused
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.........