Student Fee Record System in MS Access database || Mini Project ||

here friends you are watching while you have tech and in this video I will show you how you can create student fees record system this is complete microsoft access project I assure you if you watch this video from beginning to end you will learn 40% ms access database this is mini project and this will be a very very helpful for computer science students and specially for those who are doing diploma in ms access database you can submit as us mr. project in school college or university so let's start these are six steps that we will we will follow to create ms access project so these are six steps first we will create tables then we apply curie then we will make relationships then create forms report and final step is over application user interface so let's start so I will tell you from the beginning to end and I will describe every step so first right click from mouse click on you and slept Microsoft Access database so this is Microsoft Access database I will open this and enable content so here I will create new database so select playing desktop database and here you can give location where you want to store this database so I want to store in desktop so I will select desktop in here I will give database name so my database name is student fee record so I'll click on create and here is Table one so I already told you these steps I will follow first step is create tables so I'll create four to five tables so here is first table but I'll give name of this table student ok now go to design view and here I will give field name student student so data type short text is good then I will close this so first table I have been created successfully then I'll take in other table so same as like before I will give name class and go to design view and here I'll give field name class okay save and now one more table and here I will give name of this table name of Stephanies roll number rolling okay go to design view in here alright roll ok save this he have been created three tables successfully now I require one more table and this table is for total fils okay go to design view and here alright total fees okay face using number and roll numbers we are so in number but okay no problem go to design view and change data type number save this okay for table I create created for tables you know I think I should take one more table this is this will be our last table and here I will give name main menu okay go to design view and write all field names or table names here first is student then class you'll total fees and here I will give one to morphine names receive fees and remaining dues are remaining remaining fee ain't received fee okay all data types should be number should be number okay save this and now we'll apply Curie first step is has been completed we created tables now we'll apply Curie okay so close this and select main menu click on create and go to curie wizard okay and here I'll field selected Next Next and finish so or Curie the block has been applied successfully now we'll make relationships so two steps have been completed now third step is relationships now select this main Curie and go to database tools and select relationships here slept all options and click on add and this is our main menu so separate these all so first is student name sorry first a student then class then role then total fee ok student ID match with student press enter class with the last role the road and total fees with total fees okay now save these relations and or three steps have been completed successfully now we will create forms okay so first we will create form for student so select student in click on create go to form you remove this press delete so move and go to design view we need button so go to design and select button record option and add new record so here button add student finish this and save student form okay one form has been created successfully now we'll create form for class table so select class table go to create click on Form and remove this then go to design view and same as like before we will take own button go to record option add new record click on text and here add glass next in finish save this last form okay save and close to forms have been created successfully now we'll create form for role select role click on create go to form and remove this select design view and select button go to record option next text in here hair troll next and finish this is very easy so roll for okay and close this now for total fees slap total fees click on create' go to form and remove this same as like before so here select button code will card option click on next text and here right ad are set set total feel next and finish say this okay delete this button sorry chain name I want to change name of this button safe okay now it's good total fees okay four forms have been completed successfully now one more form but we will select Curie main menu Curie and click on create go to Curie wizard click on OK and here sorry-sorry sorry-sorry curie wizard no first we'll create form for this so here is form and code to design we work this form in here we take combobox remove this select and press ENTER we move this and go to design view and select combo box we need combo box far student next and here select field student go to next and here also student next next and here click on store and here select student also in finish this now rewrite name student here so remove these st. select combo box for all these field we need combo box so this is the last next next select class next and click on store here I'll select class next in finish rewrite this name class here delete this same as like before this is for role next and here's left road to next click on store and here also slept so we roll next in finish here I'll sorry right name rule okay so total fees delete this this is last this is for total fees next total fee click on next click on store and here select total fees and finish this and here total fee ok this forms completed and we need button here button will give text here sale next and finish and here main menu ok so save this in over four steps have been completed now we create report solo select main menu just go to form view ok that's good ok slept main menu Curie and then click on report wizard will create report so here select ID then this is very important step and here we'll select student in here students left then class and here also select class then a role and here also role then total fees total fee slept it now two more fields or received free and remaining fee okay all steps are correct now next in here first ID then student class role click on next and here we should give a report name this is right report or a spelling mistake finish this okay over report has been successfully created now go to design view and design stupid name then click on class and correct all fields select total phase sorry select only this field okay so save this report and go to report view okay now it's looking good but some more changes but need it here bold this slack can go to farm 18 both increase size 12 same a student 12 in world I hope you understand select 12 in bold same she is 12 in port this is last okay now check report you know it's looking good by this tubing class for total fees what's wrong okay you can correct it but I have no time because video student t go to report view okay now it's looking good and then we will create next step is report is okay now we'll create user interface okay so now to create and select blank form here and here right name of this project student fees Ricard okay so select this go to for made in board and here increase size dragon Center background color is black and font color is white okay now go to design and take button go to form and select open forum click on next and this is for student select student click on next and here text and here give name add student student click on next and finish this okay so now take one more button go to form same as like before this is for class form okay click on next and here right add class finish this take one more button click on open form and this is for row click on next and here add row click on finish now this is for total fee next and here total fiz finish and after this what we need okay to form a pressure same as like before and select main menu next and next here right main menu okay finish this and we'll take last button for report so select here report operations and go to open click Next Next and here finish this okay so now some changing here change color go to farm it and here select blue and white okay now it's looking good okay so here change font family so here also change this is good okay depend on you what you like so select all press ctrl and select these odd and here color is this is good good twelve okay that's good so now save this give name student face record okay so go to firm view and click on add student here we add one more button go to design and the take button go to form and open form and select student fees record okay this is main our back back button click on next and finish this okay save and go to from view okay that's good so add class go to design view and take back button open form go to student fees record next click on text and here also back okay so now go to from view click on back ok add Road go to design view and here also take button from open form sled children face record and right back finish this and save ok now total face and take button form perform click on next and right back finish say come back okay so this is last step go to form and form next and right back finish say go to farm okay now it's ready now we'll check so here we can add student here we add class here we can add roll number in here we set total fees okay so add some student so I'll write my name and click on add student so now add class is one two three four five grades click on back then add rule number one - okay that's enough so here's had total fees total fees is one thousand okay save this click on back ok so here you can add student here you can add class here you can add role in here you can set total fees and this is over main menu here you can select student that you already added I added my name the sir so select here you can select class and here you can select a rule number select this and here you can select fees total fees and here you can write received fees how much receive 800 and here 200 remaining okay click on save then click on back and checked report so over detail will be saved or not so refresh it I think refresh and here you can see all details saved in report one with a servant class 1 and here are detail you can see so go to design view and add one sorry I added only one student now we add one more student James and so ok now back and click on main menu then here you can sorry refresh it then name will be appeared refresh and now you can see our names will be appear so here you can select any student select student class you can select a rule number here total phase and here received phase 1000 and remaining v-0 click on save that and you can check refresh and here you can see in report to record it to records saved successfully so this is student fees record system so that's all friends I can make more beautiful user interface this a user interface this I can make more beautiful user interface but I think it's enough I request to you I don't need anything from you please just give me a one subscribe and one like take care bye bye

Channel: Madu Web Tech

Views: 56,928

Rating: 4.8539824 out of 5

Keywords: MS ACCESS, ms access project, how to create ms access project, how to create ms access database, how to create student fees record system in ms access, how to create student management system in ms access, How to create ms access project, ms access, access 2016, MS ACCESS DATABASE, CREATE RELATIONSHIPS IN DATABASE, How to create database project, Form in Ms access, How to create project in Ms access, Ms Access Project, How to Create MS access database

Id: KENXZhUb6NM

Length: 32min 15sec (1935 seconds)

Published: Mon May 18 2020