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 |
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 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]
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]
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]
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]
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]
^ top
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]
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]
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]
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]
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]
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]
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.
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.
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.
^ top
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]
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]
^ top
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.
^ top
DISCLAIMER
I don't want to alarm anyone but I'd be stupid not to say this. Whilst all
reasonable efforts have been made to ensure that all the files supplied
here are safe, I take no responsibility for any consequences whatever of
their use. All the files posted here have been thoroughly checked for
viruses. Some files contain VBA code and will trigger a warning when run
in the host application. It is your responsibility to virus-check these
files before use and satisfy yourself that they are safe to open.
COPYRIGHT
I claim copyright to all material posted here unless stated otherwise. You
are free to download, use and duplicate any of the material you find
here providing that authorship is acknowledged. ©1999-2012 Martin
Green.
|
