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. Thank you for any other informative website. Where else may just I get that type of information written in such an ideal manner? I have a venture that I am just now running on, and I have been on the look out for such information.

  2. I like the valuable information you supply to your articles. I will bookmark your weblog and test once more here frequently. I’m relatively certain I will be told a lot of new stuff right right here! Good luck for the next!

  3. Jack and Max early reader picture books are great as read alouds and for beginning readers. Your children will get to know their new friends Jack and Max and build reading skills through fun rhyme and repetition as they explore the world around them. Come along and join the adventure!

  4. Simply wish to say your article is as astounding. The clarity to your submit is simply cool and that i could assume you’re knowledgeable in this subject. Fine with your permission let me to seize your RSS feed to stay updated with imminent post. Thank you one million and please continue the enjoyable work.

  5. Wonderful goods from you, man. I’ve be aware your stuff prior to and you are simply extremely excellent. I actually like what you’ve got here, really like what you’re stating and the best way through which you assert it. You’re making it enjoyable and you continue to care for to stay it smart. I can’t wait to read much more from you. That is really a terrific website.

  6. I have been exploring for a bit for any high quality articles or blog posts in this kind of space . Exploring in Yahoo I finally stumbled upon this website. Reading this information So i’m happy to show that I have a very good uncanny feeling I found out exactly what I needed. I so much undoubtedly will make certain to don?t forget this site and give it a look on a continuing basis.

  7. Hey There. I discovered your blog the usage of msn. This is an extremely well written article. I’ll be sure to bookmark it and return to read more of your helpful info. Thanks for the post. I will definitely return.

  8. Amazing issues here. I’m very glad to peer your article. Thanks so much and I am looking ahead to touch you. Will you kindly drop me a e-mail?

  9. My spouse and I stumbled over here different page and thought I might check things out.
    I like what I see so now i’m following you. Look forward to looking over your web page yet again.

  10. The subsequent time I learn a weblog, I hope that it doesnt disappoint me as very much as this a single. I imply, I do know it had been my option to read, but I truly imagined youd have a single point fascinating to say. All I hear can be a bunch of whining about some thing that you can maybe fix should you come about to werent as well active browsing for consideration.

  11. muy buenos dias acabo de enterarme de tu web y la verdad es que me parece genial no sabia de mas personas interesadas en estos temas, aqui tienes un nuevo lector que seguira visitandote mensualmente.

  12. Hi there, I do think your site might be having web browser compatibility issues. Whenever I take a look at your site in Safari, it looks fine but when opening in I.E., it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Apart from that, great site!

  13. Have you ever thought about adding a little bit more than just your
    articles? I mean, what you say is important and all. However just
    imagine if you added some great visuals or video clips to give your posts more, “pop”!
    Your content is excellent but with pics and videos, this site
    could certainly be one of the most beneficial in its niche.
    Very good blog!

  14. Great do the job! This is the sort of info that ought to be shared around the website. Shame on Yahoo for not positioning this publish bigger! Come on around and take a look at my web page . Thanks =)

  15. F*ckin’ amazing things here. I am very glad to see your article. Thanks a lot and i am looking forward to contact you. Will you please drop me a mail?

  16. Perfectly stated and reasoned Jack. I will join you in doing all the things I’m able to to reverse the tide-for my kids and grandkids.

  17. I want to express some appreciation to you for bailing me out of this instance. As a results of browsing by means of the planet-huge-world-wide-web and obtaining tricks that ended up being not productive, I believed my total everyday life was through. Being alive devoid of the options to the difficulties you have solved being a result of your major webpage post is often a crucial situation, and those people that would have adversely damaged my job if I experienced not seen your web web page. Your individual personalized teaching and kindness in maneuvering all of the items was invaluable. I am not guaranteed what I would’ve performed if I hadn’t can come upon these kinds of a thing like this. It can be achievable to now glance ahead to my future. Thank you so much for the specialist and end result oriented guidebook. I will never consider twice to advise your world-wide-web web-sites to any human being who ought to get suggestions on this scenario.

  18. Since then, I have been feasting on piping hot, delicious home cooked pizzas, which I have eaten whilst sitting on the beach at
    night. Just be sure to sprinkle the bottom with cornmeal so the
    pizza will slide easier and pull the oven rack out so you aren’t likely to get injured while sliding it onto the pizza stone. It didn’t help that every pizza recipe I saw online would mention the dreaded “bread machine.

  19. Can you by chance play world of warcraft or any other on the internet mmorpg games? I know your name from a few games played online with others in. Are you by chance the person that I think that you are? If so this is a really cool site thanks with the details its good to know this.

  20. Wow, fantastic blog layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your site
    is great, as well as the content!

  21. Thank you, I’ve recently been searching for info approximately this subject for a long time and yours is the greatest I’ve discovered so far. But, what concerning the conclusion? Are you positive about the source?

  22. Hey! This is my first comment here so I just wanted to give a quick shout out and tell you I really enjoy reading through your articles. Can you recommend any other blogs/websites/forums that deal with the same topics? Many thanks!

  23. I don’t even know how I ended up here, but I thought this post was good. I do not know who you are but certainly you are going to a famous blogger if you aren’t already 😉 Cheers!

  24. I similar to the important data you offer inside your content pieces.I’ll bookmark your site and examine yet again right here repeatedly.I’m really sure I will discover an awful lot of recent things perfect right here! Superior luck to the upcoming!

  25. Hi there every onе, here everу peгѕon is sharing ѕuch famіliarity, so it’s good to read this webpage, and I used to pay a quick visit this web site all the time.

  26. Proper respiratory can be a matter worthy of
    its very own newsletter, but for now, let’s just emphasis on the pros of resistance breathing.

  27. To personally sign some of these debts will never be fully collected. By do so, homeowners incur a higher debt and decrease their equity. 1. Equity Stripping Before a home owner to the loss mitigation department; 5. Be Persistent.

  28. Hi, I do believe this is a great website. I stumbledupon it 😉 I’m going to return once again since i have bookmarked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.

  29. I’m really loving the theme/design of your site. Do you ever run into any web browser compatibility issues? A number of my blog visitors have complained about my blog not working correctly in Explorer but looks great in Chrome. Do you have any ideas to help fix this issue?

  30. You realize therefore significantly when it comes to this matter, produced me individually believe it from a lot of varied angles. Its like women and men are not interested unless it is one thing to accomplish with Woman gaga! Your own stuffs outstanding. At all times maintain it up!

Comments are closed.