The answer is it depends on what you're doing. You can create DataView
Web Parts with FrontPage that can provide read-only views of any data
(i.e. from an Access database, SQL Server, etc.). You can also interface
with the data using custom built web parts say to write information to
it. The other alternative (and I don't know your requirements on why
you're integrating  with an Access db) is to build the Issue Management
tool in sharepoint  using the tools  already there. SharePoint has an
Issue tracking list as one of the templates and this can be further
modified to suit your needs. You could also go down the InfoPath route
with SharePoint hosting the forms and providing views of the information
for reporting type functions. As well, if you have some Excel skills you
can serve up spreadsheets that are connected to SharePoint lists so that
people can use Excel to update the site  and use the site tools (like
custom views) to show the information the way you need it. Again, there
are lots of options here.