Suggestion - Directories/Folders

  • Thread starter Thread starter JohnG
  • Start date Start date
J

JohnG

It would be handy if one could create folders to organize my Tables / Queries
/ Forms / Reports. I often create a database and end up with 50 or more
queries. I have to resort to really long names to help me clarify what I am
doing. This is especially true if I need to create multiple sub queries to
end up with my final query. When this happens I end up with files like
Istat0, Istat0a, Istat1, Istat2, etc. all for my ultimate Istat query. It
would be handy if I could consolidate all these intermediate files into an
Istat related folder under queries.

While I am at it, it would also be handy to be able to have some sort of
properties visible and editable for each table/query/form/report. This way I
can include a short description of what the purpose of each object is. It
would also be handy to have some sort of change management associated with
it. So I can indicate what changes have been made, the date, who did it and
maybe a version number. Yes I could create a table and build this myself, but
that is rather ad hoc. A built in management system would standardize it and
make it more accessible.

One last thing. Have the option of getting rid of the ribbon and going back
to a toolbar. This goes for all the new Office products. It takes me a lot
longer to do most things with this new interface. I especially don't like the
'feature' which intelligently moves and rearranges tools. Once I find a tool,
or place it in a location, I want it to stay there. I also don't like the
amount of space the ribbon takes up.

Just some ideas.

John

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...b147b&dg=microsoft.public.access.externaldata
 
JohnG said:
It would be handy if one could create folders to organize my Tables /
Queries
/ Forms / Reports. I often create a database and end up with 50 or more
queries. I have to resort to really long names to help me clarify what I
am
doing. This is especially true if I need to create multiple sub queries to
end up with my final query. When this happens I end up with files like
Istat0, Istat0a, Istat1, Istat2, etc. all for my ultimate Istat query. It
would be handy if I could consolidate all these intermediate files into an
Istat related folder under queries.

You can create your own custom categories in the navigation pane and drag
and drop objects to add them - or at least, shortcuts to them - to your
custom groups.
While I am at it, it would also be handy to be able to have some sort of
properties visible and editable for each table/query/form/report. This way
I
can include a short description of what the purpose of each object is. It
would also be handy to have some sort of change management associated with
it. So I can indicate what changes have been made, the date, who did it
and
maybe a version number. Yes I could create a table and build this myself,
but
that is rather ad hoc. A built in management system would standardize it
and
make it more accessible.

Objects have a description property which you can edit by right-clicking the
object and choose Properties from the shortcut menu. To display the property
in the Navigation Pane, right-click the bar at the top of the Navigation
Pane, choose View By and then Details.
One last thing. Have the option of getting rid of the ribbon and going
back
to a toolbar. This goes for all the new Office products. It takes me a lot
longer to do most things with this new interface. I especially don't like
the
'feature' which intelligently moves and rearranges tools. Once I find a
tool,
or place it in a location, I want it to stay there. I also don't like the
amount of space the ribbon takes up.

Me too.

There's lots of good tips on the new UI at the following URL ...

http://accessjunkie.com/faq2007.aspx
 
Back
Top