what tools do i need to create a desktop-based application?

[fadhili]

I want to make a desktop-based application with front-end being MSaccess which can be accessed on more than one computer, and its back-end being mysql database on my clients server, accessible by only one user, and the software should be wrapped up in an installer.Help me guys what tools do i need to accomplish this task?

[sicarie]

I would recommend a good developer. They will take your idea of a program and create it. I'd recommend making sure you have good requirements and acceptance criteria around it, but that should be what you need.

If you are doing this yourself you will need:

1) your program broken down into a flow chart for every behavior, usage and permutation - aka the algorithm or pseudocode
2) a compiler or IDE
3) knowledge of your desired programming language
4) ability to interface with your desired OS' API

That being said, I'm not sure why you would need an Access front-end and MySQL back-end, they're both databases. If you're using MySQL, just stick with that.

Front-end is the interface. You don't see the code behind this bulletin board system (it might be PHP, it might be plain HTML, it might be Ruby; and as this is in a web browser, it's different from a desktop application) you just know that you're using it to get to the threads, comments, and ideas to help you.

The back-end is how all those threads, users, and everything else is stored (database like MySQL) and managed.

[NitinSawant]

P.s. Front end cannot be ms access

For windows development there is all-in-one tool:

1. Visual Studio

[fadhili]

thank you verry much guys! from your advice i decided to use vb6 coz i have it and atleast i know a little about it. But am having problem the software am making is an examination software where by multiplechoice question are inserted on the db backend which they are to be retrieved by student on the frontend.
One of my objects in my frontend form is a combobox that contains answer A,B,C,D.
my problem is i need a COMMAND that will prompt the next question(desplayed on the question textbox)extracted from the database(backend) i have created when the user clicks an answer from the combobox.
pz help.

[sicarie]

That is an excellent question, however the wrong place - I would suggest asking that in our VB6 forum

[fadhili]

OK, thank you i will do that!!

[thelionheart]

if you want to create a desktop based application, you must study a programming language first. I recommend you to choose Visual Studio for desktop apps.