MS ACCESS Query

[Amjad]

when i execute below query i get list of tables in ms access, like in SQL
Server i can run view to show column information associated with eash table.
how i can see in query each table names and also its column information like
each column anme datatypes etc. thanks

SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.LvProp,
MSysObjects.Owner, MSysObjects.ParentId, MSysObjects.Flags, *
FROM MSysObjects
WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0));