RE: I have another question. Sorry.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you so much for the info, I really appreciate it. I am really new and
a lot to learn

--
Christi Lee


"Fred" wrote:

While there are a lot of details (some of which only you know) to implement
this, here are a few thoughts to guide it.

First if you haven't done so already, start by defining the nature and
structure of the information that need to be databased. Then define tables
and data definitions / rules for data in the tables. Get help from this
forum if needed. The make sure everything that goes into those tables meets
those rules / definitions. This includes anything that is placed into your
tables via importing.

Generally you want to get valid data in as soon as you can. If you have any
uses of your data where you don't want to look at the newest entries, then
have a field (with entry date or somehting) which lets you selectively "hide
them" e.g. via a query criteria.

Finally, you mentioned "there is still a lot I have to do before I turn it
over to
the company like queries and forms etc." Anything involving
calculating/summarizing.presenting data in Access is designed once (reports,
queries, forms etc.) and then should take only seconds of your time to "do."
Of course, if they are placing other requirements on how you give it to
them (bound in leather, hand carved in wood etc. :-) ) that will take
you time, but those are off-line work and not a DB question.




.

Relevant Pages

  • Re: Check boxes and union queries
    ... You might want to provide and explain your SQL of the queries. ... MS Access MVP ... then all the entries that are not checked come ... > My second query uses the first query as a union - I want ...
    (microsoft.public.access.queries)
  • Re: Best way to sort arrays
    ... last entries ... In the first solution I use 2 extra queries and in the last soution I ... Could you not cut out the first query? ... If ordered backwards, start from the last key and ...
    (comp.lang.php)
  • Unmatched Query Wizard
    ... entries in 2 different tables. ... for other queries, 'Is Null' criteria works fine. ... field 2 [assigned tasks] ...
    (microsoft.public.access.queries)
  • 2003 - Address Book
    ... How can I make the address book include all contacts entries, ... Failing that, is there a quick way to enter a dummy email address into the empty ... Checked by AVG anti-virus system. ...
    (microsoft.public.outlook)
  • RE: I have another question. Sorry.
    ... their updates and give them to me at the end of the day so I can input them? ... "Christi Lee" wrote: ... Once I get all of the information imported from excel into the ... the company like queries and forms etc. ...
    (microsoft.public.access.tablesdbdesign)