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!


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

  1. This plan of yours is a plan of action, and that means
    you take action every single day. Keep on experimenting but
    learn form the past mistakes and do not try to implement those in the future plans.

    I recommend this online marketing formula to beginner’s.

  2. That is very fascinating, You’re an excessively skilled blogger. I’ve joined your feed and stay up for searching for more of your fantastic post. Additionally, I have shared your website in my social networks

  3. 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.

  4. A result of the immense size and strength that these animals
    can grow to means pets should be leash trained from a young age.
    Superdog has facilities in Sacramento, Los Angeles, San Francisco, Walnut Creek, Oakland, Napa, and Orange County.
    Dog obedience training is a bit more than trained responses.

  5. Thank you for all your hard work on this web site. Gloria takes pleasure in conducting investigation and it is easy to understand why. Many of us know all concerning the dynamic tactic you create invaluable information by means of the website and in addition welcome contribution from others on the subject matter then our simple princess has always been discovering a great deal. Have fun with the remaining portion of the year. Your doing a very good job.

  6. When you stop PPC, traffic dies immediately and your business
    is dead in the water. By using the autoresponder, you
    have been in front of a potential customer
    for five days. , to all your fans.

  7. If you’re on a budget have your guests light sparklers as you depart. (Here’s the key difference.
    An increasing number of marrying couples (particularly those entering second or later marriages) will request that
    guests refrain from giving gifts.

  8. Fantastic goods from you, man. I have take note your stuff prior to and you’re simply too magnificent. I really like what you’ve bought right here, certainly like what you’re stating and the way in which you assert it. You’re making it enjoyable and you continue to care for to keep it sensible. I cant wait to learn much more from you. That is really a terrific site.

  9. After research a number of of the weblog posts in your website now, and I really like your approach of blogging. I bookmarked it to my bookmark web site listing and shall be checking back soon. Pls check out my site as well and let me know what you think.

  10. hey there and thank you for your information – I’ve definitely picked up something new from right here. I did however expertise a few technical issues using this website, as I experienced to reload the website lots of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I’m complaining, but sluggish loading instances times will often affect your placement in google and can damage your quality score if ads and marketing with Adwords. Well I am adding this RSS to my e-mail and could look out for a lot more of your respective exciting content. Ensure that you update this again very soon..

  11. In relation to the last paragraph, the question had arisen by the people that how the
    diet can be eaten by us in the same form in which it was utilized by our ancestors.
    By meat I mean red meat, white meat and seafood. Grains, salt, processed oils, legumes, and any other food that is not
    available yet during the said era are not including in this special
    type of diet.

  12. You should never stop investigating, researching and analysing the market to be reactive and play the main role on your market.
    First a website has to be found, and such a task is often difficult when you
    consider the fact “each website is competing against millions of others for Top Placement in Search Engines. I recommend this online marketing formula to beginner’s.

  13. Hello there, just turned into alert to your blog through Google, and located that it’s really informative. I am gonna be careful for brussels. I’ll be grateful if you happen to proceed this in future. A lot of folks will likely be benefited out of your writing. Cheers!

  14. Narrow blood vessels lie alongside the intestines of the earthworm and they absorb
    the nutrients from the alimentary canal feeding the rest
    of the body. Local country clubs are offering trivia
    fun for as little as forty dollars per couple. Her father,
    Bruce Paltrow, produced the critically acclaimed
    TV series that is considered the precursor to many medical shows today, St.

  15. Good airman. I was checking constantly this journal and I am impressed! Enormously cooperative data specifically the conclusion strain I maintenance for precise communication a lot. I was hunting this exact subject matter used for a unsound instant. Thank you and intellectual phenomenon.

  16. It is particularly helpful as you fight off this yeast infection
    in mouth. This will ensure that you treat the right disease
    when you take the medication. If you apply Aloe Vera gel on the affected areas it can help reduce the
    itching and burning caused by the infection.

  17. You actually make it appear really easy together with your presentation but I find this topic to be actually something which I believe I might never understand. It kind of feels too complicated and extremely extensive for me. I’m having a look forward on your subsequent publish, I’ll attempt to get the hang of it!

Comments are closed.