Hello,
Before I get to my question, let me give a background first:
I am an individual working with Microsoft Access 2016.
I am designing an access database for a 'school student management system'. This means that I have created tables and forms related to students (name, class, subjects,...) and teachers (name, subject(s) taught). The database currently has the ability to enable users to view, edit, or add new student/teacher records.
The next step I need to achieve is to expand my system so that the main user and administrator can create report cards for the students and fill in their marks. Then the report cards get saved and can be opened to be viewed or edited anytime. The users of my system are not familiar with ms access and so the only way they can work with the database is by forms.
I understand that access is a database meaning it stores data and is not designed to act as a software for generating documents such as report cards. However, I do not have the knowledge to code this management system so I saw no other choice than to work with Microsoft Access. All I know is an intermediate level of VB.
Now, my plan is to create a form called "new report cards" where the administrator can choose certain criteria such as the students who they want to create a report card for and etc.. Afterwards, I want the "new report cards" form to have a command button that, when clicked, applies the criteria to a NEW form and creates a NEW table (with the criteria as fields) as the control source. From there, the administrator can type and save the records to the new table from the new form.
I know that this is possible to do from the ribbon of ms access, but as I said, the users are comfortable with working with forms and the objects inside forms. So, to get to my questions:
1) Is it possible to have a command button open a new form with a new table as its control source?
2) If yes, can the table be created with specified criteria (specified in a form)?
3) If no to both, is there any other way to achieve this (other softwares that do not require heavy coding)?
Thank you in advance for all the help and suggestions. I have searched but have not been able to find the answer to my questions.
Also asked: https://community.spiceworks.com/top...#entry-8560881