Database

[mshort]

I would like to create a database that includes the following:

Name
documents needed


check box once documents are submitted
able to pull a report of names of people still missing documents and documents that are missing.

Is this something that can be done in access?

Thank you

[RayMilhon]

Maybe, but your description is insufficient to give you a real answer.

[mshort]

Database would include a students name, also whatever requirements the student may have such as high school diploma, birth certificate and social security card. What I would like to do is be able to indicate when the documents are submitted. Also run a report to see if any students are missing any information.

[RayMilhon]

This absolutely can be done in Access.

First read up on normalization.

Secondly if the required documents are the same for each student you would have a Student Table-Specific to that students demographic info
Documents table-A list of each document, ID number, Document Description, Required

Finally a linking table that links the students to the documents

StudentID
DocumentID

Then you would have a query something like

Select Studentdemographicsfields, documentfields
From tblstudents Inner join studentdoclink on tblstudents.studentid = studentdoclink.studentid left outer join documents on studendoclink.docid = documents.docid
Where documents.docid Is Null

That would give you all students that were missing documents and which ones they're missing.

[RayMilhon]

Oops. That's the wrong query. A little to quick on the typing and not enough thought. You're query would be more complicated than that as you need all of the documents. And then those members that were not matching. That would take more thought. I'll try and post back a little later.