How would you display via an SQL statement, using Access 2003 with an MDB type file, a table structure for table tblTest?

As in "describe tblTest"?

I think "Describe" works for SQL Server but not for Access mdb type files.

If there's not a describe command, you could do it in a script:
http://www.access-programmers.co.uk/forums/showthread.php?t=133274

Direct sql syntax "sp_columns @table_name=[tablename]"

How do you want to view the layout as in to what medium do you want to display it too ?
eg:

1. Program to display to some window
2. Write to some sort of file
3. Pop out a message window

or:

using MSACCESS only without and SQL statement it has a function to show you the table design
by going into the database (MDB/XXX) right click the table and click design view...

or

using MSSMS ( Microsoft SQL Studio Management Studio ) **but this wouldnt be a MDB file but rather a sql server database and following pretty much the same route...***