I assume you are referring to tabsheets/page controls. There is no such thing in HTML. You can mimic them using javascript and/or PHP. As well, there are no "autocomplete" combo-boxes. They will auto-search but I believe that that only works on the first character.
Fireworks CS3 is a very good graphics design tool and obviously you can use photoshop for layout designing purpose. Then you can use Dreamweaver CS3 for HTML/CSS template coding
ASP allows you to interact with any ODBC-compliant database, like MS Access Often times developers are connecting to a SQL Server database, but there are many who are connecting to Access databases as well.