Make your own free website on Tripod.com

Utilities, Tips, Hints & Resources For MS Access

Microsoft Access Knowledge Base Articles

Click the links below to jump to the relevant section, if you are unable to find the article you need, try searching Microsoft Knowledge Base

  Links
The Basics | Sample Codes & Expressions, Examples | White Papers & Utilities | Tips & Hints | Tables & Queries | How To Accomplish a Task


The Basics

ACC2000 Database Normalization Basics (Q209534)

ACC2000 Defining Relationships Between Tables in a Microsoft Access Database (Q304467)

ACC2000 Explanation of Data Types and Field Properties in a Microsoft Access Database

ACC2002 Database Normalization Basics (Q283878)

ACC2002 Defining Relationships Between Tables in a Microsoft Access Database (Q304466)

ACC2002 Explanation of Data Types and Field Properties in a Microsoft Access Database

ACC2002 Keeping Your Information Accurate Part 1 Introduction

ACC2002 Keeping Your Information Accurate Part 2 Using the Data Type to Restrict Data

ACC2002 Keeping Your Information Accurate Part 3 Using the Field Size Property to Restrict Data

ACC2002 Keeping Your Information Accurate Part 4 Using an Input Mask to Restrict Data

ACC2002 Keeping Your Information Accurate Part 5 Using Validation Rules to Restrict Data

ACC2002 Keeping Your Information Accurate Part 6 Using a Lookup List to Restrict Data

ACC2002 Keeping Your Information Accurate Part 7 Updating Information in a Table

ACC2002 Keeping Your Information Accurate Part 8 Deleting Information From a Table


Sample Codes, Expressions, Examples

ACC2000 DLookup() Usage, Examples, and Troubleshooting (Q208786)

ACC2000 Example of Row Fix-Up in the Northwind Orders Form (Q209672)

ACC2000 Example Using a Callback Procedure with Balloons (Q209887)

ACC2000 Example Using TreeView Control Drag-and-Drop Capabilities (Q209898)

ACC2000 Examples Using the Internet Transfer ActiveX Control (Q209917)

ACC2000 FindEOM() Sample Function to Find Last Day of Month (Q210493)

ACC2000 Function to Get Date of Monday Prior to Current Day (Q210498)

ACC2000 Function to Reverse String Characters in a Query (Q210439)

ACC2000 Functions for Calculating and Displaying Date-Time Values (Q210604)

ACC2000 Sample Code for Running Temporary SQL Pass-Through Query (Q210323)

ACC2000 Sample Code to Check for Table or Query in a Database (Q210398)

ACC2000 Sample Code to Import All Database Objects (Q298174)

ACC2000 Sample Expressions to Count Yes, No, and Other Responses (Q209505)

ACC2000 Sample Expressions to Extract Portion of Text String (Q209045)

ACC2000 Sample Function to Create a Running Sum on a Form (Q210338)

ACC2000 Sample Function to Determine Current Page of a Form (Q210336)

ACC2000 Sample Function to Determine Language Version (Q210455)

ACC2000 Sample Function to Determine Windows 95-98 or NT Version (Q210200)

ACC2000 Sample Function to Format Names Several Different Ways (Q210054)

ACC2000 Sample Function to Generate a Random Temporary File Name (Q210602)

ACC2000 Sample Function to Open a Form to a Particular Record (Q210436)

ACC2000 Sample Function to Remove Alpha Characters from a Numeric Field (Q210537)

ACC2000 Sample Function to Replace Special Characters in a MDB (Q210433)

ACC2000 Sample Function to Retrieve File Version Information (Q210120)

ACC2000 Sample Function to Return a Random Record from a Field (Q210468)

ACC2000 Sample Functions to Check User and Group Information (Q210331)

ACC2000 Sample Procedure to Find the Location or Locations of a File (Q210613)

ACC2000 Sample Procedure to Link a Microsoft Outlook Folder (Q209946)

ACC2000 Sample Query to Print One Label for Two People at the Same Address (Q207753)

ACC2000 Sample Table Design to Support Questionnaire Applications (Q209493)

ACC2000 Two Examples That Use the Winsock ActiveX Control (Q209905)

ACC2000 Two Functions to Calculate Age in Months and Years (Q210522)

ACC2002 DLookup() Usage, Examples, and Troubleshooting (Q285866)

ACC2002 Example of Row Fix-Up in the Northwind Orders Form (Q291553)

ACC2002 Sample Expressions to Extract Portion of Text a String (Q286238)

ACC2002 Sample Table Design to Support Questionnaire Applications (Q292299)

ACC2002 Two Functions to Calculate Age in Months and Years (Q290190)


White Papers, Utilities

ACC Microsoft Access Knowledge Base Help Files Available

ACC Microsoft Access Security FAQ Available in Download Center (Q165009)

ACC2000 Access 2000 Sample Queries Available in Download Center (Q207626)

ACC2000 Access 2000 Upsizing Tools White Paper Available in Download Center (Q241743)

