New to Access please. I created all the tables I need how to merg

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nike - 04 Oct 2007 22:23 GMT

I am a new to Microsoft Access and I need assistance with merging my tables.
I created 3 tables using the wizard but I don't know how to merge them and
what next to do in order to enter my date and see the whole database working.
I am not sure if I have to go into query then forms etc.... PLEASE HELP
THIS NEWBIE. I appreciate your assistance in advance.

Thanks

nike

Reply to this Message

John W. Vinson - 04 Oct 2007 22:36 GMT

>I am a new to Microsoft Access and I need assistance with merging my tables.
>I created 3 tables using the wizard but I don't know how to merge them and
[quoted text clipped - 5 lines]
>
>nike

You won't need to - or want to - "merge" your tables.

Since we have no way to know how your tables are structured or related, it's
hard to give specific advice; but as a rule one would use a Form based on the
"one" side table of a one to many relationship, with one or more Subforms
based on the "many" tables.

Take a look at some of the tutorials here:

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]

Reply to this Message

nike - 05 Oct 2007 14:32 GMT

THANKS A LOT JOHN, for the resources. God bless you.

Signature

nike

> >I am a new to Microsoft Access and I need assistance with merging my tables.
> >I created 3 tables using the wizard but I don't know how to merge them and
[quoted text clipped - 28 lines]
>
> John W. Vinson [MVP]

Reply to this Message