List All Tables of Database

Solutions :  1

                       Use Database name
                 GO    
                       SELECT [name] FROM sys.Tables Order By name asc

                      (OR)
                SELECT [name] FROM sys.tables WHERE is_ms_shipped=0 ORDER BY name ASC

Solutions :  2
MS access 

SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name Not Like 'MsyS*' AND MSysObjects.Type=1 ORDER BY MSysObjects.Name