Martin Green Martin Green's Office Tips
|   Home    |    Excel    |    Access   |   Word   |   Outlook   |   FrontPage   |   VBA   |   Downloads   |   Index   |   Blog   |
Departments...
|   eBooks   |
|   Courseware   |
|   Bookshelf   |
|   Training   |
|   Consultancy   |
|   Comment   |
|   Mailbag   |
|   Articles   |
|   Graphics   |
|   About   |
|   Links   |
 
Free Courseware

Download FREE courseware handouts. These documents are ideal for teachers, students and anyone wanting to learn more about their Microsoft Office programs. Each handout covers a specific topic and is illustrated with full-colour screenshots. Many have accompanying sample files. The files are not restricted in any way so you can print copies or read them on-screen.
Get my Free Courseware here.

 
Search
Google

 
WWW    Office Tips
 
Training

Are you looking for Microsoft Office training for yourself, your colleagues or your staff? If you like what you see here, you can get personal training from me. Find out more at the Training page.

 
Consultancy

Do you need someone to build an Access database or an application in Excel? Or perhaps you're just looking for help and advice. I might be able to help. Find out about my consultancy services at the Consultancy page.

 
Contact

I work from an office at home so, for reasons of personal privacy, you won't find a contact address or telephone number here.

To find out how to contact me for general enquiries click here.

For business related enquiries (training, development and consultancy) click here.

All messages concerning business or training work will receive a prompt reply with full contact details.

Changes on the Way

Still Alive (Just)

Writing this, I've just arrived home from a spell in hospital following a short and sudden illness that, had it not been treated in time, might have taken my life. But we Greens are of hardy stock and I plan to live to a great age. Serious as it was this was just a bump in the road. Nevertheless, it has helped put a few things into perspective for me and helped me sort out some priorities, one of which was to embark upon a major update of my web site.

Watch This Space

When I started building this site Microsoft Office 97 was new and many of the tutorials were written as they applied to that incarnation of Microsoft Office. Although most still apply today, Microsoft Office 2010 is an entirely different beast with a revised user interface and many new features. I'm aware that some of my tutorials don't work or have to be adapted to suit the newest versions of Office. I've also learnt a bit more over the years. So I have a big job to do. One by one I am going to rewrite all of my tutorials and thoroughly check them for compatibility with the current version of Microsoft Office. That includes updating all the screenshots too. Quite an undertaking! As the work progresses all my links will point to the updated versions but the originals will not disappear. There will be links to the original versions for those who still use the older versions of the programs.

Always Studying

In this business you never stop learning. My latest study project is Microsoft's latest web design program called Microsoft Expression 4. It's a hugely powerful program and replaces Microsoft FrontPage, the program I've used to build and maintain this site almost from the start. The final version was Microsoft FrontPage 2003 and I've been using it happily ever since its release. So, once again it has been a trip to Amazon for a pile of books and endless hours studying online tutorials. As always there's a steep learning curve but for me it's all part of the fun!

Stupid (not to be read by those of a sensitive disposition!)

Not long ago I received an email from some guy berating me for using Microsoft FrontPage and wondering why I wasn't ashamed to admit it by displaying the logo you see at the foot of this page. According to him you weren't a real man (my words) unless you used Dreamweaver. I really don't know why he bothered to tell me this. I teach people to use Microsoft applications and I work as a Microsoft application developer. It would be natural for me to use FrontPage because it did, and still does, everything I need. Anyway, when I first started building web pages neither program existed and I wrote my pages in HTML in Notepad when he was still in short pants. I was tempted to tell him this but instead his email went into the bin.

I get similar comments from people about Microsoft Access. Surely any sane person would use Microsoft SQL Server or (God forbid) Oracle. SQL Server is a fine program and I have a fair grasp of it. It is the world leader in server based database management systems. But Microsoft Access is simply the best desktop database there is. No argument. If you want to build a database for a small workgroup it's ideal, and when you want to roll it out worldwide the transition to SQL Server is easy.

If you get comments like this from those who think they know better remember, this is just a variation on the "I've got a bigger car than you" or "I've got a better phone than you" (jeez!). What they are really saying is "I've got a bigger p*nis than you" and if they spent less time playing with it maybe they wouldn't make such stupid comments. So be like me, the next time some ar*ehole tries to put you down just tell them to f**k off!

Keep dancing!

   
10 August 2011      

 

©2011 Martin Green. All rights reserved.

Created and Managed with Microsoft Office FrontPage

What's New?

New Free Handout:
Working with Macros and VBA in Excel 2007
>>GO>>

21 February 2009
 
eBooks

eBooks by Martin Green

Do you want to learn more about Access, Excel and VBA? Are you a teacher looking for top quality courseware for your students? My eBooks are the ideal solution to your needs. They are packed with code snippets, illustrations and step-by-step exercises. Written in the same style as my popular on-line tutorials, my eBooks will help you develop your skills and build useful, professional looking applications. Find out more at my eBooks Page.

 
Top 10 Tutorials

Compiled from the visitor figures for May 2011

Access Query and Filter Criteria
A Pop-up Calendar for Excel
Working Out a Person's Age - An Introduction to Nested IF Statements
Access+SQL: Putting VBA & SQL Together
Build an Excel Add-In
Writing Your First VBA Function in Excel
Using Parameter Queries
Using VBA to Manage Your Outlook Email Attachments
Access+SQL: Some Practical Examples
10  VBA UserForms: Fill a Combo Box or List Box List from a Database
 
RSS News Feed

Use my RSS News Feed to get up-to-date news about new Office Tips tutorials, articles and publications as they happen.

RSS Office Tips Update

Click on the orange button to go straight to the news feed or follow this link to find out All About RSS.

 
Support this site!

Make a small donation to help support this site. Why donate?

Donate in US Dollars

Donate in UK Pounds

Donate in Euros

Thank you for thinking about it!
 

 

 

 Hit Counter