Need help with Access please

[dideroch]

I am fairly new to Access and I have been given the assignment to make a database for Interns in our church. How would I go about making one for Applicants, and then Interns? There will be common information shared between the Applicants and the Interns as they are going to be one in the same if accepted as an intern. How would I transfer information over from an applicant status to being accepted as an intern? Any information would be helpful. I have tried to make some tables and forms with some of the information necessary but am having a hard time sharing common information with both. Thank you so much for your time...

[TheShabz]

You should have 2 tables. One called Applicants, One called Interns. Both tables will have the same field names but Applicants will have an extra field called Status. Your status field will default to whatever value you want when your Applicant signs up. It will then be changed via a form and Update Query to another value signifying that the applicant has been accepted. Then, nightly/weekly/whenever you will run an Append Query to add the Applicants with the Status of accepted to the Interns table followed by a Delete Query to remove them from the Applicants table.

Hopefully that's what youre looking for. If you want someone to create it for you, I'm sure there are many people here who make databases for a living. I'm sure they could use the business, my broke college-student self included.