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……………………………………

Submit an Article – How and Why it Improves SEO Activities

Why submitting articles to directories helps your SEO efforts

And How to do it!

Submitting articles to directories on the internet is a very good way to quickly build backlinks to your website. This article will discuss some of the benefits as well as describe the process of submitting articles as well as describing some things to look out for and avoid. So the first step would be to write an article. And this article should do a few things, it should be somehow related to your website (or product), it should be at least 500 words (most directories require at least 500 words before publishing your article), and it should be readable and even entertaining or interesting (in other words, not just a bunch of non-sense copied and pasted from who knows where filled with links). Write a 500 Plus word article for a start. The next step is to google for article directories. A good search term on google would be ‘free article submission’ or ‘submit article’, and many variations of these search terms will give good results. You should be able to find a good list with a ton of directories that will publish your article online for free. (In fact I may publish such a list later on). Then, one by one, sign up to as many of these directories as you can. However one thing to watch out for is directories with very low page rank, which are basiaclly link farms. My theory is to never try to get links from anysite with a lower page rank than yours, so be careful if your website has a page rank over 2 or so. After signing up for as many of these directories as you can, start submitting your article. A good idea would be to mix up the wording in your article for each submission (also called ‘spinning’) in an effort to avoid getting ‘punished’ by google or other search engines for having duplicate content. This is the most difficult part of the process, and it will be frustrating and hard, but just remember that it will pay off big dividends in the near future. It is a good idea to keep all your passwords for all of the directories so that you can return to these websites and submit more articles (and get more backlinks). Another time saving tip is to use firefox webbrowser with the autofill settings on, this will make submitting your articles way easier since the browser will fill in a lot of the fields on all of the forms that you will encounter with this, this will save you a ton of time and a ton of typing in the long run. Just remember to submit, submit, submit, and eventually you will start to see these articles coming up on google, and you will get the backlinks. And if you are lucky and your article is interesting, then other websites will pick up and publish the article, thus giving you even more backlinks. So get started today!
Thanks for reading this article and feel free to leave tips and hints on how to do this in the comments section, and add some links to article submission directories that you may know about.

Unlock God Mode in Windows 8

How to Unlock God Mode in Windows 8

by Shane Zentz

Cool Windows 8 Secrets and Tricks

Hi Everybody,
Last week I posted how to unlock ‘God Mode’ in Windows 7, and after some trial and error I have learned that the process is nearly the same in Windows 8. So just to review, God Mode is basically just a centralized administration center where all controls are displayed in one location. Just like in Windows 7, the process for opening god mode in windows 8 is very easy and straightforward. First just create a folder anywhere, I think that the desktop is the best place, but you can place it anywhere in Windows that you want. Next, just rename the folder (right click and rename) to:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

And then just like in Windows 7, the icon for the folder will change to a control panel icon. When you open the icon you will get a folder with every administration option available to the user, in other words ‘God Mode’ with complete control, or at least as much control as Windows will allow. So if you like to have one location to control just about anything that Windows 8 will allow you to control, then try to unlock the ‘God Mode’.

Thanks for reading this post!
Shane Zentz