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. A lot of thanks for all of your labor on this web site. Debby enjoys getting into research and it is simple to grasp why. My partner and i notice all relating to the powerful means you give important tips on this website and as well as encourage participation from visitors on this area of interest and our child is without a doubt being taught a whole lot. Enjoy the rest of the year. You have been doing a terrific job.

  2. Great site. Lots of helpful info here. I am sending it to a few pals ans additionally sharing in delicious. And certainly, thanks to your sweat!

  3. The Zune concentrates on being a Portable Media Player. Not a web browser. Not a game machine. Maybe in the future it’ll do even better in those areas, but for now it’s a fantastic way to organize and listen to your music and videos, and is without peer in that regard. The iPod’s strengths are its web browsing and apps. If those sound more compelling, perhaps it is your best choice.

  4. Hey! Do you use Twitter? I’d like to follow you if that would be ok. I’m definitely enjoying your blog and look forward to new posts.

  5. I’m really inspired together with your writing skills as neatly as with the format on your blog. Is that this a paid subject or did you modify it your self? Either way stay up the nice high quality writing, it is rare to see a great blog like this one these days..

  6. I have been surfing on-line more than 3 hours today, yet I by no means discovered any attention-grabbing article like yours. It is pretty price enough for me. In my opinion, if all webmasters and bloggers made just right content as you did, the web shall be a lot more helpful than ever before.

  7. Very good written story. It will be beneficial to everyone who employess it, including me. Keep doing what you are doing – for sure i will check out more posts.

  8. Between me and my husband we’ve owned more MP3 players over the years than I can count, including Sansas, iRivers, iPods (classic & touch), the Ibiza Rhapsody, etc. But, the last few years I’ve settled down to one line of players. Why? Because I was happy to discover how well-designed and fun to use the underappreciated (and widely mocked) Zunes are.

  9. Though, in 2008 the bubble collapsed and estate cost dropped by twenty six per percent on April 2009, United Kingdom commercial estate prices will start to rise back. This question is based on figures from Yahoo Search made on the policy declarations as the impact of slowing economic conditions witnessed during the course of construction and is nicely maintained.

  10. GreatThank you for some other informative site. The place else could I get that kind of info written in such a perfect approach? I have a challenge that I am simply now working on, and I have been on the glance out for such information.

  11. I do agree with all of the ideas you have presented in your post. They’re really convincing and will certainly work. Still, the posts are very short for novices. Could you please extend them a little from next time? Thanks for the post.

  12. Hey very cool site!! Guy .. Beautiful .. Superb .. I’ll bookmark your web site and take the feeds also?I’m satisfied to search out numerous helpful info here within the post, we’d like work out more strategies on this regard, thank you for sharing. . . . . .

  13. Howdy would you mind sharing which blog platform you’re working with? I’m looking to start my own blog in the near future but I’m having a tough time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something completely unique. P.S My apologies for being off-topic but I had to ask!

  14. The next time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I mean, I do know it was my option to learn, however I actually thought youd have one thing fascinating to say. All I hear is a bunch of whining about one thing that you would fix if you happen to werent too busy in search of attention.

  15. Hello my friend! I wish to say that this article is amazing, nice written and include almost all important infos. I would like to see more posts like this.

  16. Pingback: online casino
  17. hey there and thank you for your information – I’ve certainly picked up anything new from right here. I did however expertise some technical issues using this web site, as I experienced to reload the site many times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I am complaining, but slow loading instances times will often affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my email and can look out for much more of your respective intriguing content. Ensure that you update this again soon..

  18. I like the helpful info you provide in your articles. I will bookmark your blog and check again here frequently. I am quite sure I will learn plenty of new stuff right here! Good luck for the next!

  19. Zune and iPod: Most people compare the Zune to the Touch, but after seeing how slim and surprisingly small and light it is, I consider it to be a rather unique hybrid that combines qualities of both the Touch and the Nano. It’s very colorful and lovely OLED screen is slightly smaller than the touch screen, but the player itself feels quite a bit smaller and lighter. It weighs about 2/3 as much, and is noticeably smaller in width and height, while being just a hair thicker.

  20. Your style is so unique in comparison to other people I have read stuff from. I appreciate you for posting when you’ve got the opportunity, Guess I will just bookmark this site.

  21. This is the suitable blog for anyone who needs to find out about this topic. You realize a lot its virtually arduous to argue with you (not that I actually would need…HaHa). You positively put a new spin on a subject thats been written about for years. Great stuff, simply great!

  22. I like the valuable info you supply for your articles. I’ll bookmark your weblog and take a look at once more here regularly. I’m relatively certain I’ll learn many new stuff proper here! Best of luck for the following!

  23. May I simply just say what a comfort to uncover someone that genuinely understands what they are discussing on the web. You definitely understand how to bring an issue to light and make it important. More people need to check this out and understand this side of the story. I can’t believe you aren’t more popular because you definitely have the gift.

  24. Hands down, Apple’s app store wins by a mile. It’s a huge selection of all sorts of apps vs a rather sad selection of a handful for Zune. Microsoft has plans, especially in the realm of games, but I’m not sure I’d want to bet on the future if this aspect is important to you. The iPod is a much better choice in that case.

  25. Woah! I’m really loving the template/theme of this blog. It’s simple, yet effective. A lot of times it’s tough to get that “perfect balance” between usability and visual appearance. I must say you’ve done a excellent job with this. Additionally, the blog loads super fast for me on Chrome. Excellent Blog!

  26. A result of the immense size and strength that these animals
    can grow to means pets should be leash trained from a
    young age. You should teach your dog and talk to him during training sessions.
    With the Easy Walk Harness, if your dog attempts
    to pull forward the straps across the chest and shoulder blades begin to tighten.

  27. What’s up everyone, I be familiar with YouTube video carries less bytes of memory due to that its quality is awful, except this YouTube video has wonderful picture features.

  28. Link exchange is nothing else however it is just placing the other person’s website link on your page at suitable place and other person will also do same for you.

  29. In this article I will teach you the basics of how to have fun learning your chords by playing out of a Fake Book.
    — Notes: Bb D F. offers free online piano lessons.

  30. I’ve been surfing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.

  31. G# or Ab – (lower) so#, (middle) do, (middle) re#
    G#, C, D# keys. So you want to learn how to play the piano.

    offers free online piano lessons.

Comments are closed.