Tables Information from an ACCESS database

Many a times, we need infromation to get number of tables listed in an ACCESS database. There is a hidden table which contains this information. Query to get this information from ACCESS database is as follows:

SELECT NAME from MSysObjects where TYPE=1;