which template for access 2003?

[Guest]

I need a template that is similar to the Time & Billing one, but has more
fields. We are a photography studio. Each of us (photographer, marketing
person, graphic artist, receptionist) all get percentages of the customer's
orders.
Is there a db out there that will deal with the customer orders and break
down who gets paid what according to our percentages? There are many
products, too, like wallets, 8 x 10's, 5 x 7's etc. Thanks in advance to
anyone who can help!! ~Gina

 

[John W. Vinson]

I need a template that is similar to the Time & Billing one, but has more
fields. We are a photography studio. Each of us (photographer, marketing
person, graphic artist, receptionist) all get percentages of the customer's
orders.
Is there a db out there that will deal with the customer orders and break
down who gets paid what according to our percentages? There are many
products, too, like wallets, 8 x 10's, 5 x 7's etc. Thanks in advance to
anyone who can help!! ~Gina

Well... your expectations about templates may be unrealistic.

A template is not intended as a finished, customized working application for
your particular business. It's a *template* upon which you can build. If you
need more fields, open the database; open the tables in design view; add the
fields that you need; revise the queries, forms and reports appropriately.

As for the products, you need a Products table with one record per product; if
you're thinking that you need one *field* per product, stop, step back and
learn about "Normalization". Here's some references which might help.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]