How to Create a Switchboard (or Splash) Screen in Access 2010 by Shane Zentz

When creating a database application in Access 2010, you will sometimes come accross a situation where you will want to present several options to the end-user to choose from. For example you may have one form for data entry and one report, or you may have several forms and reports. This is where the idea of the ‘switchboard’ or ‘splash screen’ comes in. This handy switchboard can be used to present several choices for the end user to choose from. So this is what this tutorial is all about. And this is only the first part. In this part we will create the switchboard or splash screen (which will display as a pop up window when the user opens the database file), but in the next part of this we will fill the switchboard with photos and clickable (usable) buttons which will open forms and reports. So open up Access 2010 and get ready to create a switchboard!

The first step is simple. Just create a new form in design view. Resize the area to your liking and then click on the ‘other’ tab in the form’s properties. Change where it says ‘pop up’ from no to yes. Now switch to the format tab of the form’s properties. On this tab you will want to change ‘record selectors’ and ‘navagation buttons’ to NO and also set ‘control box’ and ‘close button’ to NO, and finally set min and max buttons to ‘NONE’. Now save your form and switch to display view. You should just see an empty window with no record selectors and no min,max,or close buttons, just like this:

OK, if you have something that looks like that then you are on your way. So close this switchboard out (right click somewhere in the popup window and select close). Now lets make this switchboard open automatically when this database is opened. To do that just go to the File tab and from there select the options tab towards the bottom, which will open up the database’s properties window, like this:

On the “current database” tab, you can set the title for the switchboard and even select an icon for the database itself. Just below those options is the one that will open the form when the database is opened. It says “Display Form” and you can select any form that you created in your database. The form that you select will open automatically when the database is opened. So choose the form that you just created, pick a title for it, then save these settings.

 

Close the database and reopen it. And when you do you should see the (blank) switchboard that we created earlier.

Not much here, just an empty window, but you can add whatever title you want and whatever graphics or photos to the background, and of course buttons to open forms or data entry. So this is just the starting point. Check the Switchboard’s properties add photos and other funcionalities to it.

Just be aware that you can even set this switchboard to open after a certain interval (or close after a certain interval) with some of the forms properties. But that is a little beyond this tutorial, but if you are interested in this just google it man.

O.k., next we will add some real functionability to this switchboard and even decorate it a little to make it look even nicer. So check back for part two of this tutorial.
Thanks for reading this blog!

Shane

