How to Customize Access Databases – Follow Up

How to Customize Your Access Database Applications – Follow Up

In an earlier access tutorial I showed how to create a customized start ‘splash’ screen or pop up window that was set to open when the database application was opened. Now I will give a follow up to that which shows how to further customize your access database application. So, the first thing that you will want to change or customize is the title of the database, which appears in the upper window. By default, Access places simply the file name of the database in the title bar, but you may want something other than that, so here is how to change that. First click on the ‘Home’ tab at the top, and from the home tab, click on the ‘options’ menu on the left hand side of the screen. Now on the options menu that pops up, the first thing to do is to click ‘current database’ to make sure that you are making changes to the current database. Here is what the menu looks like:

Access - Shane Zentz

Access – Shane Zentz

Here is where you can change the text in the title of your application, simply add your own text. Also you’ll notice that you can also add your own icon for the current database. If you have a 32 x 32 pixel .ico file that you would like to see in the taskbar area when your database application is running, then just click on the box and navigate to it and Access will add it automatically. You also have the option to make this icon the icon for the forms and reports in your database. These two things go a long way in allowing you to customize your access database application.

One more thing you can control from this screen is whether you want the user of your database program to have access to the navigation pane on the left hand side of the database application. This navigation pane is displayed by default and contains menus for tables, forms/reports, and queries. However there are times when you do not want a user of your access database application to have access to these things. The solution is to de-check the ‘display navigation pane’ checkbox as seen here:

Access - Shane Zentz

Access – Shane Zentz

This does not block the user completely from, say, opening up a table that you don’t want them to access and altering data, but most users will be unsavy enough to never realize that they can simply open the options menu for the database and check the ‘display navigation pane’ checkbox to have access to the navigation pane. So this will be an easy and effective way to block access to things like tables and forms that you dont want other users figeting around with.

Thanks for reading this post,
Look for more Access Tutorials to come soon……………………………………