I'm about as new to Access 2007 as one can be, so please excuse what may be and obvious question (and thank you in advance for your patience).
I've created 6 tables, which are called:
DESKTOP
LAPTOP
THIN CLIENT
PRINTER
MONITOR
NETWORK EQUIPMENT
I've already entered some information directly (no data entry form) into each table. This was done as part of a free "Introduction to Access 2007" online tutorial.
What I want to do now is create 1 Form to use for entering data into each table. This Form would have the following fields:
*TYPE
Division
Make
Model
S/N
I/P
Machine Name
I5 Session 1
I5 Session 2
I5 Session 3
Printer Session
Network Equipment
Comments
What I "envision"... what I want to do, is enter info into each of these fields. Then, based on the specified *TYPE (which is also the name of the Table that the info will placed in), I hit <enter> and the record is added to the appropriate table. I want to be able to use 1 Form to update 1 table, 1 record at a time.
The problem is that I can't find a tutorial that will walk me thru the process of creating a Form to do this. This Form doesn't have to be fancy or "graphically pleasing to gaze upon lol" (at least not at this point), so I imagine the "Create Form Wizard" would be fine. But I can't find a tutorial, and until i've done it once/a few times I can't even begin to think about creating a Form from scratch (something i'll have to do eventually).
Can somebody please point me in the right direction? Maybe provide a link(s) that walks a person thru the process of doing what I want do? Can I even do this at all?
Again, thank you for your time, patience, and help.
Joe
I've created 6 tables, which are called:
DESKTOP
LAPTOP
THIN CLIENT
PRINTER
MONITOR
NETWORK EQUIPMENT
I've already entered some information directly (no data entry form) into each table. This was done as part of a free "Introduction to Access 2007" online tutorial.
What I want to do now is create 1 Form to use for entering data into each table. This Form would have the following fields:
*TYPE
Division
Make
Model
S/N
I/P
Machine Name
I5 Session 1
I5 Session 2
I5 Session 3
Printer Session
Network Equipment
Comments
What I "envision"... what I want to do, is enter info into each of these fields. Then, based on the specified *TYPE (which is also the name of the Table that the info will placed in), I hit <enter> and the record is added to the appropriate table. I want to be able to use 1 Form to update 1 table, 1 record at a time.
The problem is that I can't find a tutorial that will walk me thru the process of creating a Form to do this. This Form doesn't have to be fancy or "graphically pleasing to gaze upon lol" (at least not at this point), so I imagine the "Create Form Wizard" would be fine. But I can't find a tutorial, and until i've done it once/a few times I can't even begin to think about creating a Form from scratch (something i'll have to do eventually).
Can somebody please point me in the right direction? Maybe provide a link(s) that walks a person thru the process of doing what I want do? Can I even do this at all?
Again, thank you for your time, patience, and help.
Joe
