New Page 1

The links to Access resources link above is part of the North Texas Access User's group web site.

Access Add-ins (great list)

Use VBA and COM to Access Data in a Lotus Notes Database

http://www.redbooks.ibm.com/redbooks/SG245670.html

http://www.redbooks.ibm.com/redbooks/pdfs/sg244856.pdf

Recover Passwords and user-level security info for MDBs to gain full access

http://www.thegrideon.com/access-password-recovery.html#trial

The above software allows password recovery and user-level security recovery from Access MDB file

even if the MDW file is missing!

VBA Password Bypasser

MDE to MDB conversion.

http://www.everythingaccess.com/mdeconversion.htm

Recovers all VBA code in forms, reports and modules.

Unlock forms and report designs in MDEs

http://www.everythingaccess.com/mdeunlocker.htm

The MDE unlocker unlocks the form and report design so you can make changes to the form design and layout.

You still cannot access the VBA code behind which still works. But you can specify macros to run for

Events and put new logic in there.

Another option gives you unlocked forms and reports with all the VBA code removed. YOu can then

copy the form to a MDB and have full ability to add VBA logic.

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://office.microsoft.com/en-us/access/HA011189511033.aspx - Microsoft's own training - FREE - Access 2003

http://office.microsoft.com/en-us/training/HA102744471033.aspx - Microsoft's own training - FREE - Access 2007

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

http://access-databases.com/ebook/

http://www.aadconsulting.com/access_training.html

Free Access VBA course - with videos

Utter Access forum Access tutorials

Note you may have to register (free) to access the tutorials topic in the forums

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

http://www.datapigtechnologies.com/AccessMain.htm

Relational Database Design Tutorials/Articles

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041]Database
planning tutorial Part I
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586]Database
planning tutorial Part II
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932]argeedblu's
FAQ on Design Strategies
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208]Noah's
FAQ on Normalization
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=197282]Jerry's
FAQ on Normalization
http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf]GroverParkGeorge's
PDF on Normalization
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=210717]Jerry’s
FAQ on Fully Qualified Naming
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=213518]Jerry's
FAQ on Glossary
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=539419]Danny's
FAQ on Reserved Words
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604]Autonumbers
- What They Are / Are Not
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=637301]Primary
Keys - Natural vs Surrogate
http://support.microsoft.com/kb/q173738]Naming Conventions - Hungarian
Notation
http://www.utteraccess.com/forums/showflat.php?&Number=1220772]Crystal's
ACCESS Basics for Programming
http://www.datamodel.org/NormalizationRules.html#one]DataModel.org:
Rules of Data Normalization
http://support.microsoft.com/kb/283878]MSKB 283878:  Description of
the database normalization basics
http://www.mvps.org/access/lookupfields.htm]  The  Evils of Lookup
Fields in Tables

See the serries of articles in this blog http://argeedblu.blogspot.com/
discussing the intial design process for an ice cream sundae database.

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 functionality - serve up 3 reports

Full LIcense cost is $599

Access Report Scheduler

MARS Report Scheduler - $495 - $1995

Comparison of versions

Access vs. Excel for Databases

http://office.microsoft.com/en-us/help/HA010429181033.aspx

http://www.workplacelife.com/2006/04/27/access-vs-excel-when-to-use-access/

http://www.workplacelife.com/2006/05/09/access-vs-excel-when-to-use-excel/

http://ezinearticles.com/?Sibling-Rivarly?-Microsoft-Access-versus-Excel&id=197440

http://www.katsueydesignworks.com/databases.cfm