|   Home    |    Excel    |    Access   |   Word   |   Outlook   |   FrontPage   |   VBA   |   Downloads   |   Index   |
Downloads...
 
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.

 
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.

 
Support this site!

Make a small donation to help support this site.

Donate in US Dollars

Donate in UK Pounds

Donate in Euros

Courseware Downloads

On this page you will find links to training files that you can download and study at your leisure. I provide them as an additional resource for my students, but anyone is welcome to make use of them. If you need additional help regarding these documents, or have any suggestions for further material, please contact me at martin@fontstuff.com. The list is going to get bigger, so if you can't find what you want right now, come back another time and you'll find more. Finally, please read the disclaimer and copyright notice at the bottom of the page before you download any of these files.

You will find sample files for the applications themselves (e.g. Excel, Access) and accompanying documentation in both Microsoft Word (*.doc) and Adobe Acrobat (*.pdf) format. Some files contain their own documentation. The best way to download a file is to right-click on a link and choose Save Target As from the menu.

Topics Available

Excel VBA  |  Access VBA  |  Word VBA  |

Microsoft Excel VBA

Pop-up Calendar Add-In for Excel (Excel 2007/2010 version)
A fully-working Add-In (.xlam) for Excel which opens a calendar when the user right clicks on a cell and chooses Insert Date or uses the shortcut CTRL+SHIFT+C. The file accompanies the new Excel VBA tutorial A Pop-up Calendar for Excel which has been completely revised and updated for Excel 2007 and Excel 2010. It is also available as an Excel workbook (.xlsm).
[Excel 2007,2010]

Pop-up_Calendar_Add-In.zip [16KB] Pop-up_Calendar_Workbook.zip [18KB]

Pop-up Calendar Add-In for Excel (Excel 97/2000/2002/2003 version)
A fully-working Add-In (.xla) for Excel which opens a calendar when the user right clicks on a cell and chooses Insert Date or uses the shortcut CTRL+SHIFT+C. The file accompanies the Excel VBA tutorial A Pop-up Calendar for Excel. It is also available as an Excel workbook (.xls).
[Excel 97, 2000, 2002,2003]

Excel Calendar Add-In.zip [11KB] Excel Calendar Workbook.zip [13KB]

Introduction to Excel VBA: 1. Macro Basics
This Excel file and its accompanying notes guide you through the principles of recording macros and show you how to edit a recorded macro. [Excel 97, 2000, 2002]

VBA01-Macros.xls  Excel VBA Notes: 1  Excel VBA Notes: 1

Introduction to Excel VBA: 2. Using Loops
Loops are the one of the core tools used by the VBA programmer. This file contains several different examples and demonstrates how and why they are used. [Excel 97, 2000, 2002]

VBA02-Loops.xls Excel VBA Notes:2  Excel VBA Notes: 2

Introduction to Excel VBA: 3. Messages
Communicate with your users! Message boxes and Input boxes provide an easy way to interact with the user when your code runs. This file has several examples of both. There are no additional notes - check out the code and you'll find all you need. [Excel 97, 2000, 2002]

VBA03-Messages.xls    

Introduction to Excel VBA: 4. User Forms
Master UserForms and you are on your way to creating full-scale applications in VBA. This file contains an example form and the accompanying notes explain how the code works.
[Excel 97, 2000, 2002]

VBA04-UserForms.xls  Excel VBA Notes: 4  Excel VBA Notes: 4

 

^ top

Microsoft Access VBA

Fontstuff Database
This sample database contains two tables - one containing the personal details of the staff of a fictitious company and the other containing the addresses of that company's offices. The staff table contains over 1000 records. I have used this database as the example in many of the Access and Access VBA tutorials. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

Fontstuff97.mdb [256KB] Fontstuff97.zip [80KB] Access 97 format.
Fontstuff2K.mdb [436KB] Fontstuff2K.zip [109KB] Access 2000 format.


