Home  |  Excel  | FrontPage Access Word | PowerPoint  | Outlook | Visio |  Project |  Publisher  |  InfoPath | Exchange  |  SharePoint Commerce  | Silverlight Database  | Data Warehouse  |  SQL  |  OO Design SQL_ServerMYSQL | PHP  | Oracle | VBA ASP.NET  | C programming | Java  |  Photoshop | HTMLDreamweaver | Web DesignExpression Web  | XML  | Java script  |  Security | UML | Flash Silverlight |UNIX | Networking 

Links

www.msoffice.us

dbmanagement.info

italiankitchenrecipes.com

relationshipadvices.info

www.coptics.info

 


MsOffice.US
Home
Excel
FrontPage
Access
Word
PowerPoint
Outlook
Visio
Project
Publisher
InfoPath
Exchange
SharePoint
Commerce
Expression
Silverlight
Management
Software
Windows

 

 

 

 

   

 

 

Home Access Topics

MS Access 2007 part10 Access Switchboards

        Switchboards are the screens used to navigate around a database and perform tasks, such as running reports.

 

        A switchboard is made of buttons that you can click on. You can program these buttons to open forms, reports, queries, etc.

 

        This form is basically a customised menu that contains user-defined commands; using either buttons, labels, images or hyperlinks, that invoke actions that will automatically carry out tasks for you such as opening other forms, running queries or printing reports.

 

        You can create a switchboard form using various manual methods or by using the Microsoft Access Switchboard Manager. The form can use either VBA procedures, stored in modules behind the form or hyperlinks that either doesnít contain any associated code, or that can invoke functions from standalone code modules.

 

        Using a switchboard form in your Microsoft Access database application allows you to tie together all of the other objects that you have created for your database users in a single form, and removes the need for the users to have to openly navigate from within the database window. You can also use this as the interface for your application, removing the chances of your users tampering with any of the objects that lie behind the scene of your application.

 

        Using buttons on your switchboard form can also replace the many possible steps that it would take the user to navigate around the objects in the database. To simply open a form in the database, the user may need to switch to the database window, choose the Forms tab and open the form from there. Using a command on the switchboard interface, the user now only has to click one button to carry out the same action.

 

        The Switchboard Manager is used to create, delete, add, or edit switchboards.

 

        Open Access.

        Open the sample file called My Database.

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button.



 

        The first time you will click on the Switchboard Manager button it will prompt a message box to create a new Switchboard.



 

        Click on the Yes button.  It will open the Switchboard Manager dialog box and create a new Switchboard called Main Switchboard.



 

        Click on the Close button to close the Switchboard Manager dialog box.

        You can see the switchboard in the left panel along with other tables, queries, and reports.

 

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button. It will open the Switchboard Manager dialog box.

 

        In the Switchboard Pages list you can see all the existing switchboards.  Click on the New button which will open the Create New dialog box.

 

        Enter a name for the new switchboard, i.e. enter Temp Switchboard and click on the OK button. 



It will add the created switchboard to the Switchboard Pages list.



 

        Click on the Close button on the Switchboard Manager dialog box to close it.

 

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button.  It will open the Switchboard Manager dialog box.

 

        In the Switchboard Pages list you can see all the existing switchboards.  Select a switchboard by clicking on it, i.e. select Temp Switchboard.



 

        Click on the Delete button.  A message box will appear to confirm the deletion.



 

        Click on the Yes button. It will delete the selected Switchboard. Click on the Close button in the Switchboard Manager dialog box to close it.

 

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button.  It will open the Switchboard Manager dialog box.

        Click on the Edit button.



 

        It will open the Edit Switchboard Page dialog box.



 

        Click on the New button which will open the Edit Switchboard Item dialog box.



 

        In the Text field enter a title for the item. We are going to create a button to open FrmStudents, therefore enter the text Students Form.

 

        In the Command field drop down list select Open Form in Add Mode.



 

        In the Form field select the form to be opened, i.e. select FrmStudents from the drop down list.



 

        Click on the OK button.  This will add an item Students Form to the switchboard items.



 

        Letís add report RptStudents to the switchboard.

 

        Click on the New button.  It will open the Edit Switchboard Item dialog box.



 

        In the Text field enter a title for the item. Now we are going to create a button to open RptStudents, therefore enter the text Students Report.

 

        In the Command field drop down list select Open Report.



 

        In the Report field select the report to be opened, i.e. select RptStudents from the drop down list.



 

        Click on the OK button.  This will add the item Students Report to the switchboard items.




 

 

        Click on the Close button to close the Edit Switchboard Page dialog box.

 

        Click on the Close button in the Switchboard Manager dialog box to close it.

 

        You will notice that in the left panel under Switchboard items it has created a table called Switchboard Items which stores the items for the switchboard, and a switchboard form named Switchboard.



 

        Double click on Switchboard in the All Tables list.  It will open the Switchboard form.



 

        If you click on the Students Form button on the Switchboard then it will open FrmStudents.



 

        Click on the first tab (called Switchboard) so that you can see the switchboard again, and click on the Students Report button which will open RptStudents.

 

        Close all the forms, reports and the Switchboard.

 

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button.

        It will open the Switchboard Manager dialog box.

        In the Switchboard Pages list you can see all the existing switchboards.

        Select a switchboard by clicking on it and click on the Edit button.

        This will open the Edit Switchboard Page dialog box.



