Create a Switchboard in Access 2007

this video shows you how to create a switchboard in Access 2007 a sushi Ford is a form that allows you to navigate around your Access database it is made out of buttons that you can click we can program these buttons to open forms reports queries and etc if you go back to database it's going to look like this you can create a main switchboard when you create a search board it'll it allows only 8 buttons so if you have more than 8 forms or more than 8 queries you cannot add all the forms in the chorus into one single switchboard so it's better for you to create a different switchboard for four forms a different switchboard for reports and then you can add them separately and combine that switchboard into the main switchboard so when you click on this button it shows you the reports so you can go back if you click on reports it showed all the reports so if you go back and this one closes the buttons so if you click on this one if you're going to cause the cause form will open for you now let's see how to create this one in Access before you create your switchboard you must can finish creating your tables forms queries and reports then you need to click database tools switchboard manager and a message comes us asking that do you want to create a new switchboard manager and you had to click on years right and the switchboard manager will open for you now this is your main switchboard the default one so I'm going to leave that one and I'm going to create a new switchboard manager for the form a new search what manages the report so I'm gonna says new write this switchboards gonna be forms right and then I'm going to add another new one and this one's gonna be my reports so I need to click on the forms switchboard and click on edit right so I need to add all forms to this phone switchboard so I can go to nil and from the text the first form I'm going to add is my student right from the command I need to select open form in edit mode and then I need to click on these forms so all the forms that I have been created as shown here so since this is my student form I need to pick student and say okay so I already had my stream form now I'm going to add my course form so I have to go to new again and I had to rename this text as course and I says open form in edit mode and then I need to add course so likewise you can add all your forms and also you need to add a button in order to go back to the main switchboard from your forms switch hold so in order to do that I need to click new again right and I have to say [Music] back to Maine right and here I have to select go to switchboard and then from the switchboard I had to select main switchboard and say ok so I have to close this one now now I'm good at reports as well so I need to select the reports and I have to say edit and I had to click new suppose I have a report call cost report right so I'm gonna say it's cause report right and from here from the command I have to select open report now from the report I'm gonna select course and say ok and then I'm going to click new again so I'm this time we're going to add student report right and then open report and you say student right and then I can add [Music] normally I you know that you can convert your quarry into the report so once you convert your current report you can add that report in here as well sources student on course so there's a report called student on course right so from here I'm going to select open a report and then student on cost report and says ok right and from this switchboard as well they had to go back to the main one so I'm going to click new and says back to me from here I had to select go to switchboard and I had to pick the main switchboard and then say okay right and then I had to close this one as well now I have to go back to the main switchboard right and what I have to do is I have to add these two switchboards into the main switchboard so I have to click main switchboard go to edit right I can rename this one right you can say student switchboard right so I'm going to go to new right and we says forms in here right go to switchboard and then I had to picked phone so I'm going to add my phone's and then I had to go to new I need to add my report switchboard now so I had says go to switchboard and I had to pick reports from here and say okay right and the last thing I had to do is I have to add a close button to the switchboard so that means it's closest whole database for you so you go to new again this time I'm going to name my button is closed and simply I can say exit application right if you creating a macro and you can create a macro first in order to close the database and then select run macro and and your macro or else you can simply say exit application and say it's okay close and you had to close this one as well so what you have to do is once you create the switchboard you had to go to forms on forms you can see your switchboard so you double click on the switchboard it will open the switchboard like this so you can see your phone switchboard your reports which would and the close button so if I click on forms I can see that two forms are added already so I can click on the student form a student form will open for me so then if I were to go back to my main switchboard I can click on back to me and then I can go to reports so if I want to open the report the cost report will open for me see and I can close it right so back to me and then I need to click on close so the whole database will close

Channel: Shalini F

Views: 67,731

Rating: 4.7677422 out of 5

Keywords: Microsoft Access, switchboard 2007

Id: nSrTCsu5iY0

Length: 9min 38sec (578 seconds)

Published: Tue Jan 31 2012