Access database designers creat a switchboard from that automatically displays w
ID: 3843937 • Letter: A
Question
Access database designers creat a switchboard from that automatically displays when the database is opened . Both serve the same function. Do you think one is easier to create and use than other? Who is it easier? The designer or the user of the system? Access database designers creat a switchboard from that automatically displays when the database is opened . Both serve the same function. Do you think one is easier to create and use than other? Who is it easier? The designer or the user of the system?Explanation / Answer
Switchboard form provides a click based interface that can help people to access specific datasets,
reports or other forms.
In a switchboard form we can have buttons which when clicked would take you to a desired location.
Using the Command box in a switchboard we can perform a desired activity.
Interestingly switchboards can have buttons to open another switchboard.
Access also allows to set a switchboard as default, which opens up every time the database is launched.
The advantage of this is -
- This feature is extremely handy when multiple users are working in a database and need directions.
It is extremely easy to create a switchboard in Ms Access and even after one has been created
you can edit by going into the Design view.
- Switchboards are more of a necessity when Microsoft Access is used to run a line of business
function. For example if Access is used for storing the sales support data, executives working
in sales support would have to be provided with a switchboard through which they can navigate
to relevant forms.
- On Switchboard, we can add more and more deeper menus. Add more reports and submenus. All these can
be done by not adding a button on the form, and also a new form need not be created for each submenu.
There is no need to write any code for each new report or form added to the switchboard.
However, the Ms Access application, while being simple to use, scores poorly on parameters
such as stability and robustness. An elaborate switchboard form created with great effort
vanishes during an Access crash along with other data.
With the above points, its clear that user has a great advantage in having the Switchboard.
To some extent designer's work in creating seperate forms is reduced by having submenus in Switchboard.
Again all these will lead to improved user experience.