Martin Green Martin Green's Office Tips
|   Home    |   Training    |   Excel    |   Access    |   Word    |   Outlook    |   VBA    |   eBooks    |   Handouts    |   Site Index    |   RSS    |
More Departments 

Consultancy - I can help your business
Bookshelf - You need these books!
Comment - Just me sounding off
Mailbag - Readers' problems solved
Articles - Bits and pieces
Links - Check out these sites
About - Who is Martin Green anyway?

Visit My YouTube Channel

Free Courseware

Download free courseware handouts

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.


WWW    Office Tips

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 on my Training Page.

Development & Consultancy

Do you need someone to build you an Access database or an application in Excel? Or perhaps you are just looking for help and advice. I can help. Find out about my development and consultancy services on my Consultancy Page.

Contact Me

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

For general enquiries send me an email at

For business related enquiries (training, development and consultancy) send me an email at

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


New Access Forms Masterclass
#5 Dynamic Form Titles

[13 September 2018]

Most Access forms need some sort of title. The title can simply tell the user what the form is for but it can also provide a quick and easily visible reminder of which record is currently being displayed. In this Masterclass I lead you through the steps of creating a Dynamic Title for your form, one that changes automatically as you move from record to record, and automatically updates when certain data on the form is changed. A title should be both visually appealing and useful. My Masterclass chows you how to add a Dynamic Form Title that fulfills both those aims. It is very easy to create and in the process of building it you can learn a little VBA code. Check it out at Access Forms Masterclass #5: Dynamic Form Title.

New Access Forms Masterclass
#4 A Pop-Up Search Tool

[10 September 2018]

In this Masterclass I'm sharing with you a tool that I have included in many of the databases I have built, A Pop-Up Search Tool for your Access Forms. It's my most ambitious tutorial so far and, although not particularly complex, involves quite a lot of work, building the pop-up dialog box and creating the VBA code that powers it. If you are experienced in building Access forms you'll find it a breeze. But don't worry if you are a novice at form building or VBA coding because my Masterclass leads you through all the steps with lots of illustrations and code that you can copy and paste into your own project. There's a sample file to download containing a completed example of the Masterclass plus the entire tutorial in printable PDF format. Head over to the Masterclasses section of myAccess Tips homepage where you can check out this and all my other Access Forms Masterclasses.

Access Tutorial Updates

[21 August 2018]

There have been substantial changes in Microsoft Office since I started writing my online tutorials so I have decided it's about time I brought some of them up-to-date. It will take a while to check the text for compatibility with the latest versions and re-take all the screenshots. I have just published the first updated Access VBA tutorial, Customizing Access Parameter Queries, ready for Access 2016 (365) and suitable for all versions of Access from 2007 onwards. It's a great introduction to Access VBA if you have never tried it before with all the steps explained and lots of screenshots so you can be sure exactly what to do. You can also download a ready-made example and a printable copy of the tutorial in PDF format.

If you are new to Access and don't know about Parameter Queries take a moment to check out my newly updated tutorial Using Parameter Queries. You'll wonder how you ever managed without them!

New Resources Page

[16 April 2018]

Those of you who have been fortunate enough to attend one of my training courses will know that I have scant regard for many of the handbooks supplied by training companies. These weighty tomes usually end up on the shelf and gather dust until they are eventually thrown away unread. Instead I prefer to write my own documantation which is well illustrated and easy to read. The examples in my handouts will often be the same as you will have done in class but if you haven't been to one of my classes, or would just like to run through some of the exercises again, many are accompanied by sample files.

All my handouts are free for anyone to download. They are all in PDF format and are fully printable with no restrictions. You can find them on my new Training Resources Page. As I write this the content is mostly Excel and VBA but I will be adding more as they become available so stop by regularly for the latest content.

I'm Back!

[25 July 2017]

A lot has happened since I last updated this site. Poor health and life in general has got in the way of things and I have neglected to keep my Office Tips web site the vibrant and exciting place it used to be. I've decided that it's time I did something about it so I am embarking on a major update of the site. Tutorials will be brought up-to-date and lots of new ones are on the way and I am finally writing my long promised eBook on VBA UserForms. Watch this space for further announcements.


[25 July 2017]

Until now my existing eBooks on The Visual Basic Editor, VBA Message and Input Boxes, and Recording Excel Macros have been available for purchase. From today all of these ebooks are totally FREE for you to download. Each PDF is unrestricted so you can copy and paste content and print out as many copies as you like. No strings! Just follow the links above or go to my eBooks page and follow the download links.

Why free? I belong to a generation that remembers life before the Internet. So many people enjoy its benefits but never make any contribution themselves. I decided it was time for me to give something back.

If you would like to say thanks and make a small donation to help support this site please click the PayPal Donate button below. You can donate any amount in any currency you choose. It's easy and only takes a moment. Thank you.

Pip pip!

No, this isn't my real signature!

What's New?

New Access Forms Masterclass
Create Dynamic Titles for Your Forms

New Access Forms Masterclass
A Pop-Up Search Tool for your Access Forms

13 September 2018

Martin Green's eBooks

All my eBooks are now FREE!
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 July 2017
Put a Date Picker Calendar on an Excel Worksheet
A Pop-up Calendar for Excel
Writing Your First VBA Function in Excel
Access Query and Filter Criteria
Build an Excel Add-In
Calculating in Access Queries
Access and SQL: Putting VBA and SQL Together
Build Custom Functions for Your Access Applications
Working with Dates in Access Queries
 10  Fill a Combo Box or List Box List from a Database
Support this site!

Please make a small donation to help support this site.

Thank you.

  ©2000-2018 Martin Green All rights reserved