Help Needed

[vkmarty]

Greetings all,



I am rather hopeless when it comes to anything but the very basic functions of Access, so I'm really hoping some fine young mind looking for a small challenge will be able (and willing) to help me design a database!

As I'm on a pension I can't afford to buy the dedicated software to do what I want, so Access seems the next choice.

I'm wanting to track appliance testing & tagging. Basically need to log customer details, list of appliances they have that need testing, and ongoing details of the periodical tests (pass/fail). I can create the tables for the info, and the basic forms to enter new customers, new testers and new appliance types, but that's about my limit as the list of customer appliances and the periodical testing would need links and lookups, etc, which is where I get lost!

The dedicated test & tag software down under costs several hundred dollars, which I simply don't have, and I'm trying to use the test & tagging to help make ends meet and this would make tracking tests much easier.

If someone can help me, please contact me off list and I can advise exactly what needs to be tracked. I can be emailed vk2qh@yahoo.com.au

Thanks in advance and I hope some young mind will be charitable enough to help a pensioner!

[orange]

There are free data models at www.databaseanswers.org

I think this one may apply (or be applicable with modification) to your situation.
http://www.databaseanswers.org/data_...pair/index.htm