This is awkward for just a few forms or reports! For real-life work I would have put all of them on the main switchboard. Opens other switchboard pages, which have command buttons that open the most often used forms/reports. (An alternate approach is to create a custom group for the Navigation Pane.) Switchboard Very useful when users are just going to use theĭatabase and not create new tables or forms or reports. In fact,Ī commercial database often opens with just a switchboard in view. A switchboard form or a navigation form (Access 2010, 2013, 2016) may be just what you need. The tools available on the Arrange tab are especially helpful for arranging controls with a precise look, for example, evenly spacing controls.Jan's Working with Databases Forms & Reports: Special Types:Īnd reports, it would be very useful to have a way to quickly get to just the ones Use the features in the Controls group on the Design tab to add images, text boxes, draw lines, etc.ī. You are now able to format and customize the switchboard to meet your needs. Open the switchboard from the Navigation Pane.ģ. When the database is opened, this is what users will see:Ĭustomizing the Look of the Switchboard Switchboards are actually forms, and as such, we can use form design tools to customize the look. From the Current Database tab on the left, select Switchboard from the Display Form dropdown list. The Switchboard Manager automatically creates a Switchboard Items table.ĭisplay the Switchboard upon Start To make the switchboard automatically appear each time the database is opened, 1. Click Close to close the Switchboard Manager.ħ. Note that you can also re-arrange buttons on this screen by using the Move Up and Move Down buttons.Ħ. Repeat these steps for each item on the switchboard. Note that there are several built-in commands for common tasks.ĥ. Customize the item by entering the name of the button, selecting the appropriate command, and then selecting the desired outcome of the command. Click the New button to add items to the switchboard.Ĥ. Multiple switchboards can be created, and then linked together through buttons, thus creating a system of layered menus.ģ. Click Edit to make changes to the main switchboard. Note: If you cannot find the Switchboard Manager icon, under the Home tab, choose Options, and customize your ribbon by adding Switchboard Manager.Ģ. From the Database Tools tab, click Switchboard Manager. The Switchboard Manager also makes it easy to add new buttons, rearrange buttons, and delete buttons. However, Access provides a Switchboard Manager which automatically builds the code to make buttons work. Enter a name for the macro and click OK.Ĭreating a Switchboard A switchboard can be created by scratch using an unbound form. When finished, under the File tab, click the Save button.Ī. Keep in mind that when you run the macro, Access carries out the actions in the order in which you list them. To add more actions to the macro, repeat step 3. Optionally, type a comment for the action by selecting Comment under Program Flow.Ĥ. For example, let’s create a macro that automatically opens the Top Ten Orders by Sales Amount query. After selecting an action, users must specify arguments for the action, if any are required. Type the desired action or click the arrow to select from the list of available actions.Ĭ. On the Create tab, in the Macros & Code group, click Macro.ģ. These macros will then be tied to buttons on the switchboard. Macros can be created to initiate additional actions. The buttons initiate actions, like opening a form or printing a report.Ĭreating Macros for the Switchboard The switchboard manager includes built-in commands for common tasks, such as opening a form or report. Fundamentally, a switchboard is a form that contains customized command buttons. By providing users with an easy-to-use interface, there may not be a need for them to browse through the database objects where they may inadvertently tamper with the data. Switchboards are also used as a way to protect database objects. It allows us to tie database objects (tables, queries, forms, reports, and macros) together with a user-friendly interface, thus providing database users with a personalized interface rather than the Access interface. Overview of Switchboards A switchboard is basically a menu, which provides database users with a starting place. A switchboard provides database users with a customized way to interact with the database. Personalizing your Access Database with a Switchboard This document provides basic techniques for creating a switchboard in Microsoft Access.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |