Oh so confused...Question regarding Catalogs and Metadata

[Catherine Arnold]

I have an assignment in my db design class that is asking me what the
catalog is in Access since it is not commonly referred to as the catalog. I
have searched high and low for this information. The description of a
catalog is data that stores information about the data in the database. Talk
about vague! I may be overthinking this, but I have no idea what this could
refer to. Can someone help me? Please? Pretty please?? And thank you in
advance

 

[Tony Toews]

I have an assignment in my db design class that is asking me what the
catalog is in Access since it is not commonly referred to as the catalog. I
have searched high and low for this information. The description of a
catalog is data that stores information about the data in the database.

This sounds like the table and field definitions. Tools >> Analyze >>
Documentor or something similar depending on your version of Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[David]

Maybe the system tables in Access - MSysObjects and MSysQueries?

To view them click "System Ojbects" in Tools, Options, View tab.

 

[Dirk Goldgar]

I have an assignment in my db design class that is asking me what the
catalog is in Access since it is not commonly referred to as the
catalog. I have searched high and low for this information. The
description of a catalog is data that stores information about the
data in the database. Talk about vague! I may be overthinking this,
but I have no idea what this could refer to. Can someone help me?
Please? Pretty please?? And thank you in advance

Another possibility is that the question is referring to the database
window.

 

[david epsom dot com dot au]

Another possibility is that they may want you to say
"In Access the catalog is the TableDefs collection"

(or the querydefs collection or the views collection...)

(david)

 

[bigturnip]

Just to add another option.

Maybe the catalog object in ADO or ADOX where you catalogue and stor
information about tables, queries etc.

 

[Tony Toews]

Just to add another option.

Maybe the catalog object in ADO or ADOX where you catalogue and store
information about tables, queries etc.

Or to add a 3rd opinion. The instructor has never worked with Access
themselves.

Or 4th. They have a generic assignment from a few years past they
threw at the students. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm