Create Your Customized Tuition Receipt Template for Public Relations

Tuition receipt template for Public Relations

hello guys I probably welcome you to this quick Microsoft access database tutorial brought to you by data text my name is AKO Smiler guys I apologize for my long period of absence on this channel in today's video I'm going to share with you how to create payment received in any of your Microsoft access database project this particular tutorial will be very useful to you when it comes to projects such as school management database creation POS software creation Church management and then a lot more of other databases so we are going to learn how to issue receipt or print receipts that will have all transactions made by a particular customer at the end of a transaction or in a day so Guys Without not much we do let us get into it so because we are going to over here we're going to create a very basic database that will actually issue receipt to customers that will make payment so we'll quickly go in here to the reborn now we're going to create so we start the first table table design okay so the first thing we are going to create will be the customer table so we say customer ID let's make it Auto number and year formats I'll say zero zero zero so that will have three digit numbering okay so we make it a primary key now right click save so we say TBL customers okay so now here we say name okay so let's say customer name because name is actually a name of some functions in Microsoft Access we're gonna use it it's a reserved keyword so we say customer name okay so here customer info size are limited to 30. so we're also going to take the telephone of the customer so I'm gonna limit it to also 15. okay so we can take the address of the customer and then here again we can also take the general of the customer so that we can categorize our customers into gender so here let us click look up now here we type in our own values so we say male so male female you go to next Limitless finish okay so let us assume that these are just a couple of information we'll be storing as for our customers so we hit here okay so now let us enter some couple of customers so let's say Sandra Excel so telephone numbers go the assistant it's a female now let me add myself I will Smiler so let's say kasoa say I'm a meal so let's add one more person let's say girlfriend menu so these are some couple of customers that we actually Gonna Keep in here so let's say koti new side okay it's a meal okay now the next thing you're going to do is you're going to create a very basic form guys attention is not going to be on a form design you're going to create just basic form that will help us to actually keep things going in this tutorial feel free to modify the forms to actually look the way you want so here we're going to create form wizard we are going to create so let's select everything in here Nest so column now okay so here now I will say frm frm customers okay okay so here we have our basic customer from created for us let's go to design view and then change some couple of things the first thing I'll change here is customers the title here now let us make this from a pop-up so go to property sheet now pop-up is set to yes so let's see what the pop-up does so pop-up will make this one a very small and then cute phone okay so now I have a lot tons of videos that teaches how to create forms removing record selected navigation bars and all that so guys you feel free to check in the uh playlist that I have in Microsoft Access the Microsoft Access playlist and you find some couple of videos that will actually broaden Your Horizon when it comes to creating forms okay so now we are going to keep this form as basic as possible so let us add some couple of buttons here so the first button will be the add button so record operations add new okay so here let's say new customer so new customer is here so let us add one more another one sorry so this is going to do the saving for us so I'll add a VBA code to this so I'll say save for refresh now let us add one more which is a delete so we add a delete button record operation delete is here Nest so delete okay now we hit finish so now let's select everything so that we can go to the side we sell it to tallest now let us align everything to the tops okay so the next thing is that this button we actually did not use a predefined macro so we are going to program it using VBA so we select to go to event so on click events now let's use code Builder so here I'll say do CMD does refresh do CMD so this uh just some basic key Vehicles that's what the first line will save we'll refresh the entire form data and the second one will also save it for us you can just choose to use only the first line and that will do everything for you okay so now we go to form view so here we are new customer so new customer let's say happy here Abigail so you say code here address goatee new site now what is agenda so the agenda is a female now we save okay so as soon as we save you come to a team when you refresh you can see that the data has neatly jumped into your table for you okay so now the next thing is that we are going to create the payment table okay so here we go to create sorry so we supposed to create table not query so create table design so now here we say uh [Music] payment ID Auto number okay so now the first thing is the customer who is making the payments so we say customer and we already have our customers in here so next time we're going to make it a lookup so we're going to lookup so a lookup because this time round we already have our customers so this particular field here is going to look up the values that we have in the customer table so that you wouldn't have to be typing a customer's name each time that they come so now First Option selected we want to get the values of another table so this is a table that contains our customers yes so the field that has our customers name is the customer name field so bring it here next now let's click here to custom filter by the customer like sorry we sold by the customer ID next now we go to next enable data Integrity so here uh most mostly I do explain this but then so since we are still making videos I mean on how to actually on payment which has brought us to lookups I still need to take my time and explain this again so let us recall that if you set Cascade delete it means that each time that you delete a customer all Associated records in the payment table will be deleted now if you don't want this to happen then you just restrict your delete so this time around I will just Cascade delete because if I remove my customer I don't need a transactions again so I will save now we say that we should save this table before the relationship can be created if you have watched some of our videos you would have learned that lookups are always using also creating work relationships so now let's say TBL payments okay so CBO payments now say payment dates which is dates or time so now we can also say payments the time also date or time or you can just click in here and select any of the data type here okay so now we're also going to say the amounts so amount is going to be currency okay this time around we need to do some couple of validations here so validation rule greater than or equal to um so the amounts the least amount that a customer can pay let us set it to be equal to uh five dollars because it wouldn't be accepting transactions less than five that is me that is the rules I'm defining here so I will say my default value is actually five now if a user enters the value that is less than this they will see that invalid amount entered so this is the message that will actually pop up please enter again okay so let's save all right so we'll see we have payment ID customer now payment dates payment time amounts and now also we can add the mood so mode of payments or you can say payments mode so payment mode is also going to be a lookup so we click here go to look up with that I will type in my own values now here we go to credit sorry uh credit card mobile money Bank then cash okay so he has to go to next now we are going to limit to it so that a user can just select only one of the items that we have in there so we go to finish all right now we see it again now we have this one down here so this is what we have actually done so if you want to record a transaction you just select your customer what is the date so you specify your dates your time so let's say the time is now what is the amount so this amount is 120. what is a payment mode so let's say the payment mode is cash so let's say Sandra ISO alcohol Smiler myself to so today so let's say eight sorry so it's okay so let's say 100 cash all right so now this is uh the table that we are going to actually use to record our transactions here okay so now the next thing that we are going to do is that uh a customer is likely to make payments on several payments on the same day so how do we see all of them now to do that we go to the design view of the table now if a customer has we need to find some ways of categorizing the payment so if your customer each transaction will actually ask the customer to specify the paper so here we see the purpose let's make it a lookup so so now let's see the purpose here we have new pages so let's say payments could be for new purchase or depth defraying depth different okay so either a customer the payment you are recording is a new purchase or debt different okay or also it could also be that the he or she just want to pay in credits or Advance payment so you can also say Advanced payments Advanced payments so these are the payments purposes of payments okay so it means that we've done this so that on a day someone let's say for example Sandra SL pay something for new pages then on that same day uh Sandra Israel again on the same date on the same day it's let's say seven she makes a payment of 20 she paid by cash but in this time around it was actually Advanced she paid for advance so you could actually do this also so now we have our payment table set up so the next thing that we are going to do is that we are going to create our payment table so sorry our payment form so we're going to create phone wizard now let's bring everything here to go to nest Nest so here you're going to say frm frm payments so let's modify the forms design finish okay so I will select everything here now the size let us actually leave it the way it is it looks good so let us leave it but then I'll just say payments okay now as usual let us make this form here pop up okay so now what I will do is I'll go to the frm customers and then all the buttons here let us bring it here a bit I'll copy from the customer form and then I'll just come and paste everything here wouldn't have to worry ourselves creating crazy new buttons okay guys so now let me select everything here so let us keep it to black color and then 12 is also okay here all right so now we have our female our payments formulas set up here there are some couple of things that we are going to do here supposed to be new payment so let us go so we say new payments [Music] okay so now there is an issue here so you can see that if we click new payments now the date doesn't count the time doesn't come but and these are things that we need to actually automate and then also they are usually most accepted payment mode which is Cash we need to also set some default values for all these things so we are going to set default value for date time and then payments mode so that data entry will so easy so we simply click dates then you go to data Now default value you type in equal to date okay now when you finish so time is also equal to time so this is going to give you the value that we have here the date and time values we have here now the payment mode you go to default value and say it's equal to cash all right so now let us go to the payments so this is a customer comes we go to new payments so as soon as we go to customer we select the customer you can see that the date has come payment time has come so just enter the amounts 100 payments more.com now what is the purpose so let's say deputy frame and I will just save okay so now before we'll actually move on to create our receipts the very next thing we'll do is that if we select a customer we're supposed to be able to see the customer's information so now we are going to use a query to extend the payment table so we're going to create query design so let us bring our two tables now you click Start to add everything here so for every customer you're going to need a customer ID customer name customer telephone agenda okay we can add address now let us run so you can see that we've been able to get the customer's name against their details here so let us save this query right click save so we say q r y payments extended okay so Q Roi payments are standard so now we already have the payments for so what we'll do is design view so design view here now let's do some couple of stuff here so what we'll do is we are going to add let me add a label so as soon as you select the customer will say customer [Music] information okay so customer information now we click here 20. 20 seems larger so let's make it 16. okay so we can actually change the color to let's say red good okay so now what we are going to do is that you go to form design add existing fails so before that you can see that we are not getting the address and the names and then all that because the record source of the form is so set to the table payment which doesn't contain those ones so guess what we are just going to change the record source of this form so the query that we just built okay so now that we've done that let's click add existing fields and you can see we have customer ID so hold the Ctrl key and select all these guys here you bring them neatly here okay so now we can actually extend this uh so let's extend this neatly here okay okay so let me select size why it is now as soon as this information comes I wouldn't want my users to be able to change this because this information that we entered already so you select the controls here not the labels enable you set it to no it blocks you set it to yes and now you can actually choose to set your colors okay if that is the case then this one should be black all right so guys let us see what we've actually done so now you can see here we have information here so let's say new transaction customer is uh Abigail so you can see our biggest information our popped up here so now have you guys information is here so as soon as you choose your customer you can see now the information will pop up here and what else yours is to just record the transaction okay now we see so now the next thing is we are going to design our receipts so now we have all now we need to create our receipt so before then let us close this save it's okay so now we open the query that we built over here now we're going to create so report wizard okay so this time around payment ID will need it now the date will keep it there time will keep it there now we are going to need amounts and then also we are going to need payment mode and then purpose so next okay so now we still go to nest let us click here and then here we have the payments ID so let us sort by the payment ID we go to nest so make sure you keep it at tabular yes all right so here I'll say rpt [Music] RPG receipts now let us preview okay so I know you guys will be saying this one doesn't look like a receipt of course so let us go to design view of it and now change it to look like a receipt so I will delete this now let us fold the top with white color so now the amount is too large so just shrink it payments model we are going to minimize it also so you just keep it as small as possible we wouldn't need these guys here but then if you prefer you can just keep them but then since they received it's just going to be a small receipt there's no need keeping those guys there the page number okay so I want my receipt to be as small as possible so now select these guys here and then 12 is actually okay black color is fine so now let me make this one good and then Center aligned okay so now I will click here alternate color which is not so that this will not be alternating for us here okay the next thing we'll do is to sum the value that we have here so what we'll do is that we highlight the controlled amount now you go to form design totals now you sum so you bought it okay so now let us add a label so that we can communicate to people that hey what you see in here is a grand tutor so run Twitter so that is a total amount you paid so let me copy the four months printer and apply to this as well okay so this I will ship fill to Green and now the color I will change it to right here okay so now let us see the progress so you can see now this is what we have here so the next thing is uh let us sensor or left side like this so that it looks neat okay now the next thing we are going to do is we are going to add the customers information so and the payment information so report design add existing field so we need the customer so the customer name now we need a telephone agenda the address and then also payment date and payment time okay so we'll bring all of them here all right so these are the information I will need on my receipt I want to show the customers information so I'll keep all of them here okay so now let us extend this [Music] so let me select this right click size I'm going to widest okay so we select here now black okay so this let us actually preview to see how good it looks okay so this is how it looks and uh it's very very needy here so the next thing is that we add some uh information about the company so here we come level so let's say Mary Greece supermarkets okay so this is a fictitious name so 24 the size let us keep it to 22. okay so now let me shrink this so copy it paste Okay so now uh let us select this we minimize so let's say keep it at 12. so what is the location of it and then also what is your telephone so let's say location so let's say location the mercy bandama now let's say the telephone is zero zero zero zero zero so this is just fictitious numbers here now you can add some couple of information any information that you I'd like to add to describe them you can also add a logo but then I will not adding logo here I'll do this okay so now guys so this is how our receipts actually looks like now now you can see they're showing everything right here so let's go to design view the receipts pop-up is set it yes that also make sure that auto center is set it to yes alright so at this point we can add the prints button here so make sure you add your print button neatly here so here you can say prints now let's make it small okay right click build events macro and I see Prince objects now we save okay so this time around what we're gonna do is that report view so you can actually click here to print now if you want to get rid of this gray butter we have here you go to your design view so here screw bars this is a very small receipts and because there is no need for screwing that is a only vertical screen reported at some point so you can to get rid of the gripper you can just set it to vertical or neither I'll just set it in either okay so now the next thing we'll do is I'll go to Fram payments so I'll add a receipt here so let me add the receipts here so I'll change the design here so let's change it let's change it let's change it to this now I will say receipts so print received now prints receives we can keep it to 14. okay so now when the user collects this it should come and open the Reps receipt but then where the payment IDs are actually the same and this is going to cause an issue but so let's do it so we're able to build events macros so open reports so report name is rpt receives so equal to the where condition will be equal to payment ID equal to Ampersand and then payment ID so we click here now I put this once in quotation and I save okay so we are almost true with this particular tutorial so if you select any of the payments you click print receipts now I can see that the system will give you the exact received here so let me put it here so that we cannot see it well so you can see the system has giving you the exact receipt for the customer selected so if you go to a different customer I call Smiler now if you print you can see I could smile and my details are here my telephone gender and everything and then my receipts is nearly here I can quickly print this also okay let's test one more person so menu so you can see main is also here now the drawback here is that a customer like Sandra made most of the course Media made server payments in the same day but then only one is showing because the work condition was built only on a payment ID only on the payments ID that's the reason why we are facing this issue so now we need to just go to the query and then create some kind of external serials that can actually was assign the same Syria for every customer that for all the payments a customer will make and in that case we'll be able to print everything so if the customer makes server payment they will also on the receipt and it's so easy so we go to the query extended design view now we are going to combine the customer ID together with um together with the customer align together with the data specify the payment so here we come so build events I'm going to say Syria so Syria we're going to say a customer ID concatenate that one with payment dates now okay so let us run okay so now you can see that a unique serial has been created so every customer all the transactions the customer will become the same day will be identified by this particular Syria here so now having made this area you go to your receipts you add the Syria here but then we wouldn't like this one to show so we are going to select everything here and now visible set it to know so the next thing is that you go and do the same thing on the payment form so also add existing Syria now here to we set it to visible it's ready to know okay so now if you do this then it means that we work condition now needs to be built to the Syria so received build events now we are going to say equal to Syria this time around 1 record is good one particular phase of a form is going to have several records in the report so we're going to say Ampersand sorry sorry no more so equal to this and this quotation Apostle quotation and Syria again compassion quotation Apostle quotation and now as usual we put the first area with the equal signing quotation now you see okay so now let us come back here if you just click print received so now you can see that congratulations it has given us all the payments that so it tells us that hey Sandra made first transaction is this second transaction so the two-ter transaction recorded by Sandra is this so if she makes another payments in the same day it will all pop up so our customer I made only one payment so let's say for example myself also a course Myla let's see I make appearance of a thousand USD by cash they'll Define I'll save and then print the receipts now let me save this so 316 okay Smiler so depth the frame let me change this Advanced save friends receives okay so let me see so if they are not actually showing this means that you check the dates so this is a cosmila first one so in all the same days the same date so okay so now they are all showing here because they did not really refresh so that was the issue so here we have been able to actually accomplish the project that we actually about and I believe this is going to help a lot more of you uh you find in the description a link to this particular projects will be stored in the description so just feel free to edit and then use whatever I've done in here I look forward to seeing you in the next video If you have a comment put it down thank you so much for your support I really really appreciate you guys thank you see in the next video bye