Re: Is this possible???
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/06/04
- Next message: mchd: "popup menu problem"
- Previous message: John Vinson: "Re: Referring to a object in a subform?"
- In reply to: Joan: "Is this possible???"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 05 Mar 2004 17:57:29 -0700
On Fri, 5 Mar 2004 15:02:09 -0800, "Joan"
<anonymous@discussions.microsoft.com> wrote:
>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.
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.
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!
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
- Next message: mchd: "popup menu problem"
- Previous message: John Vinson: "Re: Referring to a object in a subform?"
- In reply to: Joan: "Is this possible???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
