small business template

[Guest]

I am looking for a template in Access 2000 that will help me track labor,
sales, expenses etc. All the things that a small restaurant and
entertainment facility would need. Yet, none of the templates I have looked
at seem to fit. I am admittatly a semi-rookie with Access so any help
offered is appreciated.

Thanks,
Patty

 

[strive4peace]

Hi Patty,

have you looked at the templates for Access 2007?

here is a link to some business templates on-line:
http://office.microsoft.com/en-us/templates/CT101428241033.aspx

even if you start with a template, you will still need to understand ata
structure

to help you understand Access a bit better, send me an email and request
my 30-page Word document on Access Basics (for Programming) -- it
doesn't cover VBA, but prepares you for it because it covers essentials
in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Larry Linson]

I am looking for a template in Access 2000 that will help me track labor,
sales, expenses etc. All the things that a small restaurant and
entertainment facility would need. Yet, none of the templates I have
looked
at seem to fit. I am admittatly a semi-rookie with Access so any help
offered is appreciated.

That's a pretty tall order for a free template. The only ones who have a
business model that justifies creating templates is Microsoft, who use them
to promote use of the product. But, given the nature of templates, they are
not a salable item that will provide a good ROI for anyone else. And, they
are enough more work that people who freely provide samples or examples,
just provide the database that you can modify -- not a
lead-the-user-through-the-choices approach to setting up an application

There's a company that sells an Access-based application for running a small
business, though you'd have to determine whether it is applicable to your
type of business... http://www.databasecreations.com.

Most financially-oriented people I know think that the commercial accounting
packages for small business are a pretty good buy. Unless your time is
worth next-to-nothing, your investment in learning Access and creating even
a simple application of this kind will far outweigh the price of the
commercial packages. MVP Tony Toews has some comparisons at his website
http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP