Microsoft Office 2003
Launched, as the name suggests in 2003 as the successor to the vastly popular Microsoft Office XP (Sometimes known as Office 2002).
With the 2003 release of Office, Microsoft took the opportunity to introduce newer file formats to support enhanced features within the program, the interface was also 'tweaked' a little, to update it, but other than that there was little difference from Office XP. As such many of the articles will work on both the 2003 and XP versions of Microsoft Office.
As usual, if there's something we haven't covered that you want to know about, please E-mail us and we will do our best to create an article for you
Microsoft Office - Access
This is Microsofts flagship database creation package, it is ofen used as the platform for commercial database development, and many 'pro' database programmers have cut their teeth on Access.
Access Glossary - explanations of commonly used term in Microsoft Access.
Getting Started - a list of Do's and Don'ts to consider before you create your database application.
Splitting Your Database - Probably the single most important thing you can do with your database.
Form Tips - A 'must-do' checklist to help you provide an effective interface for your users.
Handling Pictures in Your Database - How to efficiently add pictures to your application.
Watermarking Your Reports - Adding this useful feature to your reports is easy.
Combo Box Queries - Limiting your users to a list of options for Query criteria.
Finding User Name - Using VBA to find the name of the currently logged in user.
Microsoft Office - Excel
The de-facto, standard spreadsheet application as used by almost every business in the country.
Excel Glossary - An explanation of some common Excel terms and phrases.
Keyboard Shortcuts - Quick and easy ways to navigate your away around your workbooks.
Longer Undo Lists - How to increase the number of steps in the 'Undo' list.
Handling Dates - Easy ways to use dates in your spreadsheet.
Info Function - Report system information from your Workbook.
Accented Characters - Easily use foreign vowels in your Workbook.
Cell References - The differences between Relative and Absolute cell references explained.
Cell Naming - Navigating your worksheet using cell names and references.
Cell Protection - A guide to securing your Workbook and keeping prying eyes out!
Graphical Comment Boxes - Add pictures or graphical backgrounds to your user prompts.
Learning About Macros & VBA - Part one of a complete guide to getting started on automating your spreadsheet.
Learning About Macros & VBA - Part two - modifying your macro and an introduction to VBA syntax.
Learning About Macros & VBA - Part three - Adding a command button to your project.
VBA Toolbox - Snippets of code to enhance your VBA macros.
Finding User Name - Using VBA to find the name of the currently logged in user.
Microsoft Office - Outlook
Most people know this as a program for sending & receiving E-mail but it has so much more, such as Calendar, Contacts & Task lists.
Change the Outlook E-mail received sound - Use your own sound to let you know of a new E-mail arrival.
Removing the desktop icon - Get rid of that pesky icon in versions of Outlook pre 2003.
Quick ways to enter dates - Dispense with the awkward calendar.
Recalling E-mails - How to re-call sent E-mails or delay their sending.
Clearing a blocked Outbox - Removing an E-mail that appears to have become stuck.
Cleaning your Outlook Profile - How to stop Outlook expanding to an unmaneagable size.
Backing up your Outlook Folders - Exactly what it says!
Blocked Attachments - Get access to those files that Outlook won't let you have.
Creating E-mail Accounts - How to manually set up a new POP3 E-mail account.
Email Templates - How to create a template to allow repeating E-mails to be sent with the minimum hassle.
Moving your Outlook data to a different location - How to change the default location for your Outlook data.
Finding User Name - Using VBA to find the name of the currently logged in user.
Microsoft Office - PowerPoint
Contrary to popular belief PowerPoint doesn't actually cause death, but is actually a fully featured multimedia presentation tool.
Keyboard Shortcuts - Quickly navigating your way around PowerPoint.
Glossary Of Terms - An explanation of all the PowerPoint specific jargon you are likely to come across.
The Melting Pot - A collection of small tips and tricks that don't need their own page.
Using Slide Masters - How to keep a consistent look and feel for your presentation.
Finding User Name - Using VBA to find the name of the currently logged in user.
Microsoft Office - Word
Probably the most widely used of the Microsoft Office packages, used from homes, schools, and businesses to produce all types of documents.
Default Page Settings - How to set-up Word with all your own custom page settings.
Displaying the Installed Fonts - How to see an example of every installed font.
The Melting Pot - A collection os small tips that have other place to go.
Booklet Printing - How to format and print your document to produce booklets.
Word Glossary - A comprehensive list of all the Word specific jargon you're likely to see.
Word Shortcut Keys - Using these keys can make using Microsoft Word a much quicker experience..
Using Special Characters - Getting those odd characters and symbols into your document.
Using The Spell Checker - Keeping your documents error free.
Finding User Name - Using VBA to find the name of the currently logged in user.