• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 77
  • Last Modified:

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.
  • 2
2 Solutions
John TsioumprisSoftware & Systems EngineerCommented:
I guess the starting point would be the tutorial from Microsoft
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:

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

Meet the Navigation Pane
by DemoTrainer (a Microsoft channel) on YouTube

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,
EirmanChief Operations ManagerAuthor Commented:
Many Thanks
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now