Need to correct or add data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am really green here, only my second day!!!
I have imported inventory into a table. The table consist of 8 fields but I
only imported 3. I have a catalog to input the rest of the information. Can I
look up the item number, which was imported, and correct or add the rest of
the information?
 
laura03,

You certainly can do what you want to do. You can simply place your cursor
in the desired column in your table and then select the Find option, enter
the value you want to find and click OK.

With that said, you really need to know that in Access as opposed to Excel,
tables are really not intended to be the place where you interact with the
data, only to store the data. You would normally use a form to interact with
the data.
 
You did not indicate which version of Access you are using, but for a hint,
try to create a new form and select the Form Wizard. Just follow the steps
in creating the form.

This would be a good place to start, however, just FYI, there are many other
things that you can do with forms and even macors or VBA code behind the form
that will assist you and other that use your database. Don't worry about any
of that at this time, but I just thought I'd plant the thought in your mind.
 
lauras03 said:
Would I build a form for this task? Could you give me some idea how
to do that?
Click to expand...

From the sound of your expertise level, complete your update work, and then
look into the Forms separately. If you try to do both you'll end up
confused. A form is just a special screen that will take your data and
enter it into the table for you. Same as you're doing manually.

Pop`
 
Back
Top