databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access Samples & Download Files

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.

Microsoft Access Downloads

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 -
Tested in Access 2000, XP and 2003

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
Tested in Access 2000, XP and 2003

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.