Instructions

These tutorials (courtesy M. Brydon) are in Adobe Acrobat PDF format. You can download them individually or as a set. To view the files, you need the Acrobat Reader, which Adobe provides at no charge

Two hints on using the Acrobat Reader:

  1. Version 3.0 provides a plug-in that works with most WWW browsers (e.g., Netscape Navigator, Microsoft Internet Explorer) and allows the PDF document to be shown within the browser window. This is a convenient way to view one tutorial. However, the links between the tutorials and the table of contents do work from within the browser.
  2. You can download a version of the Acrobat Reader that includes the Acrobat full-text search plug-in. The self-contained version of the tutorials provides an index that can be used by the search plug-in to search across the entire set of tutorials. This may be a useful feature.

Microsoft Access Tutorials: On-line version

Table of Contents 8. Combo Box Controls
1. Introduction to Microsoft Access 9. Advanced Forms
2. Tables 10. Parameter Queries
3. Relationships 11. Action Queries
4. Basic Queries Using QBE 12. An Introduction to Visual Basic
5. Basic Queries using SQL 13. Event-Driven Programming Using Macros
6. Creating Basic Forms 14. Data Access Objects
7. Subforms 15. Advanced Triggers

Support files for the tutorials (you will need these files to complete the tutorials)

univ0_v2.mdb (zipped)

univ0_v7.mdb (zipped)

Tutorial file for users of Access version 2.0 and Access Version 7.0
depts.xls (zipped) Department information to import
inventor.xls (zipped) Inventory information to import

Microsoft Access Tutorials: Self-contained package

install.bat

part1.exe

part2.exe

These compressed files include all the PDF tutorial files plus the index files and directories required for full-text search. Each file is small enough to fit on a 1.44 MB floppy disk.
  • use the Save As command in your browser to save as install.bat file (or remember the commands in the batch file and execute them yourself),
  • copy all three files into a suitable directory,
  • run install.bat to extract the files and index directories.

Microsoft Access Tutorials: Print-only version

2up.pdf Print-only version: The tutorials are combined into one PDF file and formatted in "2-up" mode (two pages of content per piece of paper). The hypertext links do not work in this document--it is intended for printing only. Note that the images print best on a PostScript printer. Results are less certain using non-PS printers.

Colophon

These tutorials were created using Adobe FrameMaker 5 for Windows 95/NT. Each chapter was printed as a separate PostScript file and Adobe Acrobat Distiller was used to convert the PS files to PDF. Acrobat Catalog was used to create the index. The screen shots were done with Corel PhotoPaint.


Comments about content or information concerning typos and other mistakes are always welcome at brydon@unixg.ubc.ca.