NOTE: As you can see you could edit the switchboard by adding, deleting, moving up, moving down etc.

In this example, select Students Report and click on the Move Up button.

 

        Click on the Close button to close the Edit Switchboard Page dialog box.

 

        Click on the Close button in the Switchboard Manager dialog box to close it.

 

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button. It will open the Switchboard Manager dialog box.

 

        Select your switchboard and click on the Edit button. It will open the Edit Switchboard Page dialog box.

 

        You can select an item from the switchboard items list by clicking on it and then clicking on the Delete button.  In this case delete Students Report.




 

        You will see a warning dialog box.  Click on the Yes button.




 

        Click on the Close button to close the Edit Switchboard Page dialog box.

 

        Click on the Close button in the Switchboard Manager dialog box to close it.

 

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button.  It will open the Switchboard Manager dialog box.

 

        Select your switchboard and click on the Edit button.  It will open the Edit Switchboard Page dialog box.

 

        You can select an item from the switchboard items list by clicking on it and then click on the Edit button.

 

        It will open the Edit Switchboard Item dialog box.



 

        In this case we will simply change the Text to My Student Form, as illustrated below.



 

        Click on the OK button and then click on the Close button to close the Edit Switchboard Page dialog box.

 

        Click on the Close button in the Switchboard Manager dialog box to close it.

 

        If you have more than one switchboard, then you can make anyone of them as a default switchboard.

        Click on the Database Tools tab, and within the Database Tools group click on the Switchboard Manager button.

        In the Switchboard Pages list you can see all the existing switchboards.

        Select a switchboard by clicking on it and click on the Make Default button.



NOTE: It will make the Switchboard the default switchboard.   In this example we only have one Switchboard, but this illustrates the principle.

 

        Click on the Close button in the Switchboard Manager dialog box to close it.

 

        As this switchboard is a navigational page and provide links to all the forms and reports in your database, so you might like to display the switchboard as soon as you open your database.

 

        Click on the Office button and in the drop down window click on the Access Options.



 

        This will open the Access Options dialog box.  Click on the Current Database from the left panel and in the Display Form drop down list in the right window select your switchboard, i.e. select Switchboard.



 

        Click on the OK button on the bottom.  A message box will appear to inform that your changes will take effect when you close and open the database again.



 

        Click on the OK button.

        Close the database.

 

        Open Access 2007 and reopen the My Database sample file. You will see that the Switchboard is automatically displayed when the database opens.

 

        Close Access.

 

 

 


 

List of our Access topics 

