Hi

I am looking for a simple Access database template that i can use for my
beauty salon business. I need a simple query that takes a surname and brings
up a table that shows the client's personal details, their most recent
treatments and maybe some consolidated information (total number of visits
etc).

Anyone know of anything suitable?

I'm not sure about a template, but if you're familiar with Access it's not
really that hard to create something like that yourself. As long as you know
what data you need, you should be able to create a table with all the
necessary data (I'm assuming most of your data will be of either Text or
Number type).

As for bringing up data associated with a surname, this can easily be
accomplished by using the Find command; I'm fairly sure Access has a wizard
that will create a command button that will let you use Find.

If you really need a query, it's possible to do this by using a parameter
query and having the surname as a parameter. If you do this, you should use
the criteria (Like "surname"), as opposed to something like
(surname="surname").

If you're not familiar with Access, you may want to find someone who is.
There may or may not be a premade template that will be exactly what you
need, however as long as you know what you need, Access databases are
remarkably simple to create.

-Chris

"Bickie" wrote:

> Hi
>
> I am looking for a simple Access database template that i can use for my
> beauty salon business. I need a simple query that takes a surname and brings
> up a table that shows the client's personal details, their most recent
> treatments and maybe some consolidated information (total number of visits
> etc).
>
> Anyone know of anything suitable?

I would suggest the Customer Order Database as possibly being suited, with a
few modifications, to what you want:

http://office.microsoft.com/en-us/te...CT011366681033

There are a lot of fields for entering information about a customer, which
could be renamed for your particular application. An "Order" could be where
you put particulars about their visit to your Salon, and Products in that
Order could be particular brands that are used. One report, "Orders by
Customer," could be used to show customer visits.

There are some other templates. You might browse through all of them, and
see if any others would fit better (maybe without as much modification):

http://office.microsoft.com/en-us/te...359381033.aspx

"Bickie" wrote:

> Hi
>
> I am looking for a simple Access database template that i can use for my
> beauty salon business. I need a simple query that takes a surname and brings
> up a table that shows the client's personal details, their most recent
> treatments and maybe some consolidated information (total number of visits
> etc).
>
> Anyone know of anything suitable?