Question Can someone explain what this means?

[Jay13]

I've created a database of 3 tables, and have been asked:

"Create an automated object definition using Access. The definition should show: -
Table - properties and relationships
Field - names, data types, sizes, properties and index names
Fields and properties"

Please can someone explain what an automated object definition is, and how I'd create one on Access (2007)

Any help greatly appreciated!

Regards,

Jay

 

[rzw0wr]

Is this a school project?
Who asked this?

Dale

 

[Jay13]

It's part of a school project, I've created the tables and have no idea what this following question means. I'm not asking for anyone to do it for me or anything, rather explain to me how I would do it, as I have many more to complete after this. It's just something I need to know but I've been absent a lot from this class for unforeseen personal circumstances.

Thank you for reading.

 

[rzw0wr]

Create an automated object definition using Access.

Well Jay,
I am not real sure what they mean either.
From the rest of the statement your teacher wants to see how you are designing your database.

Table - properties and relationships
Field - names, data types, sizes, properties and index names
Fields and properties"

Looks like they are asking for you to show what your tables will be, the names of the fields within the tables and to state the data types of all fields, to state the properties and the index names for all the fields.

This can come from Access after you have made your tables.
If they want it before you start your database you will have to write it all out.

Dale

 

[rzw0wr]

BTW Jay.
If you are going to post to more than one forum then please tell the members you have done so.

Dale

 

[Jay13]

BTW Jay.
If you are going to post to more than one forum then please tell the members you have done so.

Dale

why?

 

[rzw0wr]

Just you are using the member resources of 3 forums. IF one member at each forum works on your question and comes up with an answer then 2 have done the work for nothing. THAT means the 2 other members that might also need assistance have to wait until we have finished getting you an answer that you will get 3 times.

Dale

 

[Jay13]

I already have all the data typed out. Is there a feature on Access to define an automated database object?

 

[Jay13]

I'm not asking anybody to work on my question for me, if I was I would have posted the data. I'm simply asking what something means.

 

[way2bord]

It sounds like they just want those values output.

ie.
set db = currentdb

for each item in db.tabledefs
output
iterate

for each info in db.tabledefs.fields
output.
iterate


The alternative is creating a class that mirrors an abbreviated tabledefs.


Something to that affect.

 

[rzw0wr]

Go to Database tools tab, Select Database Documenter and select the object you want to see documentation on.
Down at the bottom of the dialog box you can select options to further select what you want the documentation to show.