Guide To Customising MS Access Navigation Bar

Using Access 2013 - I'm having difficulties organising scores of queries into custom groups.
I can't seem to show the custom groups and other object groups simultaneously.
(This happened when I created a 2nd Custom Group)

When I drag queries into a custom groups they don't move - they are only copied!
Unassigned objects and the apparant duplication of objects don't make sense - should I hide them?
Does cut/copy work - It's all very confusing and just not intuitive.

I will have over a hundred queries when I am finished, so I really this form of grouping.

I'm looking for a few hints
and link(s) to a GOOD Guide(s) to customising the MS Access Navigation Bar + Navigation Options.
LVL 24
EirmanChief Operations ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
I guess the starting point would be the tutorial from Microsoft
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi,

this is a good 7-minute video to overview the Navigation Pane:

Meet the Navigation Pane
by DemoTrainer (a Microsoft channel) on YouTube
http://www.youtube.com/watch?v=7GRii_sTa6M

At 4:15, custom categories and groups are discussed.  This has SHORTCUTS -- not the actual objects themselves, except Unassigned

Unassigned objects are those that don't show up in any other category. It is confusing that this lists the actual objects themselves, not shortcuts!  So if you delete them here, you are deleting an object, not a shortcut.

The video does not mention, but I want to point out, that if you import objects instead of creating them, their relations to other objects will not come in, and objects will not be associated to tables even though they should be.

~~~
for me, a better way of categorizing so I can find objects faster is to give consideration to how I might want to find them later, and name them well. Then use Search box (Ctrl-F for Find) at the top of the Navigation Pane to filter for what I want.  I use short abbreviations for each "category" such as 'bom' anywhere in the name means it relates to the bill of materials, "cust" for customer, "inv" for invoice, "pho" for phone numbers, etc. To group objects for sorting, I use "c_" to start tablenames with contact information, and then for objects with contact information, "c_" is somewhere in them like "qc_CustomerPhoneNumbers" or "fc_blahblahblah" ... etc -- my abbreviations are consistent within an application, but I may use different ones for another.

I show the Navigation Pane by Object Type ... which doesn't show custom categories since I like to see what is really there, and just one time.

For users, I create a Main Menu form, and maybe other forms, or tab pages, depending on how big the app is, for navigation.

have an awesome day,
crystal
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EirmanChief Operations ManagerAuthor Commented:
Many Thanks
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.