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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
Click to expand...

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]
 
Back
Top