New Page 1

Access 2002 Software Utilities

Contact the author at: bobalston9 AT yahoo DOT com

Archive Microsoft Outlook E-Mail Messages & Attachments

	Archives e-mail contents to Access 2000 table
	Saves attachments as Windows files
	Access table of attachments tied to messages
	Hyperlinks to attachments
	Handles embedded messages - messages attached to messages. These can be nested.
	Does not handle OLE items in an Outlook message, which Outlook stores as an attachment.

Archive Lotus Notes E-Mail Messages & Attachments

Similar features to the above.

Access Database Monitoring & Backup

	Manages an unlimited list of access databases
	Verifies hourly during specified hours that each database is accessible
	Exceptions are notified via e-mail, which can be easily routed to an alphanumeric pager.
	Nightly runs automatic backup script and compression with optional printed report of results.

IT Project Status Tracking and Reporting

	Multi-user Access Database
	Focus is on tracking and reporting overall project status, major miulestones, etc. Not intended to use to manage the details of a project
	Shows status on unlimited number of project milestones
	Allows periodic text status summary; all are shown, latest first.
	Allows entry/reporting of Accomplishments & Next Steps
	Allows entry/reporting of Major issues
	Allows reporting of actions required outside the project team
	Interactive form and report for a single project or a custom filtered set of multiple projects.

Cross Reference Access Tables and Queries

	Generate a where used list for tables and queries
	Step 1 - select the Access DB - browse to it
	Step 2 - One time extraction of the where used data
	Step 3 - Select a table or query name from a drop down list to see its where used by object name and type.

Access Where Used Structured Report/Diagram Showing Indented Structure

	Shows end object and all queries & tables used in a tree structure like indented structure
	Queries, reports and forms and the input source for each. If the input source is a query shows the tables and/or queries that are used by it. Recursive structure shows all levels down to tables.

Access Database of Web Resources for Access

	List of various access resources
	Includes sites with free code & downloads
	Includes sites with Q & A forumns
	Includes sites with various tips and FAQs
	Includes specific Microsoft knowledgebase articles
	Includes online tutorials
	All have hotlink to target

Job Search Contacts Database

	Maintain a list of contacts
	Allows recording of multiple sets of information related to each contact; thus allowing recording on each interchange.

I.S. Budget Development System

	Allows for entry of the proposed new budget for controllable accounts for each combination of cost center and account.
	For each new budget entered, supporting detail can also be entered.
	On-line review and update as well as a variety of reports can be produced.
	Maintains employee related budget information. This includes salary data for existing and proposed billets, both exempt and non-exempt, along with employee related benefit amounts. This information is initially entered into the roster system, then the Finance budget system.

I.S. Budget Management System

	Assists in controlling budgets by improving ability to accurately forecast expenditures for specific cost centers and accounts.
	Allows I.S. top management and administration to analyze, summarize and report on various aspects of the budget forecasting process.

Report differences in all tables in two versions of Access MDB File

	Key need when distributing Access based software is to ensure all changes to tables are made when updating a client's access software. This is because you cannot replace the tables because the live data is there. This utility compares the attributes of fields in each database and reports the differences.
	The latest version also lists new fields, deleted fields and automatically applies changes (where permitted by Access).

Context Sensitive HELP System using Access Form

This is a context sensitive help system built entirely within Access. Each form can be tied to a unique HELP record, consisting of a single page of information for that form. The system also allows for generic information about the system that is not tied to any form.

Compare Database Versions and Update the Table Definitions

I found a very nice, FREE utility to do this: Compare'EM

http://home.gci.net/~mike-noel/CompareEM.htm

Very Easy to Use Reporting Subsystem for Access Apps

Why would anyone want this if they have Access. The nitch for this is for very naiive users who are afraid of or won't learn enough Access to create a query to select the data they want and then use the Wizard to create their report. Of course, this add-on is very limited, rudimentary. But sometimes, that's all that is needed. And it's FREE.

It is a part of the Corp Tech Demos from Duane Hookom

http://www.invisibleinc.com/download.cfm?filFilID=7

Add-on to Existing Reports to Allow Custom Data Selection/Filtering

This FREE utility allows you to define existing reports for which the user can add additional data selection when running.

http://www.mile50.com/access/rfil/index.htm

Add-on Report Writer Suitable for Novice End-users

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH%20Query%20By%20Form'

by Duane Hookom. - FREE

This is a wonderful and EASY report generator! GREAT for users who won't learn how to use Access' report wizard.

It certainly is not as functional as Access' built in capability but might be just right for simple reports by users who are not willing to learn enough Access. Allows user to select a data source, select the fields desired, specify any selection criteria. Optionally allows multilevel groupings with totals of sums, counts, averages, maximum and minimum.

Auto Front End Database Updater - by Tony Toews

http://www.granite.ab.ca/access/autofe.htm

"This utility will automatically update the front end MDE and associated files from the server to the client workstation or directory on the server. The utility will, if required, create the directory on the workstation, copy files to workstation, create a shortcut on the desktop, common desktop or quick launch bar and update registry keys. It will then start the Access MDE. If none of this is required the next time you run this utility then all those steps are bypassed and it just starts the Access MDB."

Free Access Online Tutorials

http://www.gcflearnfree.org/Tutorials/Details.aspx?Tutorial=Access%202003&tutorialID=52

http://www.functionx.com/access/index.htm

http://itrain.org/books/honesty.html

http://www.sharewareorder.com/Microsoft-Access-Fundamentals-download-10729.htm

http://www.bcschools.net/staff/AccessHelp.htm

http://databases.about.com/cs/tutorials/

http://office.tizag.com/accessTutorial/

http://www.fgcu.edu/support/office2000/access/index.html

http://www.learnthat.com/courses/viewlets/access/index.html

At the following link, scroll down until you find "Microsoft Access Tutorials: Beginning, Intermediate, and Advanced:"

http://www.educationonlineforcomputers.com/blogs/Free_Microsoft_Office_Training_Tutorial_Resources.php

Download them onto your laptop! (Right click on each link and select "save target as" and save to a directory on your PC.

I think you can save this one to your local hard drive. It may create a directory entry and store the graphics in subdirectories

http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html

This set of tutorials is downloadable:

http://www.cob.ohio-state.edu/~muhanna_1/837/MSAccess/tutorials.html

Here is a link where you can download the Northwind sample Access database that Microsoft provides.

http://www.microsoft.com/downloads/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=EN

Run Access Reports from Web

Viewing & Printing Access Reports with ASP and/or VB - 4guysfromRolla.com - FREE

RPT Software - Report Server

Web Delivery System for MS Access Reports - $99

Access2PDF - $300

Access Reporter. NET

Free 1 yr limited functionalityLIcense cost is $599

Access Report Scheduler

MARS Report Scheduler - $495 - $1995

Comparison of versions