Access Pop-up Calendar Demo
A sample database to accompany the tutorial A Pop-up Calendar for your Access Forms. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

CalendarDemo97.mdb [160KB] CalendarDemo97.zip [24KB]
CalendarDemo2000.mdb [168KB] CalendarDemo2000.zip [30KB]


Cascading Lists Demo

A sample database to accompany the tutorial Cascading Lists. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

CascadingListsDemo97.mdb [130KB] CascadingListsDemo97.zip [15KB]
CascadingListsDemo2000.mdb [304KB] CascadingListsDemo2000.zip [54KB]


Multi Select Demo
A sample database to accompany the tutorial Making Sense of List Boxes. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

MultiSelectDemo97.mdb [114KB] MultiSelectDemo97.zip [23KB]
MultiSelectDemo2000.mdb [200KB] MultiSelectDemo2000.zip [35KB]


Coloured Tabs Demo
A sample database to accompany the tutorial Coloured Tabs for Your Access Forms. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

ColoredTabsDemo97.mdb [88KB] ColoredTabsDemo97.zip [10KB]
ColoredTabsDemo2000.mdb [372KB] ColoredTabsDemo2000.zip [53KB]


Combo Box Date Chooser Demo
A sample database to accompany the tutorial Build a Combo Box Date Chooser. It is available in both Access 97 and Access 2000 (also suitable for Access 2002) formats and as a Zip file for faster download. [Access 97, 2000, 2002]

DateComboDemo97.mdb [92KB] DateComboDemo97.zip [14KB]
DateComboDemo2000.mdb [180KB] DateComboDemo2000.zip [33KB]


Access and SQL Part 4: Building Queries "On the Fly"
A sample database to accompany the tutorial Building Queries On the Fly. It contains a table of sample data and the two forms containing the features described in the tutorial.

AccessAndSQL4_97.mdb [270KB] AccessAndSQL4_97.zip [82KB]
AccessAndSQL4_2000.mdb [384KB] AccessAndSQL4_2000.zip [99KB]


Access and SQL Part 5: More Instant Queries
A sample database to accompany the tutorial More Instant Queries. It contains a table of sample data and the two forms containing the features described in the tutorial.

AccessAndSQL5_97.zip [82KB] AccessAndSQL5_2000.zip [122KB]


Access and SQL Part 6: Dynamic Reports
A sample database to accompany the tutorial Dynamic Reports. It contains tables of sample data, a report and the five dialog box forms featured in the tutorial.

AccessAndSQL6_97.zip [107KB] AccessAndSQL6_2000.zip [115KB]

 

^ top

Microsoft Word VBA

Automatic Document Template
A fully-working template for Word which employs a VBA UserForm to help the user fill in a standard letter. This file accompanies the Word VBA tutorial Build an Automatic Document Template for Word. [Word 97, 2000, 2002]

InterviewLetter.dot [43KB] InterviewLetter.zip [12KB]

Simple Pop-up Calendar
A fully-working template for Word containing a Pop-up Calendar UserForm. Install this file in your Word Startup folder. This file accompanies the Word VBA tutorial A Pop-up Calendar for Word - Part 1: A Simple Calendar. [Word 97, 2000, 2002]

 WordPopupCalendar_v97.zip    [11KB]  WordPopupCalendar_v2000.zip [11KB] 
 WordPopupCalendar_v2002.zip [14KB]  

^ top

Miscellaneous Files

ActiveX Calendar Control
This file is required by several of my VBA tutorials. If you need a copy you can download it from here. Each zip file contains a copy of the Microsoft's mscal.ocx ActiveX control file and the associated help file. There is a file for each version of Microsoft Office. For full instructions on how to install the file refer to: I Don't Have a Copy of the mscal.ocx Calendar Control.

mscal_office97.zip mscal_office2000.zip mscal_office2002.zip

^ top


^ top
 

 

 

 

 

 

Hit Counter