I would strongly recommend an upgrade to SQL (especially if it is used as a web back-end).
Access can export a db as SQL. Try: Tools > database utilities > upsizing wizard.
As for applications, you need a VB editor to view the source code. You can launch an instance of the editor from the Access environment for macros, but you won´t be able to see the source for a compiled application.
A tutorial on VBA/Access:
http://www.functionx.com/vbaccess/
Hope that helps.