Are you tired of things taking too long whilst you are using Microsoft Access?

Do you wish there was a quicker way to add or browse through data instead of using the mouse?

Then this latest Microsoft Access Tip is for you!

We will tell you about a few of the most useful keyboard shortcuts which can be used to cut the amount of time used to complete certain tasks.

Adding new Record: use CTRL & the plus sign (+) to add new records to your Access Database.

Deleting the current record: use CTRL & the minus sign (-) to delete the current record being viewed.

Undoing any changes: if it is just the current field you want to undo changes for, press the ESC key once. If however, you want to undo any changes made to the entire record then press the ESC key twice.

Recalculating fields: pressing the F9 key will recalculate the fields shown in the window.

Undo typing: to get rid of any typing, use CTRL & Z.

Are you interested in reading more tips? Then take a look at our Microsoft Access Tips page.

Do you want to learn more about Access? Then book yourself on one of our Microsoft Access Training Courses.

In one of our previous articles, you remember how we compared Google Docs & Microsoft Office Web Apps to see which one most benefited the user? Well now after just 100 days, Microsoft reports that the number of Office Web Apps has surpassed the 200 million mark.

To celebrate this achievement, they are adding more features to what we described as their ‘Diet Office’ so that you can now embed both Excel and PowerPoint documents onto web pages for easy viewing.

They are also adding the option of being able to import documents which have been created online using the Web Apps into the full Microsoft Office if it is installed on your computer for editing purposes. This feature should turn to be extremely popular as the diet version of Office lacks many of the key features which users use on a daily basis.

To finish off this upgrade, Microsoft has also added the Mobile Applications. So now you can edit your files, practically anytime, anywhere, whether you are heading for a meeting or relaxing on a beach somewhere hot.

If you are interested in learning more about the full/desktop versions of any Microsoft Office Program, then head on over to our Microsoft Office Training Courses where you can choose from Word, Excel, PowerPoint, Project, Access and Outlook.

Feel free to browse our Public Schedule or contact us and we’ll be happy to help arrange your training.

This tip may be useful for people who handle payroll spreadsheets within businesses as it allows the user to input times that when added together exceed 24 hours.

In a normal situation, Excel will ignore any data which exceeds 24 hours so therefore you need to set the cells up not to ignore the data after the initial 24 hours. Here is how you do it:

Right click in the cell which you use to total up the number of hours and select Format Cells.

In the Format Cells dialog box, select the Number tab and edit the Custom Settings by inserting brackets around the H representing hours so it looks like [h]: mm.

Then click Ok and you will see that the formatting you have just done means that Excel now shows you the total data exceeding 24 hours

If you would like more hints and tips to help you use Excel, visit our Microsoft Excel Tips page.

If you would like to learn more, then book yourself on one of our Microsoft Excel Training Courses.

The ‘Here you have’ email has been spreading through the online world, infecting victims contact lists and sending copies of itself to everyone on your contact list.

The email itself invites the user to click on a link which takes you to a PDF file. One of the most common versions going around offers a link to free XXX downloads. If the link is clicked on, the virus is then downloaded on their machine and spreads to the contact address book of their email account and then sending duplicates of itself to each of their contacts.

The worm also attempts to shut down any anti-virus software currently installed on the machine, opening the door for other viruses to infect and eventually cripple the machines performance.

It’s not just small companies that this virus is infecting either with firms such as Disney, Comcast and even NASA being affected.

A couple of the known versions of the email says:

Hello: This is The Document I told you about, you can find it here – and then provides the link for the bogus PDF file.

The other has the subject: Just For you and says: This is The Free Download Sex Movies; you can find it here – again with a link for the reader to click.

Computer Security and Anti-Virus software maker McAfee says that if you receive any emails resembling these then you should delete them immediately, even if they’re from somebody you know and do not click on the links.

In addition, ensure that you keep your machines updated with the latest software updates, especially the anti-virus.

Have you recently upgraded the computers you or your business use to newer machines but run into the roadblock of trying to move over your outlook data onto the new machine?

Well no need to worry, there is a way for you to transfer the existing data off of the old machine onto the new machine so you won’t lose anything.

