Help creating database and forms.

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

Guest

Hi!
I'm new to using Access and need help. I would like to create a form that
my sales reps can enter their request into. That form would include: Rep Id,
IAC, Pounds, Pt#, 1e#, Ht#. I want to be able to go into this database and
process their request and post it back to them with a Status Field, Submit
Date Field that I would update(but I don't want them to be able to enter into
those fields). This could be another form if it has to be, I just don't want
them to be able edit it.

I also would like to create another form that is probably linked to the form
I post to so they can search for by either the Part # or Heat # to pull up
all records matching their request.

Is this possible or am I just doing some wishful thinking??
 
You need to create a data structure (tables) first, then some forms for data
entry/display, then reports to summarize your data. For a starting point,
look at the Inventory Control template that ships with Access, and look at
the Northwinds sample database for further ideas.
-Ed
 
Back
Top