Table

[Jenn]

Hello,
I am a beginner and I am trying to add several pieces of software into a
table without having to type them in myself. Is there an easy way of doing
this? I have 300 employees and 11 different pieces of software. Thanks for
your help.

 

[S.Clark]

Copy and Paste? Perhaps you can describe the format the data is in, as well
as the destination table structure, and we'll gin up something better.

 

[Keven Denen]

Hello,
I am a beginner and I am trying to add several pieces of software into a
table without having to type them in myself.  Is there an easy way of doing
this?  I have 300 employees and 11 different pieces of software.  Thanks for
your help.

We'll need to know more information about your data before we can give
you a complete answer, but you will probably want to use an append
query or update query to accomplish that. If those two phrases went
over your head, give us a more complete picture of your data and we
can give you a better idea of what to do.

Keven Denen

 

[John W. Vinson]

Hello,
I am a beginner and I am trying to add several pieces of software into a
table without having to type them in myself. Is there an easy way of doing
this? I have 300 employees and 11 different pieces of software. Thanks for
your help.

Stop!

If you're thinking of putting 300 rows by 11 columns... you're missing the
power of Access.

As noted by Steve and others, you should enter each piece of software ONLY
ONCE!

Take a look at some of these tutorials (Crystal's video would 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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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