Question Can someone explain what this means? (1 Viewer)

Jay13 · May 23, 2013

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 · May 23, 2013

Is this a school project?
Who asked this?

Dale

Jay13 · May 23, 2013

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 · May 23, 2013

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 · May 23, 2013

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

Dale

Jay13 · May 23, 2013

rzw0wr said:
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 · May 23, 2013

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 · May 23, 2013

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

Jay13 · May 23, 2013

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 · May 24, 2013

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 · May 24, 2013

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.

Question Can someone explain what this means? (1 Viewer)

Jay13

New member

rzw0wr

I will always be a newbie

Jay13

New member

rzw0wr

I will always be a newbie

rzw0wr

I will always be a newbie

Jay13

New member

rzw0wr

I will always be a newbie

Jay13

New member

Jay13

New member

way2bord

Registered User.

rzw0wr

I will always be a newbie

Similar threads

Users who are viewing this thread