I'm creating a new database. To be honest, I've never worked through the best approach to create a great user interface before. I'm looking for ideas on how to best approach it. What you've come to value for end-users when they first open the app, etc.
For sake of brevity, let's say I will end up with 4 main "topics" with several forms for specific needs under each topic. I started out with a navigation form with 4 main tabs, then secondary tabs under each parent, that each hold a form. I'm pausing on this approach until I see other options, because it just feels a bit clunky, and may have room for operator error. (This app will be used offsite, and needs to be EASY and SIMPLE for those users). Also, the navigation tabs seem to complicate the VBA code. I have essentially nested subforms now.
Does anyone know of or is willing to share some good examples of how they "tied" their application together with a good UI? I started from the back end and worked forwards. Now all the tables and most of the forms are done, and I'm looking for the best UI for this situation. Thank you for any insight.
For sake of brevity, let's say I will end up with 4 main "topics" with several forms for specific needs under each topic. I started out with a navigation form with 4 main tabs, then secondary tabs under each parent, that each hold a form. I'm pausing on this approach until I see other options, because it just feels a bit clunky, and may have room for operator error. (This app will be used offsite, and needs to be EASY and SIMPLE for those users). Also, the navigation tabs seem to complicate the VBA code. I have essentially nested subforms now.
Does anyone know of or is willing to share some good examples of how they "tied" their application together with a good UI? I started from the back end and worked forwards. Now all the tables and most of the forms are done, and I'm looking for the best UI for this situation. Thank you for any insight.