Add Custom Gender with airSlate SignNow

Add custom gender

with the access database whereby you can sort students performance according to gender therefore basically you just launch microsoft access for just launch microsoft access then we can just call it analysis by gender then after doing so we can launch our list then just go to uh create table then we shall create our table as follows it shall have admission number we shall have the student name student name then we shall have the the form then you should have the class then you can also have the ender you cannot have the grid attained then the year then after doing so we just go ahead and go ahead and change the data types before this one is number then this one is also number this is number you can have this one as number then we can have this one as our primary key then after doing so we just go to gender go to rook up wizard we have this one as this option our type then next if we shall have radius first female female then then finish then you can just go to grade again just go to lookup wizard i'll type the next and from here you can just go to love these you can have credit and then you can have pass therefore those are our grids then from there now we can just save our table just in return and grading let me click on ok then after doing so you can just now go and uh in term data you can just paste that one therefore this is what we have which are we have the the data we have the data a dimension number you have student name form class gender and that way therefore after doing so we can just go ahead and create a query just go to create then query double click that cross then just make sure that everything is not done just double click then grade then you have here then save it and just save it as master query then after doing that you can just now go ahead and create our forms therefore just go to create then go to form wizard we choose our data from query query queue query queue therefore we just go to send everything next then we choose tabula next we can just call it this we add the word form form then finish therefore this is what we have then from here just go to design view of this one we can pull this then we need now to modify our table like for instance we need this one to be equal as per the others half class cross and we don't need this one to be so wrong if we can just pull this towards this point gender and also their grade then they should be somewhere there if after doing that now we can make sure everything is in order that way we need this one to be far ahead that way then you can also carry this by having some a bit of coloring then we edit this one as power right it's power wish we need this one to be black and also go that way we need to have this on us student analysis per agenda therefore we can run our form and see what we have therefore this is what we have so far you can also disable this this one that is addition of new just go to design view go to properties in the property sheet here you choose form then around additions long save that one therefore you see that one is normal therefore this is what we have and therefore we need a solution whereby students are classified according to gender if female and then they we can have the grades they score if they are made then we can still do that still we can go ahead and check how many females called distinction one how many male scored distinction too therefore for that case you need to create a filter form if we just go to create then you go to form design so after having that you just go to uh or here then make sure this one is pop-up yes mode yes then you can reduce the size of this uh save it you can just call it theater filter then after doing so and also have some cutoff on it that way therefore when you run this is what you have this is our form therefore we just go ahead and assign the combo boxes we need to have of combo boxes if we can just have that one then copy and paste one two three four we need four if we can paste another one therefore we have four of them then we need to bring these ones to this point that way we undo that then after doing so we need to format that one we also need to format this one then we change the names this one is here this one is the other one is we have the grid the grid this one is form this is grass then this one is gender that way then you need to go and we can have a button this is the button that when clicked it will actually opened the analysis therefore open analysis open analysis the form is what we have then you can also add some functionality on this button just go to [Music] one hover on hover then for car okay therefore when you hover out you see it has some functionality then we need this but this form of ours the filter form to enable you to read data from this master query and then display that accordingly on the master form if i just go ahead on this one when you are still in the form we can just go and remove the navigation buttons to the record selectors should not be resizable but this would be that no control no scroll bus no cross button therefore button looks like this once you select it across itself therefore this is what we have then after doing that we need to make sure that this one reads data from this table and therefore it just go there and assign an sql statement that will uh allow us to accomplish that therefore just go to this one mark the name this is combo zero combo 2 compo4 6 combo 8 therefore we are in combo 0 for combo 0 you just go to data up to this point then we want to type our sentiment there if we type select select distinct what are we selecting we are correcting the ear extracting the ear from our table called grading if i just copy this copy therefore once you do that you save and then run you will see now it can read 2020 then you just go ahead go to combo 2 paste the same but this time round change this one will be reading the grid but when you're reading the grid therefore you save run before you see it is reading the grids then you just go to the next one that is the form you paste this one it should be ready to delete the f need the f that is the phone therefore we need to read the form form one form to form three then the cross north east west and one is the cross or the room therefore this one should be reading the room it should leave their own class then this one should lead the agenda someone should read the agenda and that way so for this one allow you to choose the year credit form 1 east female therefore when i hit this button it will actually filter it will give me data that meets this criteria here that's the essence of using that one therefore we can go now to the next step before for this one we can just reduce this one then we can format that one to maroon and then to the other side therefore we are good that way therefore this is how this is the data that will be uh sorted when we hit this button and therefore for that case we need to go under code for that button if we just go to design view record for this just go to event on click you just go to event procedure then after doing so you just go to this point then write do do command dot open from we open open form for me and then you maximize do commands then it will close for do command dot cross dots we are crossing the phone and the form is me dot form dot name therefore that is the code for that one and therefore we close that then save our phone therefore after doing that when we click on this one you see it is opening but even if it is opening it is not filtering because we have not put the filters on the query and therefore we do that so that if we require uh female students from two west who's called credit then that one can be achieved therefore just go ahead and do that therefore go to this master's query and um do the filtering before you do the filtering the filtering is done let's start from this point here if we just do forms exclamation mark form filter that is the form that is opening and then the field the field is combo zero therefore it is compos zero then we can just copy this instead of typing then we just go to grade paste it there gradle is combo if we just change this one to two to combat 2 then we just go to gender is that one gender gender is compound 8 so just change this one to 8 then we just go to graphs paste that one class is composite if we just change this one to c then we go to form paste that one form is combo 4. if we exchange that one to 4 then save that one therefore after doing so we just uh go ahead and then run this one ever you see now it cannot open without you passing through the this is the gate pass if you just come to this point you choose i want to choose credit then a form to west and female if you see excellent you see two students female female who's called credit and are from that class therefore if you need to get mail you just go back there and choose mail and therefore you need a person to to see how many therefore for this case we want to see how many scored credits and therefore just go to form footer here down here it just put a function if we just go to that one you put a function and a function a function should be simple we just needed to have a simple function there therefore we just come to this point put a text box then this one for that case this one which just equals to count count we are counting a dimension number dimension number if we just count a dimension number and then after counting this the dimension number we also need to have the total out of what out of what therefore if you need this so to get out of we use the count if i just type goes to d count d count toy counting we are counting grades every accounting grade from from a query master cube from from master key from master key then you cross blue bracket before this one will be out of we can just have that one there put off before each other have this one out of this one it will be this one out of that one therefore this one can be bold then just go to properties properties go down yahoo then we shall have this is okay we need to have it that way therefore let's see what we have so far let's save that to this function it's here equals to d count the count grade from master queue that's why we are doing it then for this one we just have count we are just counting the division number therefore this is what we have equals to count the accounting admission numbers then after doing so we just go ahead to our gate pass just go to filter you see the filter credit form 2 the same we were then female before we have a problem here master key rocket two we have forgotten tube out of therefore let's go and fix our error from this function d count we are counting what do we did call this grade we are counting grades we shall be counting grade from grading from grading table grade from grading table let's see again we go to our gate pass we try to see how that one is achieved very good there we are therefore you can see we have 2 out of 13. therefore down here in this actually it's praying for you but you have two out of that in but is we wanted to see female who's called credit that is student analysis for agenda and therefore in this class to west we have 2 out of 19 who's got that one therefore we can still go to our table and try to get something else let's see student from two west who's called the distinction and are female if we just go to that one just go to distinction one form to waste then female and see we have one out of that in benson monk in that you have one one out of 13 who's called distinction one and therefore after doing that you can also go ahead and create analysis sheet analysis sheet whereby we expect to see the analysis that is the analysis per uh distinction that if we just go back to this then you go to form design you can just make it wrong then you can also give it some current then you can just have a heading here but right click first of all right click then you go to format and footer then we can have our heading this is a great analysis great analysis therefore just go to this point then after doing that you can just go ahead here have uh this one you need to have the distinction is in one then we format this one just got format and then you can have it black that way and distinction one that one you can just copy it and paste therefore this one is there distinction you can have them that way therefore this is distinction 2 it is created ready when this one is parts if we need to have our analysis here showing this way therefore after doing this you can just save this one as a grid and rsis grid analysis and therefore after having the grid analysis that way we just go to design then take the text box can draw the text box there remove the label for the textbook then just go to this point we type our account function equal to the count then the account we start with bracket bracket you can have bracket the account then open the bracket what are we counting you're counting the accounting grid grade then you from where from our table called greeting then what else we want to also count exclusion here by grid grid counted equals to distinction for equals to equals to distinction you want distinction one distinction one yeah that is that that way then we go across the bracket let's see whether there is an error therefore x and latto and c what we have if we have zero i have zero distinction one according to the function therefore this just just make sure that everything is in order for your creating grid you open a grid from grading if i just go to this point this one we are counting d count great accompanying grid great before you can see get this one see this function and correct it from this point from the control source and therefore just check the way we wrote the name the word distinction one distinction one the function this one should be correct distinction one that way yeah you see now we have four therefore this pairing was a brand new there then after doing this you just need to copy this to copy this then change therefore just need to have this one then go to format you can have it just 22. save therefore when i run i have four then just go back go to properties change the box file to transparent so that you can have four then after doing so now we have the buddhist area transparent also background okay after not doing that you can just copy this one and just go home copy then paste bring it to distinction 2 paste again test again therefore then go to change this design to properties therefore this one this one just change this one to blue then we go ahead to this one we change this one to create it create create it then for this one we can refer to paths change that one to pass okay then after doing that you can just save and before you see we have four distinction one two distinction two then we have four credits and then we have three paths let's see the entry the entry should be the total of this ones before we can still identify this one this is text five i'm seeing looking at here this is seven eight and nine therefore we have we have text eight nine then we have this one this is text seven then we have text five therefore you can go ahead now and get the entry that is the total the entry just type the entry here entry and that is the total number of students or candidates therefore that is the entry then you just go and take a text box and then draw draw a text box there if we just type 5 press text 7 take eight percent nine therefore when we run we have that team and therefore if you add this you'll get thirteen as the total therefore that is using the that is using the d count to make sure that you have i actually in the analysis and therefore from now this point you have seen how you can get the right distinction to from form one it's female there is one who scored that one and therefore we have one out of uh 13 who scored that one therefore that's how you can come up with a student analysis by gender system using microsoft access therefore thank you very much for watching see you in my next video