Can Access be used for..... Newbie Here!

[AllieEm]

Many years ago I used access on a regular basis for a billiard tour I used to run. It worked excellent for what I needed it to do. Many years later I have come across a situation at my work that I think Access would be great for. Before re-educating myself as it has been a loooooong time, I have a quick question and was hoping an Access user can tell me if it is possible.



Here's my scenario.

I have 60 people who each have to fill out twelve forms with names and addresses along with some other personal information with answers that come from an interview. Currently when a person comes in, I fill out the forms online as they are saved as fillable PDF forms. Each form requires me to re-enter the name and address before completing the other fields. I would like to enter their information once and have it fill in all twelve forms to save time. Isn't this something that Access can handle? If so, is there a name for it, (type/style) so I know where to go play and re-learn?

Thanks in advance for any help or guidance you can give to me.

[ranman256]

Yes, this is how access works. you enter the data once into the master record in tPersons.
This table will create a KEY field (autonumber) to represent that person.

Then use a sub table/subform to enter other things about them. The key field is used here-on. Not the entire data of the person.