Home Up Killifish Angelfish AquaticPlants Dallas Area Computer Volunteer United Way / NonProfit FREE Software Information & Referral Database Sharepoint 2010 beta test environment Donor Management and Fundraising Introduction CMBHS Problems and  Issues Government CARS  Program- Cash f Volunteer Management Software Nonprofit Case Management Softwa Nonprofit Food Pantry Software Outcomes Aquarium AccessDB Computer - Miscellaneous

 

Web Development

Access 2002 Software Utilities

Free Access Online Tutorials

NOT Free Access Online Tutorials

Sample Access Databases

Run Access Reports From Web

Access Report Scheduler

Access Corruption - Best Single Web Site of Information

Cimaware.com - vendor for AccessFix Database repair utility

DB Explorer 2.2.2 - compare two databases and synchronize them

Shell and Wait

Access vs. Excel for Databases

Top 5 Access Books for Beginners

Access books

Links to Access Resources

            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

bullet

Archives e-mail contents to Access 2000 table

bullet

Saves attachments as Windows files

bullet

Access table of attachments tied to messages

bullet

Hyperlinks to attachments

bullet

Handles embedded messages - messages attached to messages.  These can be nested.

bullet

Does not handle OLE items in an Outlook message, which Outlook stores as an attachment.

 

Archive Lotus Notes E-Mail Messages & Attachments

bulletSimilar features to the above.

 

 

Access Database Monitoring & Backup

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

IT Project Status Tracking and Reporting

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

Cross Reference Access Tables and Queries

bulletGenerate a where used list for tables and queries
bulletStep 1 - select the Access DB - browse to it
bulletStep 2 - One time extraction of the where used data
bulletStep 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

bulletShows end object and all queries & tables used in a tree structure like indented structure
bulletQueries, 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

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

 Job Search Contacts Database

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

I.S. Budget Development System

bullet

Allows for entry of the proposed new budget for controllable accounts for each combination of cost center and account. 

bullet

For each new budget entered, supporting detail can also be entered. 

bullet

On-line review and update as well as a variety of reports can be produced.

bullet

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

bullet

 Assists in controlling budgets by improving ability to accurately forecast expenditures for specific cost centers and accounts.

bullet

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

bullet

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.

bullet

The latest version also lists new fields, deleted fields and automatically applies changes (where permitted by Access).

 

Context Sensitive HELP System using Access Form

bullet

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.

http://www.gladstonesolutions.com/features.aspx

Gladstone Report Wizard for Microsoft Access

$299

 

 

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.functionx.com/access/index.htm

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

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

Utter Access forum Access tutorials

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

 

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

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

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

http://www.blueclaw-db.com/

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm

http://office.microsoft.com/en-us/training/CR006182940.aspx

http://www.youtube.com/playlist?list=PL1B2705CCB40CA4CA&feature=plcp

 

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.

 


 

This set of tutorials is downloadable:

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



 

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

http://www.about-access-databases.com/

 

Database design basics:

http://office.microsoft.com/en-us/access-help/database-design-basics-HA010341617.aspx?0946

 

 

 

NOT Free Access Online Tutorials

http://www.lynda.com/

 

 

 

Sample Databases

http://www.rogersaccesslibrary.com

 

 

 

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