Re: Please

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Fri, 22 Aug 2008 11:10:14 GMT, "eberhane via AccessMonster.com"
<u45655@uwe> wrote:

Thank you for your advice.
I will use tables instead forms. Here is my question, If I decided to create
six tables, can you please tell me how can do that? There are some columns
that can appear in all tables. But some columns are unique to each department.
If I create six tables they probably have 4 or five same columns in each
table. Once user enter data on each table, the entered data should go to one
table where the manager/admininstrator can see.
Thank you for your assistance

You really need to do some study to learn how relational databases work! I'll
post some good resources below.

You need to "Normalize" - identify the Entities (real-life persons, things or
events) of importance to your application; each kind of Entity gets its own
table. Some tables may be shared among all the users, some unique to a user -
since your administrator needs to see everything, all the tables should be in
the common shared "backend" database. You might have one of the (usually rare)
cases where one-to-one relationships are appropriate. You haven't said
anything about the nature of the data in these tables so I can't really advise
in detail.

Check out the tutorials and resources here; Crystal's tutorial might be a good
place to start:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Contact Info/ Phone Log for Families K -12
    ... If the OP wishes to get a database up and running as soon as ... Here's some links to free resources that may give you a start. ... Allen's tutorials should give you an overview of how to proceed. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.gettingstarted)
  • Re: tutorial, books
    ... Jeff Conrad's resources page: ... A free tutorial written by Crystal (MS Access MVP): ... MVP Allen Browne's tutorials: ... mailing list, see Idaho Code 9-348"). ...
    (microsoft.public.access.gettingstarted)
  • Re: I think I need a tutor
    ... The current project is to enter the data from a stack of questionnaires ... Access resources and tutorials: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.tablesdbdesign)
  • Re: tutorial, books
    ... would like to set up a data base for dallas, ... Jeff Conrad's resources page: ... A free tutorial written by Crystal (MS Access MVP): ... MVP Allen Browne's tutorials: ...
    (microsoft.public.access.gettingstarted)
  • Re: CAN ANYONE HELP!
    ... You might want to check out some of these tutorials for how to use databases: ... The Access Web resources page: ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.tablesdbdesign)