The training I've seen for making a switchboard seems to be limited to adding forms or reports, but I am interested in adding queries. Do I just make the switchboard as if it were to be composed of forms, but then link to the queries instead?
Additionally my queries, as currently configured, prompt for a date range (start and end) and then depending on the purpose, will also ask for entry of numerical codes or part numbers. The end users do not want to type in any data, but would rather have the switchboard initiate pop-up tables that show the numerical codes or part numbers, and then they would just click what they want.
Finally, I have configured pivot charts to express the results of the query visually. I have been manually moving from the datasheet view over to the pivot chart view by right mouse clicking on the query tab and choosing pivot chart. The end users want the results of the query to jump immediately into the pivot chart view without any additional input from them.