Here you will find Microsoft Access Database examples and sample files available to download. These files are intended to demonstrate particular examples and functionality available within the Microsoft Access development area.
All files are zipped using WinZip and are created in Microsoft Access 2000 unless otherwise stated, they should also operate using Microsoft Access 2002 (XP) or Microsoft Access 2003.
4TOPS
Mail Merge for Microsoft Access
The easy solution to create Microsoft Word, Excel, Email or PDF documents
from data in your MS Access database. Documents of any level of complexity
can be created easily (contracts, invoices, reports). Supports email
mail merge, labels and envelopes, directory reports and listings.
Free Trial Version available to download.
Help
Generator for Microsoft Access
Without doubt Help Generator for Microsoft Access is the fastest and
easiest way to add Help and documentation to your Access database.
It generates all files (HTML, images, help project files) and automatically
integrates the help with the database. Includes WYSYWYG help editor.
Free trial.
Excel
Import Assistant for Microsoft Access
Import data from Excel to Access. This solution puts you in complete
control. 4TOPS Excel Import Assistant is an Access add-in for importing
excel into access in a controlled way. Free Trial Version
available to download.
SQL
Query Tree Editor for Microsoft Access
An indispensable MS Access add-in for developers who use queries as
the core of their applications. Create queries using SQL templates,
edit your SQL queries in a superior query editor. Keep track of the
dependency relations between queries. Free trial.
4TOPS
Import Validate
Import Validate helps you import any data, including Excel files,
into your database. Use this software when other ways of importing,
such as import tools available with your database or SQL queries fail
because of problems with the data to import, or if you want to verify
the records you are importing. Free Trial Version available
to download.
Topic | Date Submitted | Downloadable File |
---|---|---|
Example of Many-To-Many
Relationships Access 2000 Version (File available for download) |
16/11/2002 | [44 KB] |
Example of creating a Login Form Access 2000 Version (File available for download) |
08/01/2003 | [33 KB] |
How to create a simple text search
facility Tested on Access 2000 and XP (File available for download) |
28/01/2003 | [37 KB] |
Example of creating a Start-Up
Form Access 2000 Version (File available for download) |
02/03/2003 | [23 KB] |
Example of using the Common Dialog
API in an Access Database Access 2000 Version (File available for download) |
10/04/2003 | [36 KB] |
Example of opening Microsoft
Word documents from an Access Database Access 2000 Version (File available for download) |
26/04/2003 | [41 KB] |
Where can I see some
sample forms/reports/queries etc? Various Access Versions |
08/08/2003 | [See Page] |
Filtering the results of a query
using a Drop-Down combo box Tested on Access 2000 and XP |
20/08/2003 | [27 KB] |
Sending E-Mails From Microsoft Access
Tested on Access 2000 and XP |
01/09/2003 | [44 KB] |
Generating
a List from Microsoft Access System Table Tested on Access 2000 and XP |
24/10/2003 | [62 KB] |
Filter one combobox based
on another combobox selection Tested on Access 2000 and XP |
31/10/2003 | [28 KB] |
Automatically
Increment a Fields Value Tested on Access 2000 and XP (File available for download) |
06/01/2004 | [52 KB] |
Using a Microsoft Access
Listbox to pass criteria to a query Tested on Access 2000 and XP (File available for download) |
16/02/2004 | [28 KB] |
Searching Records using
a Microsoft Access List Box Tested on Access 2000 and XP |
26/02/2004 | [44 KB] |
Sorting Columns in a Microsoft
Access Listbox Tested on Access 2000 and XP |
27/02/2004 | [44 KB] |
Filter to only view Current
User's Records in a form or query Tested on Access 2000 and XP |
03/03/2004 | [35 KB] |
Viewing a Live Web Site
on a Microsoft Access Form Tested on Microsoft Access 2000 and XP |
06/03/2004 | [32 KB] |
Using an Option Group
to Filter Records Displayed in a Form Tested On Microsoft Access 2000 and XP |
24/03/2004 | [32 KB] |
Sorting Report Fields on the
Fly Tested on Microsoft Access 2000 and XP |
30/03/2004 | [36 KB] |
Checkboxes and using the
Triple State Property Tested on Microsoft Access 2000 and XP |
10/05/2004 | [28 KB] |
How to use the Not In List event
of a combo box Tested on Access 2000, XP and 2003 |
23/06/2004 | [30 KB] |
Preventing Duplicate Records from
being entered via a form Tested on Microsoft Access 2000, XP and 2003 |
28/07/2004 | [86 KB] |
Popping Up Reminders in Microsoft
Access Tested on Microsoft Access 2000, XP and 2003 |
12/08/2004 | [17 KB] |
Stop mouse wheel from scrolling
through records in a Microsoft Access form Tested on Microsoft Access 2000 |
01/09/2004 | [50 KB] |
Printing the Record
on the Form to a Report Tested in Access 2000, XP and 2003 |
08/11/2004 | [20 KB] |
Date Parameters for
generating Microsoft Access Reports Tested in Access 2000, XP and 2003 |
14/12/2004 | [34 KB] |
Automating Archiving
Records in Microsoft Access, using Append and Delete Queries
Tested in Access 2000 and XP |
30/03/2005 | [52 KB] |
Showing or Hiding Microsoft
Access Subforms Tested in Access 2000 and XP |
04/04/2005 | [31 KB] |
Sending E-Mails from
a Microsoft Access Form Tested in Access 2000 and XP |
25/05/2005 | [38 KB] |
Grouping Data in a Microsoft
Access Report Creating a Report to Group Data by Age
Ranges - |
29/06/2005 | [33 KB] |
Alternating Report
Group Colours in a Microsoft Access Report Tested in Access 2000, XP and 2003 |
10/08/2006 | [33 KB] |
Displaying an Image in a Microsoft
Access Form Tested in Access 2000, XP and 2003 |
19/09/2006 | [238 KB] |
Using the Combo Box's
NotInList event with multiple fields Tested in Access 2000, XP and 2003 |
21/11/2006 | [69 KB] |
Creating a Microsoft Access Splash
Screen Tested in Access 2000, XP and 2003 |
08/12/2006 | [101 KB] |
Passing Multiple Parameters
to a Microsoft Access Form Using the OpenArgs parameter
of the DoCmd.OpenForm object |
13/03/2007 | [90 KB] |
Password Protecting A Microsoft
Access Tab Control Tested in Access 2000, XP and 2003 |
17/07/2007 | [40 KB] |
Changing Themes in Microsoft Access 2003 Tested in Access 2003 |
08/12/2007 | [36 KB] |
If you can't find the example database that you are looking for above, why not check out the BlueClaw MS Access Example Downloads. These downloadable database examples contain all the code, tables, queries and forms you'll need to implement each programming task.