Is this possible???

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

Hi!

I've got an access database that I've created for my small
office in an effort to be more effective in taking care of
our customers. I've got a form, that the user enters all
information required to setup an account and schedule the
customer's service. I need to generate service reports
from this information and would like to be able to do this
without re-entering a lot of information. I've come up
with the following idea but do not know, if it is too
complex for Access.

Would it be possible to have another form filled in
according to the information in the first form. I would
need the information put on the next form according to the
Customer ID, Week of Service (1-4), Type of Service
(Summer, Winter, Annually), and then the Type of Service.
On the Second report information would be grouped by the
Customer Id and then broken down into individually weeks
and type of service. There can be more than one set of
information per type of service so I need to be able to
build on the form. For instance, if a information has
already been placed in text box 1, then the information
needs to be put in text box 2, and so forth.

Is Access able to do this??? Or is there another way to
accomplish the same thing??? Any advice that can be given
will be greatly appreciated! Thanks!!
 
Hi!

I've got an access database that I've created for my small
office in an effort to be more effective in taking care of
our customers. I've got a form, that the user enters all
information required to setup an account and schedule the
customer's service. I need to generate service reports
from this information and would like to be able to do this
without re-entering a lot of information. I've come up
with the following idea but do not know, if it is too
complex for Access.
Click to expand...

It's what Access was written to do.
Would it be possible to have another form filled in
according to the information in the first form. I would
need the information put on the next form according to the
Customer ID, Week of Service (1-4), Type of Service
(Summer, Winter, Annually), and then the Type of Service.
On the Second report information would be grouped by the
Customer Id and then broken down into individually weeks
and type of service. There can be more than one set of
information per type of service so I need to be able to
build on the form. For instance, if a information has
already been placed in text box 1, then the information
needs to be put in text box 2, and so forth.
Click to expand...

But you're starting AT THE WRONG END.

Access is a relational database. The foundation, the ESSENTIAL part of
the database, is your Tables. It really sounds like you're starting
your design with the Forms and the Reports; this is like starting
building a house by assembling the windows and the roof soffits, and
then deciding where to put the foundation.

Your first step should be (and maybe it was, but you don't say) to
create a set of normalized Tables. If you don't know what "normalized"
means... learn; you can start at

http://support.microsoft.com/?kbid=209534

Forms are just windows that allow you to enter data into the Tables;
you would then create Queries to pull data from multiple tables
together for display on a Report. Once a given piece of data is
entered it will never need to be entered again, if you have the tables
set up correctly!
 
Back
Top