To get started, you have to have some form of removable media such as a CD ROM or a USB Memory Stick upon which you can save the PST file itself to transfer to the other machine. Next you need to create a Backup of the PST file.

In order to do this, follow these steps:

Go to the Start menu and select Control Panel. Once in the Control Panel, double click the User Accounts icon and then do the same on the Mail icon. Then select your profile from the ones displayed and select Properties.

Under the Name, click the Personal Folders that you want to backup. If there are no entries named Personal Folders, then you will have to enable the Personal Folders Service.

You then click Settings and take note of the file name and path which appears (copy and paste them in notepad or something). Due to the amount of data which is stored in these PST files contain, they can be rather large.  If you would like to compact the size of this file for it to fit in the removable device you are using to move the file, then select the compact now button in the Settings window.

Close the other properties windows and then look back at the file path you pasted in notepad and then use Windows Explorer to copy the PST file onto the device you have to put the backup on.

Once you have completed this part, the next step is to import the PST file into Outlook on your new machine. To do this, put the CD ROM or USB memory stick you have the backup on into the new machine and open it before copying the PST file and pasting it onto the hard drive of the new computer.

Ensure that when you copy the file, ensure the Read Only attribute is not selected otherwise you will receive an error message. If you get the error message then you need to clear the Read Only attribute and then proceed to copy again. Then open up Outlook.

Go to the File menu and select Import and Export. Then select Import from another program or file and click Next. Select Personal Folder File and click Next again and then select the file which you have just put on the hard drive.

To import everything the file contains, ensure that you select the File itself and not one of the subfolders. Then select Finish and you have done it.

For more Outlook Hints and Tips, visit our Microsoft Outlook Tips page.

If you want to learn more about Microsoft Outlook, then book yourself on one of our Microsoft Outlook Training Courses.

With the current economic climate and jobs becoming hard to find, you really need to do things to set yourself apart from your competitors hunting for the same job.

In the IT sector, one of the ways to do this is to work toward becoming Microsoft Certified. Seeing the Microsoft Certified logo on your CV gives the prospective employer the peace of mind that you know what you are talking about and are passionate about the job which you do.

MCSE stands for Microsoft Certified Systems Engineer. People which might find this of interest would be the budding Technical Support & Systems Engineers, Technical Consultants, Network & Systems Analysts as well as regular Software Engineers/Professionals.

Whilst the certification sets you apart from competition without the certification, it can also lead to a feeling of better job satisfaction and a nice increase in the amount of money you earn.

There are also the benefits you get from Microsoft when you become certified such as the industry recognition and access to technical and product information directly from Microsoft. In addition, there are also discounts on Microsoft products and services to be had.

It is time for another helpful Microsoft Project tip for our readers. This tip will show you how to create Drop down lists for any custom fields which you have created.

Please be aware, this tip is only for Microsoft Project 2007.

To start off with, go to the Tools menu and select Customize and then Fields. Select Any Field Type in the dialog box which appears before selecting an available field and renaming it.

Next, click the Lookup button and use this to add your list of Values.

The Lookup Table that is attached to the field will then generate the list of values for you.

Want more Microsoft Project Tips? Then visit our Project Tips page.

Or perhaps you want to learn more about Microsoft Project? Then visit our Project Training Courses page.

You may have heard of the Windows Server 2008 bots, these bots have been infiltrating our courses here at Infero, reminding us that Microsoft stopped supporting Server 2000 in July 2010 and those businesses still using it should think about switching to either the 2003 or 2008 version of server.

So, has the time really come for your business to call time on Server 2000 and move into more modern versions? If your answer to this question is yes, then Infero has the perfect way to help you.

We therefore have new courses which focus on learning many aspects of Windows Server 2008 in addition to already having Server 2003 Courses.

Since these courses are so detailed, they require longer than a day to complete but you still get all of Infero’s benefits whilst you are learning with us.

There is no need to travel down to London to learn these courses since we are conveniently located in the East Midlands, with great transport links close by.

So what are you waiting for? Head on over to our Windows Server Training Courses page and take a look at what we are offering.