I have another assignment I'm going to complete before releasing the first Access 2007 Basic 1 course. It's another intermediate/advanced seminar, based on a request from an Access Insider Circle member (see, they get all the preferential treatment).

This seminar will deal with tracking WORK ORDERS in Access. The customer runs a property management company that has to deal with work orders for multiple properties. They have to track each property, any work done at the property, billing, scheduling, and so on. I'm going to make the seminar generic, however, so that it will work for ANY business type.

Here's what I'm going to track so far:

- Customers
  - Multiple Locations (properties or offices)
    - Multiple Units (apartments or even office numbers)

- Work Orders
  - Multiple Categories (plumbing, heating, electric, etc.)
  - Labor performed (dates, times, billable hours, etc.)
  - Materials used

- Workers
  - Can be either employees or contractors
  - Scheduling of labor

- Billing
  - Invoices (with parts/labor details)

If there is anything else you can think of that I should throw into this seminar, let me know. I've already started on the basics, but there's always room to add more stuff (you know me, once I get going...)

I'm NOT going to cover topics that I've covered elsewhere. For example, I'm not going to cover security inside the database (keeping people out of certain areas), making a calendar that looks like a calendar, or complicated inventory controls - because I've covered these topics in other lessons and seminars.

I hope to have this done by the middle of next week, so get your comments to me NOW. Post them here, please.

Subscribe to Another Access Seminar: Work Orders
Get notifications when this page is updated