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

[Guest]

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.

 

[Rick B]

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

 

[John Vinson]

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]

 

[Aaron Falzon]

Hi,

Did you manage to make a database? I am looking to do the same.

Regards,

Aaron