Good evening: I'm a long-time lurker of the list, but, unfortunately, haven't been able to find the information I've been needing for the longest time.
Almost two-years ago, I created a business performing computer repair services for residential and small business clients. Now that the customer base has grown, I'm looking for ways to be able to keep track of a lot of service-call data. Preferably, to have this information instantly available should I receive a phone call from one of my beloved customers with an inquiry as to what was done, if their systems are compatible with certain products, etc. Basically, I'm looking to keep track of the following: 1. General customer information (name, address, contact info). I'm assuming this would be in a "Customers" table. 2. Maintain system information... The specifications on each of my customer's computer systems. 3. Invoice information such as: parts that were sold to the customer (keeping track of which vendor I purchased the part(s) from and the vendor's order number), work performed during the specific job. 4. Accounts receivable (amount charged to customer, amount paid, payment method, late payments, etc). 5. General accounting: profit, expenses, taxes collected, etc. Could someone please point me to a template that may already be in existence that handles this type of request, or guides that would walk me through creating these tables, establishing the relationships, forms and reports? Thank you so much for your assistance!
