Qn 1:
What is the difference between Windows Sharepoint Server and Office Sharepoint server?
For my purpose, where I require workflow and forms/input pages, which server do I require?
Is there development version of the sharepoint server? (just like sql express for sql server?)
Check out the URL below of WSS and MOSS differences
http://office.microsoft.com/en-us/products/FX101758691033.aspx
SharePoint does not have a developer edition, FYI SQL Server Developer Edition is actually SQL Server Enterprise Edition with 1 connection. Unlike the Dev. Edition, Express Edition can be deployed in production environment, but Developer Edition does not allow that. When you talk about development on SharePoint, you choose either WSS, MOSS Standard or MOSS Enterprise and run it on Windows Server 2003.
Qn 2:
Other than using Infopath forms can we developed our own application/web pages using C#.net and deploy it to sharepoint to be hosted and access to those webpages be controlled by sharepoint?
Besides InfoPath form, you can also use ASP.NET pages as form in a SharePoint workflow, they are no different from a normal ASP.NET page. And the data is stored either in a database table or a SharePoint list (vis SahrePoint object model). Quite a bit of development is needed and users cannot edit the pages easily.
Qn 3:
What is Sharepoint Designer used for? Is it a must? Or the same can be achieved using Visual Studio .Net 2008/2005?
Is it necessary to use VS.Net 2008 or 2005 can be used as well?
SharePoint Designer is actually the new version of FrontPage which is meant for end users to edit the look and feel of a SharePoint site, customize workflow and manages the documents within. Of course Visual Studio has more features but it’s too technical for normal corporate users. Find out more at the product website: http://office.microsoft.com/en-us/frontpage/FX100743231033.aspx
Qn 4:
For the purpose of developing reports for SQL Reporting Services, is the Express version sufficient or do we require the standard edition… I notice on the website it said “Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download.”
To run SQL Reporting inside SharePoint, you need to install the Reporting Services addin for SharePoint, which under the requirement, it says does not run on SQL Server Express. Only SQL Server Standard and above is supported. http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en