ACC2000 Conversion White Paper Available in Download Center (Q237313)

ACC2000 Deploying Data Access Pages on the Internet or Your Intranet White Paper Available on MSDN (Q253754)

ACC2000 Filter By Form Example for Run-Time Applications Available in the Download Center

ACC2000 Jet 4.0 Replication White Papers Available in MSDN Online Library (Q190766)

ACC2000 Jet Compact Utility Available in Download Center (Q273956)

ACC2000 Microsoft Access 2000 Replication FAQ Available in Download Center (Q282977)

ACC2000 Microsoft Access 2000 Sample Forms Database Available in Download Center

ACC2000 Microsoft Access 2000 Sample Reports Available in Download Center (Q231851)

ACC2000 Microsoft Access Action Query Wizard Add-in Available in Download Center

ACC2000 Microsoft Access Security FAQ Available in Download Center (Q207793)

ACC2000 Microsoft Access Security Manager Add-In Available in Download Center (Q235961)

ACC2000 Orders and Developer Solutions Sample Databases Available on the Microsoft Developer Network (MSDN) (Q248674)

ACC2000 Regsvr32.exe Available in Download Center (Q267279)

ACC2000 Understanding Relational Database Design Document Available in Download Center

ACC2000 Updated Version of Microsoft Jet 4.0 Available in Download Center (Q239114)

ACC2002 Access 2002 Upsizing Tools White Paper Available in Download Center (Q294407)

ACC2002 Configuring SQL Server 2000 Desktop Engine White Paper Available in Download Center (Q301413)

ACC2002 Deploying Data Access Pages on the Internet or Your Intranet White Paper Available on MSDN (Q286327)

ACC2002 Jet Compact Utility Available in Download Center (Q295334)

ACC2002 Understanding Relational Database Design Document Available in Download Center

ACC2002 Updated Version of Microsoft Jet 4.0 Available in Download Center (Q282010)

ACC2002 Using ADO in Microsoft Access 2002 White Paper Available in Download Center

INFO Office Developer Samples and Tools Available for Download (Q253338)

Microsoft Snapshot Viewer Available in Download Center (Q175274)


Tips, Hints

ACC2000 Debugging and Troubleshooting Tips for Linked SQL Tables (Q209489)

ACC2000 Defragment and Compact Database to Improve Performance (Q209769)

ACC2000 Hints for Printing Mailing Labels (Q209755)

ACC2000 Hints for Using the Generic Print Driver with Forms and Reports (Q209751)

ACC2000 Tips for Debugging Visual Basic for Applications Code (Q210143)

ACC2000 Tips for Improving Subform Performance (Q209113)

ACC2000 Tips for Optimizing Queries on Attached SQL Tables (Q209551)

ACC2000 Tips on How to Troubleshoot Microsoft Access Macros (Q209811)

ACC2000 To Help Prevent Database Bloat, Explicitly Close Recordsets (Q209847)

ACC2000 Troubleshooting Tips for Conversion Issues in Access 2000 (Q208645)

ACC2000 Troubleshooting Tips for Error Values (Q209132)

ACC2000 When to Use Requery, Repaint, or Records Refresh (Q209634)

ACC2002 Defragment and Compact Database to Improve Performance (Q288631)

ACC2002 Hints for Printing Mailing Labels (Q287661)

ACC2002 To Help Prevent Database Bloat, Explicitly Close Recordsets (Q289562)

ACC2002 Troubleshooting Tips for Conversion Issues in Access 2002 (Q286341)


Tables and Queries

ACC2000 How To Add a Parameter to a Union Query (Q208815)

ACC2000 How to Add an Index in an Access Database (Q304272)

ACC2000 How to Add Lookup Fields in a Microsoft Access Table (Q304463)

ACC2000 How to Append Data from One Table to Another (Q306093)

ACC2000 How to Convert a Select Query to an Action Query (Q304355)

ACC2000 How to Create a Crosstab Query in Microsoft Access (Q304348)

ACC2000 How to Create a Crosstab Query with Multiple Value Fields (Q209143)

ACC2000 How To Create a Dynamic Query to Return Records for the Previous Month

ACC2000 How to Create a Grouped Running Sum in a Query (Q205183)

ACC2000 How to Create a Make-Table Query with a Union Query (Q208819)

ACC2000 How to Create a Parameter Query in Microsoft Access (Q304353)

ACC2000 How to Create a Select Query in Microsoft Access (Q304361)

ACC2000 How to Create a Table in an Access Database (Q304262)

ACC2000 How to Create a Top N Values Per Group Query (Q210039)

ACC2000 How to Create an SQL Pass-Through Query Using Data Access Objects (Q210415)

ACC2000 How to Create and Use Subqueries (Q209066)

ACC2000 How to Create Running Totals in a Query (Q208714)

ACC2000 How to Delete Duplicate Records from a Table (Q209183)

ACC2000 How to Delete Duplicate Records in Two Tables (Q209573)

