问题描述
您好，我是一名会计专业学生，但我需要一个学校项目的会员数据库，我不知道如何积累不同年份的数据，所以我想尝试使用他们加入的一年中的字段来过滤它。
将要求用户输入学生编号，联系方式和其他基本信息，以及该会员加入的学年（例如：2016年 - 2017年） ）它可以存储1个以上的数据。例如，一名学生已成为3年的会员：2016 - 2017年，2017年 - 2018年，2018年 - 2019年。
我怎样才能做到这对于一个人而言，是否有必要的代码来查看在这些特定年份加入的学生？我需要将查询连接到visual basic。
非常感谢那些愿意提供帮助的人！我试过在互联网上到处搜索但没有任何帮助...
我尝试了什么：
我试着想办法创建一个查询，但我可以想想我怎么能做到这一点。我最初计划自动增量（我不知道这个术语是否正确）每个新学年的新表数据库将开始，但显然，它太复杂了。
Hello, I am an Accountancy student but I need a membership database for a school project and I have no idea how to accumulate data of different years and so I thought of trying to filter it using a field for the year they joined.
The user will be asked to input their Student number name, contact details, and other basic information and also what school year the member had joined (example: 2016 - 2017) and it can store more than 1 of that data. Say for example a student has been a member for 3 years: School Year 2016 - 2017, 2017 - 2018, 2018 - 2019.
How can I be able to do this for a single person and do the codes necessary to view students joined at these particular years? I need to connect the query to visual basic.
Thank you so much for those who would help out!I've tried searching everywhere on the internet but nothing is helping...
What I have tried:
I tried to think of tables to create a query but I can't think of how I can do this. I was originally planning on autoincrementing (I don't know if this term is correct) a new table database for every new academic year that will start but apparently, it's too complex.
推荐答案
每个新学年的新表数据库将开始，但显然，它太复杂了。
a new table database for every new academic year that will start but apparently, it's too complex.
否，你只需将年份存储在表格中。
No, you would just store the year as a filed within a table.
将要求用户输入他们的学生编号名称，联系方式和其他基本信息，以及该成员加入的学年（例如：2016年 - 2017年），并且可以存储超过1个数据。
The user will be asked to input their Student number name, contact details, and other basic information and also what school year the member had joined (example: 2016 - 2017) and it can store more than 1 of that data.
你可以创建一个名为学生的表来存储这些信息。
然后你可能想要一个单独的表来记录出勤率。虽然很简单。例如，存储student_id和年份。这样，学生表每个学生只有1条记录，但是如果你想得到他们参加的年份清单，你会加入考勤表。
You can create a table called students that stores this information.
Then you might want a separate table to record attendance. Something very simple though. For example store the student_id and the year. That way the student table only has the 1 record per student but if you want to get a list of what years they attended you would join to the attendance table.
这篇关于如何存储由会员加入的超过1个会员年度，然后能够过滤在特定年份加入的人数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！