(Access 2000) An Introduction to MS Access
(Access 2000) Introduction to Ms Access
(Access 2000) Using MS-Access 2000 & Oracle 9i
(Access 2003) Adding Special Controls to Forms
(Access 2003) Adding Special Controls to Forms
(Access 2003) Creating a New Database
(Access 2003) Creating MySQL database
(Access 2003) Creating a Simple Form
(Access 2003) Creating a Simple Query
(Access 2003) Creating a Simple Report
(Access 2003) Creating a Table with the Table Wizard
(Access 2003) Creating Queries from Scratch
(Access 2003) Creating Relationships between Tables
(Access 2003) Creating the MySQL database
(Access 2003) Customizing a Report
(Access 2003) Data Base and Structured Query Language (SQL)
(Access 2003) Database design
(Access 2003) Editing a Table's Structure
(Access 2003) Entering Data into a Table
(Access 2003) Finding answers to questions
(Access 2003) Formatting Access Tables
(Access 2003) Getting Started
(Access 2003) Guide to Relational Databases
(Access 2003) Identifying tables
(Access 2003) Introduction to data modeling
(Access 2003) Introduction to the SQL language
(Access 2003) Making it easy for the user
(Access 2003) MICROSOFT ACCESS 2003 TUTORIAL
(Access 2003) Modifying a Form
(Access 2003) Printing Access Objects
(Access 2003) Sales statistics
(Access 2003) Searching for Information in Your Database
(Access 2003) Specialized Joins
(Access 2003) SQL joining tables
(Access 2003) SQL Queries
(Access 2003) Taking Advantage of Database Relationships
(Access 2003) Transaction processing
(Access 2003) Tutorials
(Access 2003) Using reports
(Access 2003) Working with dates
(Access 2003) Working with Macros
(Access 2003) Working with the AutoForm Wizard
(Access 2003) Working with the data grid
(Access 2003) Basics of Access presentations ( .ppt)
(Access 2007) advanced_slides .ppt
(Access 2007) Beginning Topics
(Access 2007) Exercises 
(Access 2007) Exporting form to XML
(Access 2007) Getting Started
(Access 2007) Intermediate Topics
(Access 2007) New features and Product Guide
(Access 2007) Part1 Introduction
(Access 2007) Conditional formatting
(Access 2007) Part2 MS ACCESS Tables
(Access 2007) Part3 Relationships in ER Diagram
(Access 2007) Part4 Introduction to MS Access Forms and Reports
(Access 2007) Part5 Working with MS Access Forms
(Access 2007) Part6 Macros, Modules, Data Access Pages and Internet
(Access 2007) Part7 MS Access Queries and SQL
(Access 2007) Part8 Form Customization
(Access 2007) Part9 Working with Subreports
(Access 2007) Part10 Access Switchboards
(Access 2007) Part11 Access customisation options
(Access 2007) Quick Reference
(Access 2007) Report Conditional formatting
(Access 2007) Sample Database files
(Access 2007) Sorting, Filtering, and Indexing Data
(Access 2007) SQL commands to Create Database
(Access 2007) Step by Step
(Access 2007) Tips 
(Access 2007) Programming Access 2007 (Book)
(Access 2007) When to Migrate from Microsoft Access to Microsoft SQL Server
(Access 2007) Advanced Topics
(Access) SOFTWARE SUPPORTING Access
(Access 2007) Advanced topics (Book)
(Access 2010) The Access Object Model
(Access 2010) Tips and Tricks
(Access 2010) Introduction
(Access 2010) New Features
(Access 2010) Upgrading and Converting
(Access 2010) Macros
(Access 2010) VBA Editor
(Access 2010) Naming Conventions
(Access 2010) Security Features
(Access 2010) Extending VBA with APIs
(Access 2010) Creating Classes in VBA
(Access 2010) Working with SharePoint
(Access 2010) Using SQL with VBA
(Access 2010) Using VBA to Enhance Forms.pdf
(Access 2010) Using ADO to Access Data
(Access 2010) Using DAO to Access Data
(Access 2010) Working with the Windows Registry
(Access 2010) Reports with VBA
(Access 2010) Customizing the Office Backstage
(Access 2010) Working with .NET
(Access 2010) Building Client-Server Applications with Access
(Access 2010) Access Runtime Deployment
(Access 2010) Database Security
(Access 2010) VBA Basics
(Access 2010) Designing Advanced Forms
(Access 2010) Designing Advanced Reports
(Access 2010) Programming Microsoft Access
(Access 2010) Access as an Enterprise Platform
(Access 2010) Ms Access SQL Bible
(Access 2010) Create Data Access Pages
(Access 2010) Essential Query Tricks
(Access 2010) Importing and ExportingData.pdf
(Access 2010) Linking Tables with Relationships
(Access 2010) Database concepts presentations (.ppt)
(Access 2010) Working with Controls and Access Objects
(Access 2010) Database Management class presentations ( .ppt)
(Access 2010) Advances Database course presentations ( .ppt)
(Access 2010) Modern Database Management presentations ( .ppt)
(Access 2010) Reserved Words and Special Characters
(Access 2010) Understanding Form Controls

 

Welcome to

MsOffice.us

This is a free website for learning and practicing all the basics of Microsoft Office 2010 training courses, online help, lessons and more...

Links

www.msoffice.us

dbmanagement.info

italiankitchenrecipes.com

relationshipadvices.info

www.coptics.info

  Excel  | FrontPage Access Word | PowerPoint  | Outlook | Visio |  Project |  Publisher  |  InfoPath | Exchange  |  SharePoint Commerce  | Silverlight Database  | Data Warehouse  |  SQL  |  OO Design SQL_ServerMYSQL | PHP  | Oracle | VBA ASP.NET  | C programming | Java  |  Photoshop | HTMLDreamweaver | Web DesignExpression Web  | XML  | Java script  |  Security | UML | Flash Silverlight |UNIX | Networking 

 

 

  Home  Excel  | FrontPage Access Word | PowerPoint  | Outlook | Visio |  Project |  Publisher  |  InfoPath | Exchange  |  SharePoint Commerce  | Silverlight Database  | Data Warehouse  |  SQL  |  OO Design SQL_ServerMYSQL | PHP  | Oracle | VBA ASP.NET  | C programming | Java  |  Photoshop | HTMLDreamweaver | Web DesignExpression Web  | XML  | Java script  |  Security | UML | Flash Silverlight |UNIX | Networking 

  Home  |  Excel  | FrontPage Access Word | PowerPoint  | Outlook | Visio |  Project |  Publisher  |  InfoPath | Exchange  |  SharePoint Commerce  | Silverlight Database  | Data Warehouse  |  SQL  |  OO Design SQL_ServerMYSQL | PHP  | Oracle | VBA ASP.NET  | C programming | Java  |  Photoshop | HTMLDreamweaver | Web DesignExpression Web  | XML  | Java script  |  Security | UML | Flash Silverlight |UNIX | Networking