ACC2000 How to Delete Multiple Tables Quickly (Q210307)

ACC2000 How to Edit Data in a Hyperlink Field in a Table (Q208200)

ACC2000 How to Edit Records in Related Tables in a Microsoft Access Database (Q304474)

ACC2000 How to Fill a Table with Random Records from Another Table (Q210616)

ACC2000 How to Filter Records in an Access Database (Q304263)

ACC2000 How to Group Column Headings in a Crosstab Query (Q209141)

ACC2000 How to Group Row Headings in a Crosstab Query (Q208556)

ACC2000 How to Modify Query Properties in Microsoft Access (Q304357)

ACC2000 How to Optimize Queries in Microsoft Access 2000 (Q209126)

ACC2000 How to Rank Records Within a Query (Q208946)

ACC2000 How to Recover a Table Deleted from a Database (Q209874)

ACC2000 How to Recover Data from a Damaged (Corrupted) Table (Q247771)

ACC2000 How to Sort Records in an Access Database (Q304255)

ACC2000 How to Transfer Data from One Table to Another (Q209728)

ACC2000 How to Transpose Data in a Table or Query (Q202176)

ACC2000 How to Update a Table from a Second Table by Using an Expression (Q209246)

ACC2000 How to Update and Append Records in One Update Query (Q208870)

ACC2000 How to Use, and = Operators in a Query Parameter (Q209628)

ACC2000 How to Use a Query to Compare Data Among Records (Q208890)

ACC2000 How to Use a Query to Filter Unique Data (Q209793)

ACC2000 How To Use a Query to Return Every Nth Record from a Table (Q207651)

ACC2000 How to Use Greater Sign, Lesser Sign , and = Operators in a Query Parameter

ACC2000 How to Use IIf() in Crosstab to Limit Column Headings (Q208669)

ACC2000 How to Use Select Queries Without Join Lines (Q209135)

ACC2002 How to Add an Index in an Access Database (Q304266)

ACC2002 How to Add Lookup Fields in a Microsoft Access Table (Q304462)

ACC2002 How to Build a Dynamic Query with Values from a Search Form (Q304302)

ACC2002 How to Convert a Select Query to an Action Query (Q304354)

ACC2002 How to Create a Crosstab Query in Microsoft Access (Q304349)

ACC2002 How to Create a Crosstab Query With Multiple Value Fields (Q304458)

ACC2002 How to Create a Parameter Query in Microsoft Access (Q304352)

ACC2002 How to Create a Query That Has Parameters to Evaluate Complex Criteria

ACC2002 How to Create a Query That Returns Records Based on a Range of Letters in a Text Field (Q304390)

ACC2002 How to Create a Select Query in Microsoft Access (Q304325)

ACC2002 How to Create a Table in an Access Database (Q304238)

ACC2002 How to Create an SQL Pass-Through Query (Q303968)

ACC2002 How to Create Running Totals in a Query (Q290136)

ACC2002 How to Edit Records in Related Tables in a Microsoft Access Database (Q304473)

ACC2002 How to Filter Records in an Access Database (Q304259)

ACC2002 How to Modify Query Properties in Microsoft Access (Q304356)

ACC2002 How to Sort Records in an Access Database (Q304250)

ACC2002 How to Transpose Data in a Table or Query (Q283875)

ACC2002 How to Use a Query to Filter Unique Data (Q292634)

 

Microsoft Resources

MS AccessHome

/ MS Access
/ MS Access (Previous Versions)

MS AccessSupport Centers

/ Access Support Centre
/ Access 2000 Support Centre
/ Access 2002 Support Centre
/ Access Assistance Centre
/ Access 2000 Assistance Centre
/ Access 2000 Online Help
/ Access 2002 Online Help
/ SQL Server Support Centre
/ ODBC Support Centre
/ MDAC Support Centre
/ MDAC Setup Troubleshooting Guide

MS Access Download Centers

/ MS Access Knowledge Base Help Files For Download
/ Access Download Centre
/ Template Gallery
/ Access Templates

MS Access Tips and Tricks

/ Office Tips and Tricks
/ Tips and Tricks (2)
/ Access 2000 Tips and Tricks
/ Access 2000 Tips

MS AccessVBA

/ VBA Home Page

MS Access Resources

MS Access Sites

/ The Access Web
/ Apple Core
/ Allen Browne's Access Tips
/ Stephen Leban
/ Trevor MS Access FAQ
/ MS Access Help Centre

MS Access Tutorials

/ Access Tutorial
/ VB Access Tutorial
/ Access Database Tutes

MS Access VBA

/ Visual Basic Developers' Resource Centre
/ Access and VB Tools
/ ADO Connection Strings Sample
/ Programming MS Access
/ Office VBA

MS Access Newsletters

/ Woody's Access Watch

SQL

/ swynk.com
/ sqlmag
/ SQL Wire
/ mssqlserver

Copyright © 2004-2006 Windows Guides. Site Map