• Access Handouts
• Excel Handouts
• VBA Handouts
• Make a Donation
• Copyright

Make a small donation to help support this site.

My RSS News Feed will let you know when new courseware is available, as well as all the news about tutorials, articles and downloads.

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.

Free Training Handouts

I have written a wide range of handouts that I use when teaching Access, Excel and VBA. I am in process of updating them and, as each new title is finished, I will be offering them for FREE download here. Whether you are a student, teacher or trainer, you are welcome to download these files entirely free of charge and use them to help with your studies or your teaching work.

About the Handouts

Each handout is in PDF format and many have accompanying files containing worked examples from the text. Each one covers a single topic in detail and is illustrated with full-colour screenshots. Most are between 2 and 6 pages in length.  The files are not restricted in any way so, using the Adobe Acrobat Reader (download the latest version free here.) you can read the documents on screen, print your own hard copies or even copy and paste text and images into your own documents (please read the copyright notes below).

Watch Out for New Titles

I will be adding to the list of titles so stop by regularly to check for new titles. You can subscribe to my RSS News Feed to be automatically notified when new handouts become available.

To Download the Files...

Internet Explorer: Right-click on the link for your chosen file and choose Save Target As from the menu.
Firefox: Right-click on the link for your chosen file and choose Save Link As from the menu.
Opera: Right-click on the link for your chosen file and choose Save Target As from the menu.

The accompanying files are contained in ZIP files for security and speedy download. ZIP files can be extracted in Windows Explorer (in Windows XP) or with one of the many file compression programs such as WinZip which you can download from here.

Access Handouts

Title	Handout (.PDF)	Sample Files (.ZIP)
Calculated Fields	fsCalculatedFields.pdf [165KB]	fsCalculatedFields_mdb.zip [13KB]
Connecting to Excel with ADO	fsADOConnectExcel.pdf [134KB]	fsADOConnectExcel_mdb.zip [17KB]
		fsADOConnectExcel_xls.zip [79KB]
Linking Access to SQL Server	fsLinkingToSQLServer.pdf [311KB]
Database Structure	fsDatabaseStructure.pdf [232KB]
Table Relationships	fsRelationships.pdf [222KB]	fsRelationships_mdb.zip [24KB]
Showing Totals in Queries	fsQueryTotals.pdf [195KB]	fsQueryTotals_mdb.zip [14KB]
Crosstab Queries	fsCrosstabQueries.pdf [303KB]	fsCrosstabQueries_mdb.zip [14KB]
Parameter Queries	fsParameterQueries.pdf [192KB]	fsParameterQueries_mdb.zip [56KB]

Excel Handouts

Title	Handout (.PDF)	Sample Files (.ZIP)
Working Out a Person's Age in Excel	CalculatingAgeInExcel.pdf [116KB]
Excel’s Business Tools: What-If Analysis	What-if_Analysis.pdf [686KB]
Building Custom Functions	fsCustomFunctions.pdf [179KB]	fsCustomFunctions_xls.zip [13KB]
Building an Excel Add-In	fsExcelAddIns.pdf [199KB]	fsExcelAddIns_xls.zip [22KB]
Build a UserForm for Excel	fsUserForms.pdf [445KB]	fsUserForms_xls.zip [16KB]
Recording Macros in Excel	fsRecordingExcelMacros.pdf [113KB]
Macros and VBA in Excel 2007	fsExcel2007VBA.pdf [449KB]

VBA Handouts

Title	Handout (.PDF)	Sample Files (.ZIP)
Introducing VBA Message Boxes	fsMessageBoxes.pdf [142KB]	fsMessageBoxes_xls.zip [12KB]
Using Loops to Repeat Code	fsCodeLoops.pdf [101KB]	fsCodeLoops_xls.zip [24KB]
UserForm Code Reference (Basic)	fsUserFormCodeRefBasic.pdf [105KB]

Make a Donation

This courseware is entirely free of charge and without obligation. If you find them useful please consider making a small donation to help cover my expenses so that I can continue to maintain this web site and offer more material to my visitors. Just click the PayPal Donate button on the left to make a quick and easy donation with your credit or debit card.

Copyright Notes

• My free courseware is print enabled. You may print an unlimited number of copies for educational or personal use. Printed copies may not be offered for resale.
• My free courseware is copy enabled. You may copy text and illustrations from the courseware for inclusion in your own documents providing these documents are not offered for resale and that authorship is acknowledged. If you have any questions about copyright please contact me at training@fontstuff.com.
• All courseware offered here is copyright ©2006-2013 Martin Green. All rights reserved.