Switchboard Forms in Microsoft Access: What is a Switchboard - A switchboard is essentially a Microsoft Access form that allows you to facilitate navigation or perform tasks within your database application. This form is basically a customised menu that contains user-defined commands; using either buttons, labels, images. Look at most relevant Access 2003 templates for free websites out of 147 Million at KeyOptimize.com. Access 2003 templates for. MS Access Switchboard The. Applies To: Access 2007 Providing switchboards in your application can help users to locate the necessary tasks. This article describes how to create and delete switchboards in Microsoft Office Access 2007, and shows how to add and modify the items in a switchboard. If you created a switchboard in an earlier version of Access, that switchboard will appear and run as usual in Access 2007, except for commands that are no longer available such as, displaying the Database window. Access 2007 provides a new feature known as the Navigation Pane that replaces the Database window. You can use the Navigation Pane instead of switchboards. For more information about how to use the Navigation Pane, see links in the See Also section. Tip: In Access 2010, you can create a 'navigation form' which provides an intuitive tabbed interface for switching between forms and reports. What do you want to do? Create a switchboard Before you create a switchboard, consider how you want users to locate the various forms and reports in the database and plan your navigation design accordingly. Should your needs change after you create a switchboard, you will be able to modify the design of your switchboard at any time. When you create a switchboard using the Switchboard Manager tool, Access creates a Switchboard Items table that describes what the buttons on the form display and what actions they perform. If you change your switchboard manually, the application may no longer work. Since the Switchboard Manager only allows a maximum of eight command buttons on a switchboard, you might need additional switchboards that the user can navigate to from the Main Switchboard. • On the Database Tools tab, in the Database Tools group, click Switchboard Manager. Microsoft Access asks if you'd like to create a switchboard, click Yes. This creates a Main Switchboard. You can either add all your switchboard commands to the Main Switchboard or create secondary switchboards. • To create secondary switchboards, click New. Note: If you create secondary switchboards, make sure that each switchboard has a command to go back to the Main Switchboard. The Create New dialog box appears. • Type the name of the new switchboard and click OK. Microsoft Access adds the switchboard to the list in the Switchboard Pages box. You can add secondary switchboard names at this point. • Repeat steps 2 through 3 for each secondary switchboard you want to create, and then click Close. Add items to a switchboard After you create your switchboard, you will have to add items or menu commands that perform various tasks such as opening forms and reports in the database. The items that you add to the switchboard appear as command buttons. • From the Switchboard Manager dialog box, select the switchboard, and then click Edit. The Edit Switchboard Page dialog box appears. The Edit Switchboard Item dialog box appears. • Type the name of your command item in the Text box, and select a suitable command from the Command list. For example, if the item is Customer Data, select Open Form In Add Mode. Note: To create a switchboard that branches to other switchboards, click the Go To Switchboard command in the Command box, and then either select a switchboard from the list or enter the name of the other switchboard. • Repeat steps 1 through 4 until you have added all the required commands to the switchboard. Command Action performed Go to Switchboard Opens a secondary switchboard. Open Form in Add Mode Opens a form in a mode that only allows new records to be added. Open form in Edit Mode Opens a form in a mode that allows any record to be added or edited. Open Report Opens a report in Print Preview. Design Application Opens the Switchboard Manager. Exit Application Closes the current database. Run Macro Runs a macro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |