Is there an Appliance Test and Tag template for Access or Excel

I am looking to create a Data base that I can use to track customers and
there appliances, when they were tested if they pass or fail and when the
next test is due.

I would guess that you will not find a template for this very specific use.
You might use the "home inventory" template as a starting point, but it will
take a great deal of modification.

Rick B


"denis" wrote in message
...
I am looking to create a Data base that I can use to track customers and
there appliances, when they were tested if they pass or fail and when the
next test is due.

On Mon, 4 Apr 2005 05:01:03 -0700, "denis"
wrote:

I am looking to create a Data base that I can use to track customers and
there appliances, when they were tested if they pass or fail and when the
next test is due.

It should be easy enough to create this database from scratch. As Rick
says, it's much too specific and limited an application for Microsoft
to have created a template.

Why not just try it yourself? You'll need probably the following
tables: * indicates the Primary Key of the table.

Customers
*CustomerID Autonumber
LastName
FirstName
Phone
Address1
Address2
City
State
Zip
any other info about the person that you need

Appliences
*ApplienceID Autonumber
CustomerID long integer, link to Customers
TypeID long integer, link to ApplienceTypes
Make
Model
YearOfManufacture
TestInterval how often does this need testing
other info about the appliance

ApplianceTypes
*TypeID
Type e.g. Dishwasher, Espresso Machine, Tardis

Tests
*TestID Autonumber
ApplienceID long integer, link to Appliences
TestDate
Pass Yes/No
Comments text or memo

The due date can be calculated from the test date and the TestInterval
and should not be stored.

John W. Vinson[MVP]