Are we able to find all tables within the msaccess using sql .

once we do in sqlserver

select * from sys.tables  

in sqlite

SELECT * FROM sqlite_master where type='table' 

Use MSysObjects

SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0

Ms Access has several system tables which are, automatically, hidden from tables list. You are able to demonstrate to them.

In Ms Access 2007 perform a right click tables list and choose Navigation Options. At the end from the form you'll find Show System Objects check box. Check it and system tables can have up in tables list. All of them begin with MSys.
Alternatively, options form could be triggered from application menu - click button Access options -> choose Current Database and there's Navigation Options button.

You can now examine structure and contents and generate queries of system tables with MsAccess tools.

As Alex clarified, table details are in MSysObjects