881 thoughts on “How to Create a Switchboard (or Splash) Screen in Access 2010 by Shane Zentz”

  1. There has been a financial state which can be fairly powerful so you may not want to consider the interest they charge. If you ever find yourself in need of cash, whether it’s to pay prior to determining whether to advance you the money for all purposes As the housing loan installments. Not only with their money on just your signature saying you’ll repay the bank the various terms and repayment schedules.

  2. Aw, this was an extremely nice post. Spending some time and actual effort to generate a superb article… but what can I say… I procrastinate a whole lot and never manage to get anything done.

  3. Greetings from Ohio! I’m bored at work so I decided to check out your website on my iphone during lunch break. I really like the information you provide here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyways, amazing site!

  4. Play filmmakers, Celebrity Charades Amityville Horror.

    When they arrived at my home my mother said come in, is yet to be completed.
    Remember to get awesome free samples kids printable birthday invitations and wording to
    help get the hype going for the party.

  5. Hі, Ι think youг wеbsіtе might be having browѕеr сomρаtibility issueѕ.
    Whеn І loοκ аt youг blog in Firеfox, it lookѕ fine but whеn oρenіng іn Inteгnеt Exploгег, іt has some ovеrlаррing.

    I just ωаntеd tο givе yοu а quick hеaԁѕ uр!
    Othег thеn thаt, suρerb blog!

  6. excellent publish, very informative. I wonder why the opposite experts of this sector don’t notice this. You should continue your writing. I am sure, you have a huge readers’ base already!

  7. Hеy thеrе! Ѕomeоne in my Myspace gгouρ shared this website wіth us so I
    cаme to look it over. I’m definitely loving the information. I’m book-marking and will
    be tωeetіng this to mу fоllοwегѕ!
    Excellent blοg аnd outstаnԁing design anԁ style.

  8. The reason you have good credit.If you are acquiring an asset you will agree to lend more than 65. If you provide all of these types of transactions are generally to considered a commercial loan transaction. Any business or general lending association The payday loan would require. Such a lender can be your best friend.

  9. Hello there, I found your website by means of Google while searching for a comparable matter, your site came up, it appears good. I have bookmarked it in my google bookmarks.

  10. I do not know whether it’s just me or if perhaps everybody else experiencing problems with your blog. It seems like some of the written text in your posts are running off the screen. Can somebody else please comment and let me know if this is happening to them as well? This might be a problem with my web browser because I’ve had this happen before. Many thanks

  11. Have you ever thought about publishing an e-book or guest authoring on other sites? I have a blog based on the same information you discuss and would love to have you share some stories/information. I know my subscribers would appreciate your work. If you are even remotely interested, feel free to shoot me an e mail.

  12. It is appropriate time to make some plans for the future and it is time to be happy. I have read this post and if I could I want to suggest you some interesting things or suggestions. Maybe you can write next articles referring to this article. I desire to read more things about it!

  13. Wow! This blog looks just like my old one! It’s on a completely different topic but it has pretty much the same layout and design. Excellent choice of colors!

  14. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your webpage? My blog site is in the exact same area of interest as yours and my visitors would definitely benefit from a lot of the information you provide here. Please let me know if this alright with you. Appreciate it!

  15. I’ve been exploring for a little for any high-quality articles or weblog posts in this kind of area . Exploring in Yahoo I ultimately stumbled upon this website. Reading this information So i am satisfied to show that I’ve an incredibly just right uncanny feeling I came upon just what I needed. I such a lot undoubtedly will make certain to don?t forget this web site and provides it a look regularly.

  16. Its such as you read my mind! You seem to grasp so much approximately this, like you wrote the book in it or something. I believe that you could do with a few p.c. to power the message home a bit, however other than that, this is magnificent blog. A fantastic read. I will definitely be back.

  17. Although the convenience of email cannot be denied, the act of receiving and reading a snailmail letter is by far the better experience. So kudos to you!
    I understand that the letters are not personalized, but are they physically signed by the sender? That would be such a nice touch and one particular for which I’d gladly pay more. Perhaps the sender could sign a small percentage, so that a randomly chosen few each and every week would have a little extra thrill. That possibility would absolutely make my heart race a bit faster as I tore open the envelope!

  18. I like what you guys are up also. Such intelligent work and reporting! Carry on the superb works guys I have incorporated you guys to my blogroll. I think it will improve the value of my web site :).

  19. I’m not sure why but this web site is loading very slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later on and see if the problem still exists.

  20. Hi! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My weblog looks weird when browsing from my iphone4. I’m trying to find a theme or plugin that might be able to fix this issue. If you have any recommendations, please share. Thank you!

  21. Good day! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Kudos!

  22. Today, while I was at work, my sister stole my apple ipad and tested to see if it can survive a thirty foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is completely off topic but I had to share it with someone!

  23. The new Zune browser is surprisingly good, but not as good as the iPod’s. It works well, but isn’t as fast as Safari, and has a clunkier interface. If you occasionally plan on using the web browser that’s not an issue, but if you’re planning to browse the web alot from your PMP then the iPod’s larger screen and better browser may be important.

  24. Great post however I was wondering if you could write a litte more on this topic? I’d be very grateful if you could elaborate a little bit further. Appreciate it!

  25. Whoa! This blog looks just like my old one! It’s on a entirely different subject but it has pretty much the same layout and design. Excellent choice of colors!

  26. H&M clothing has awed a lot easier for you and how do you have found out that out of luck? There are many stores that offer you coupon codes that you are taken to a Wi-Fi network with your logo, and delivery slip intact. They include: 1st Online Store to Offer Full-Landed Price in Local Currency Tarazz.coms patented technology allows its users to shop or bank online, but instead security concerns are the ultimate convenience. {||||

  27. Thanks for this article. I’d also like to talk about the fact that it can be hard while you are in school and starting out to initiate a long credit ranking. There are many college students who are merely trying to make it through and have a protracted or beneficial credit history can often be a difficult point to have.

  28. Some truly nice and useful information on this site, also I believe the style and design has got good features.

  29. I bear in mind putting dumps alongside one another once i worked for your chain store, several years in the past. When one among the “new” Star Wars movies came out, there was a display based on those robot-things that roll up and roll away, then pop open to attack. Wicked complicated and a million paper cuts!

  30. I needed to write you the little bit of word so as to thank you very much again for the breathtaking knowledge you’ve contributed on this page. It is quite pretty generous of people like you to allow openly exactly what some people might have offered for an electronic book to earn some profit for themselves, precisely given that you could have tried it if you wanted. Those tips as well served like a good way to fully grasp that many people have the identical zeal similar to my personal own to grasp way more in terms of this issue. I believe there are several more enjoyable periods ahead for people who scan your site.

  31. Valuable info. Fortunate me I discovered your web site accidentally, and I am shocked why this twist of fate did not took place in advance! I bookmarked it.

  32. Hey! Would you mind if I share your blog with my myspace group? There’s a lot of people that I think would really enjoy your content. Please let me know. Many thanks

  33. You have to waste less time to seek out your necessary topic on web, because nowadays the searching strategies of search engines are fastidious. That’s why I fount this paragraph at this place.

Comments are closed.