You can use Access but you have to remember that Access is not a full DBMS. You can have Access on the background but depending on the amount of users and the load you put to it you may end up having problems.
Now one nice thing is scalability if you start with Access and realize that your users are growing and you are getting affected by the traffic and concurrent connections then you can upgrade to something with more horsepower like SQL server.
You have more choices on DBMS MySQL is a nice and free good option.
You could also use Oracle if you have the money to afford it.
On the Application side you have a bunch of choices The most obvious will be ASP if you are using Access or SQL Server but it's not your only choice by any means.
You have Coldfusion (nice but expensive),
JSP (Free.. just go to
and look for the Jakarta project, then Tomcat)
ASP
PHP
You could also use some Perl or Phyton (CGI but still works).
Check the Internet for different Web Host services. Most of them offer "Combos" where they offer you a full application environmet with a pre-set configuration.
Windows-Access-ASP
Linux-MySQL-PHP (usually know as a LIMP configuration)
Windows-Oracle-JSP
Windows-SQL Server-ColdFusion
look for the one you feel more confortable with.