Good day every body. I want to develop a database program that will be used in school to input information about students and all the staff of the school. I want the program to be able to retrieve any required information and also display the total number of students in the database. Because I don't have any knowledge of SQL, I want to use Microsoft access database. Some should please assist in the complete codes.
Thank you
Ukpe 0 Newbie Poster
rproffitt 2,662 "Nothing to see here." Moderator
Wait, you lead with you want to develop this but then ask for complete codes. What development would be left for you to do?
varcore commented: Exactly , how is he supposed to learn anything ? +0
Dani 4,329 The Queen of DaniWeb Administrator Featured Poster Premium Member
This sounds to me like something that can just be done in Microsoft Access alone. What would be the purpose of VB.net in this case? How do you imagine it to look?
It sounds to me you could create a handful of tables in a relational database: students, teachers, subjects, classes, and class rosters.
Every class has a teacher. Every student is assigned to multiple classes.
Student table:
StudentID (primary key)
First Name
Last Name
School Year (Freshman, Senior, etc.)
Subject table:
SubjectID (primary key)
Curriculum
Teacher table:
TeacherID (primary key)
Name
Class table:
ClassID (primary key)
TeacherID
SubjectID
Class roster table:
ClassID
StudentID
Grade (A+, B, etc.)
john_111 88 Junior Poster in Training
Sounds like a bit of homework to me.
By making the database for a "school" the data required would be familar to a student.
Create your data tables, create your data entry forms, create your queries. ALL within Access itself, which is perfectly capable of using its own built in programing capabilities for a project like this. If its part of your course, create a few views as well.
Add tests to check the data entry form is not missing any required data - ie don't add to the table unless the required data is complete, give a relevant error message and let the user try again.
Design before you start building anything! Design, design, design first.
Make each section work before moving on to the next, rather than hopping around doing bits and pieces.
Think of Must have, Could have, Might perhaps have. So you don't concentrate on an extra while must have bits are incomplete.
PS I know it's a project, as we did something similar in a course many years ago, and such software already exists, so you are not build for a real client, are you? ;)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.