System Catalog problems

[raziel86]

I'm having trouble with this question



Write the SQL commands to obtain the following information from the system catalog:
a. List every table that you created.
b. List every field in the Customer table and its associated data type.
c. List every table that contains a field named ItemNum.

I'm on part b. The book gives the example of how to do a similar search which is

SELECT Colname, Coltype
FROM Syscolumns
WHERE Tbname=’Item’ ;

I changed this to

SELECT Colname, Coltype
FROM Syscolumns
WHERE Tbname='Customer';

and I get the error

The Microsoft Access database engine cannot find the input table or query 'Syscolumns'. Make sure it exists and that its name is spelled correctly.

What am I doing wrong? Do I have to create an index first.
To get part (a) I used the following code

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

[NTC]

in the Navigation Pane there must be a table or query named 'Syscolumns' and it must have the fields that you specify

[raziel86]

I thought the System Catalog was created automatically and that you could query from it.