Desert Code Camp
Microsoft Office Track
Links and Files

 Access template: Before you write any code 

Tom van Stiphout

Access options (e.g. Name AutoCorrect)

http://allenbrowne.com/bug-03.html

Reattach BE: The Access Web

 http://access.mvps.org/access/tables/tbl0009.htm

Smart Indenter

http://www.oaltd.co.uk/Indenter/Default.htm

MZ Tools

http://www.mztools.com/v3/mztools3.aspx

V-Tools

http://www.skrol29.com/us/vtools.php

TM VBA-Inspector

http://blogs.office.com/b/microsoft-access/archive/2010/09/30/enhance-the-quality-of-your-vba-code.aspx

Document Access Databases and Excel Workbooks 

Crystal Long

My Analyzer... the ultimate Data Dictionary Tool

http://www.AccessMVP.com/strive4peace/Dictionary

Access Wiki: code to DOCUMENT the SQL stored for each QUERY, document source for FORMS and REPORTS, query that lists the Tables, Queries, forms, Reports, Macros, and Modules in your database.

http://www.utteraccess.com/forum/Code-Document-Sql-Acces-t1251569.html

ListFiles Tool

http://www.AccessMVP.com/strive4peace/DB_ListFiles

Accessing detailed file information provided by the Operating System by Wayne Phillips

http://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System

Document Excel workbooks

        http://www.AccessMVP.com/DesertCodeCamp/DocumentWorkbookFormulas__XLS.zip

Drawing and Animating with PowerPoint 

Kathy Jacobs
Crystal Long

Presentations on Kathy’s skydrive

https://skydrive.live.com/?cid=2982be177785604c&Bsrc=EMSHYH&Bpub=SN.Notifications&id=2982BE177785604C!204#!/view.aspx?cid=2982BE177785604C&resid=2982BE177785604C!235

PowerPoint FAQ

        www.pptfaq.com

 Excel Formulas, Functions and Common Equations 

Chris “Smitty” Smith
Crystal Long

Common Excel Functions

        http://www.AccessMVP.com/DesertCodeCamp/excel_CommonFunctions.JPG

Excel Function List

        http://www.AccessMVP.com/DesertCodeCamp/Function Dictionary__XLS.zip

 Fuzzy string comparisons in Access or SQL Server 

Tom van Stiphout

Soundex

http://allenbrowne.com/vba-Soundex.html

Article about Simil, an algorithm to look for similar strings

http://accessmvp.com/TomVanStiphout/Simil.htm

YouTube video tutorial: Access Utilities: Simil Fuzzy String Matching by Tom van Stiphout ~ VBA ~ English, Dutch, French

        http://www.youtube.com/watch?v=IiAorWbrpzQ

 Learn VBA for Microsoft Office 

Crystal Long
Chris “Smitty” Smith

Learn VBA

http://www.AccessMVP.com/strive4peace/VBA

Using OneNote to document code changes 

Kathy Jacobs

Downloads

 Word Style Sheets 

Crystal Long

http://www.AccessMVP.com/DesertCodeCamp/Word_Style_Sheet_Basics~Crystal~Nov2011__DOC.zip

SPEAKER Websites

Tom van Stiphout www.AccessMVP.com/TomvanStiphout

Chris “Smitty” Smith http://SmittyPro.com

Crystal Long www.AccessMVP.com/strive4peace

Kathy Jacobs http://vitaminch.com/blogs/