Guys I have a similar project and was just wondering about what language/program I should use... I was thinking somewhat on the lines of Access,SQL, Visual Basic.

As a relative newcomer I don't understand these and it would be of great help to me if you people could just explain to me the pros and cons of the above mentioned systems.

Thank you

First, its not a good idea to piggyback your question on someone else's. This can cause confusion. So I've moved your question to it's own thread.

Visual Basic is a programming language. It's a compilable language, which means one can make a stand alone executable using it. Access is a database development platform. It includes tools that make it very easy to create forms, report, queries etc. SQL is a query language used to retrieve data from SQL compliant databases like SQL Server, MY SQL, Oracle etc.

So these are all different options and may not be mutually exclusive. If you give a brief description of your project we may be able to help further.

The three parts you mentioned can join together to produce something. You create a program in Visual Basic. That queries a database via SQL and that database is managed using Access. You're running before you can walk though. Decide on what you want to do first, then pick the best tools for the job. Don't do it the other way round.