ALL TUTORIALS.
Category
📚
LearningTranscript
00:00Welcome again. This is another new class of MS Access.
00:05In this class, we are going to learn a little bit more about our form.
00:10So, as we had created some buttons in our last class,
00:15like we had created a button here, first record,
00:18then previous record, next record and last record.
00:22After that, we had added a button, add new record.
00:26So, till here, we had covered in our last class.
00:30Now, what we have to do is, we have to create some more buttons here.
00:34Like, we type any record here.
00:37After that, we have to go to next, then that record is saved.
00:40But, if we get a save button here,
00:44then we can directly click on it and save this record.
00:49So, let's come back to our design view for the save button.
00:53And, after coming to the design view, we need a button.
00:59So, where do we need a button?
01:01So, I need a button here.
01:03If I get a save button here, it will be very good.
01:06Let's try to make it the same size.
01:11So, here for the save button, we have to come to record operation.
01:15So, in record operation, we get save button, print button,
01:19duplicate, delete, undo. We get all these buttons to see.
01:22So, simply we want to put a save button here.
01:25And, we don't want to put a picture, we want to put a text.
01:28Save record.
01:29Okay.
01:30After that, let's simply finish here.
01:32And, here our save button,
01:37let's put it here a little bit.
01:40Okay.
01:41And, let's make the text bold.
01:45Now, where will we make it bold?
01:47Let's come to format.
01:48Let's make it bold here.
01:50And, let's make the color black.
01:53Okay.
01:54Sorry, the paint is black here.
01:56We have to make the font color black.
01:59Okay.
02:00So, perfect.
02:01Now, we have a save record button here.
02:04So, basically, let's keep only save.
02:06Let's remove the record from here.
02:07So, that we can reduce the size of the button.
02:10Okay.
02:11So, here we have reduced the size of the button.
02:14There can be another button on the side.
02:16Let's reduce the size a little bit more.
02:18Okay.
02:19Perfect.
02:20So, here we have made a save button.
02:22So, along with the save button,
02:24let's make one more button here,
02:26which is the delete record.
02:28Okay.
02:29If we have saved a record,
02:30so, basically, we can also delete it.
02:32So, here we will get a simple record of delete.
02:35Repeatedly going to the same table and deleting it,
02:38is not right.
02:39Okay.
02:40So, here we keep its name only as delete.
02:42And, let's finish here.
02:44And, again, all the same things,
02:46let's make it black color and bold.
02:49And, let's keep this button on this edge.
02:56Okay.
02:57Perfect.
02:58So, here we get a save button,
03:00a delete button,
03:02and a save record button.
03:05Okay.
03:08So, let's save our record here.
03:11Let's come back to our view.
03:14Okay.
03:15So, when we come here,
03:16let's click on add new record.
03:18Now, I don't need to click here.
03:20Simply, I will click on add new record here.
03:23So, you can see here,
03:24a new page has opened for me.
03:26Now, here I can type the name of my student.
03:30So, the student's name is, for example, Mayank.
03:34So, here I have typed Mayank.
03:35The enrollment number that we have generated,
03:37suppose their enrollment number is 135,
03:39so, we have written here.
03:41After that, which class are they from?
03:43They are from second class.
03:44Okay.
03:45What is their date of birth?
03:46Their date of birth is 5th April,
03:49and their date of birth is 2001.
03:51Okay.
03:52So, here we have written their date of birth.
03:54How much is their fee?
03:55So, they have paid the fee.
03:57Suppose Rs. 500.
03:59Okay.
04:00So, we have written Rs. 500 here.
04:01Is it paid or not?
04:03So, if it is paid, then click on it.
04:05Their photo.
04:06You can upload a photo here.
04:07How much is the tuition fee?
04:08So, Rs. 200.
04:09Their tuition fee is also paid.
04:11What is their PAN card?
04:13Okay.
04:14So, here we have typed their PAN card number.
04:17Okay.
04:18After that, we simply have to click on save record.
04:20So, we have saved it.
04:22Okay.
04:23Now, this record has come in our primary table.
04:25Now, you can't see the record here.
04:27Simply, you will refresh the sheet.
04:29So, you will get a record update here.
04:32Okay.
04:33So, the common way to refresh is
04:35from your PC,
04:36sorry, from your keyboard,
04:38you have to press the F5 key.
04:41So, if you want to refresh,
04:42then you will get that page refreshed.
04:44You can see that the record has been added here.
04:47And I can see the remaining records here.
04:50So, you can save records like this.
04:54And now,
04:55let's create some additional records.
04:57Because in the upcoming class,
04:59records are very important.
05:02Because we will require lots of records there
05:04to perform our tasks in the future.
05:07So, let's quickly click on add new record.
05:10Now, let's add the student's name.
05:16Salman.
05:17So, here we have added the student's name.
05:19Student's enrollment number is 136.
05:21And which class is he in?
05:23So, here I will click on first.
05:25So, let's add the student's name in the first class.
05:27Salman.
05:28His date of birth is 01-01-2002.
05:31Okay.
05:32He has paid the fees of Rs.1000.
05:34Okay.
05:35After that, there is no photo.
05:36After that, there is a tuition fee of Rs.500.
05:38Okay.
05:39Let's check out.
05:40We forgot to check this as well.
05:42Okay.
05:43Let's add any digit in the pen number.
05:46And here,
05:47our pen number is ready.
05:48Save record.
05:49Add new record.
05:50Okay.
05:51Again, let's save something else here.
05:53So, let's save it here.
05:55Raja's record.
05:56So, Raja's enrollment number is 137.
05:59Which class is he in?
06:00He is in the third class.
06:01His date of birth is 05-05-2004.
06:06He has paid the fees of Rs.1000.
06:08Sorry, he has paid the fees of Rs.100.
06:10We have paid the tuition fee of Rs.50.
06:13And here, we have added his pen number.
06:15Okay.
06:16So, this is how we save our record.
06:19Now, let's check out the delete.
06:21And it's better than delete.
06:22Let's edit a few more keys here.
06:26This is a normal key.
06:28Now, let's create a different key here.
06:31Let's create one more button.
06:33So, let's see which button will be good.
06:36So, we are familiar with all the buttons for record navigation.
06:40We know everything about operation.
06:42Duplicate record.
06:43What is delete record?
06:45And what is print record?
06:47What is save?
06:48What is undo?
06:49We know this normally.
06:50Let's type some new records here.
06:52Like, apply form filter.
06:54Or print current form.
06:56After that, we get mail report here.
06:59Open report.
07:00After that, we get preview report.
07:03Print report.
07:04In application, we have quit application.
07:06After that, we have auto dialer.
07:08Print table.
07:09Okay.
07:10So, we have an application here.
07:11Quit application.
07:12So, let's add this.
07:13And here, it has a sign.
07:16And here, it has quit.
07:18So, let's add quit here.
07:19Okay.
07:20And next, let's finish.
07:22Now, with the help of this, we can directly close our MS access.
07:28Okay.
07:29So, let's make it bold.
07:31Let's change its color.
07:32Okay.
07:33And let's change its color a little bit.
07:35Let's make it red.
07:37Inside that, let's make it bold.
07:40So that, it looks a little bit different.
07:42And everyone can understand that this is our quit button.
07:47Okay.
07:48So, red color indicates that we have to stop something here.
07:52That's why we have a combination of red and white here.
07:55So, here we have made a quit button.
07:58With the help of this, we can directly quit it.
08:01So, let's make another form here.
08:05And let's test our delete button.
08:07So, let's come to add new record.
08:09After that, let's put the student's name here.
08:12For example, the student's name is...
08:18Shahid.
08:19So, Shahid has put the student's name.
08:21His enrollment number is 138.
08:24In which class is he in?
08:25So, in the 4th class, the student's enrollment number is 04042001.
08:30Here is his date of birth.
08:32He has paid Rs. 2000.
08:34Okay.
08:35The fee is paid.
08:36The photo is not available yet.
08:38He has paid Rs. 500 for the tuition fee.
08:40We have typed his pen number here.
08:43After that, we have simply saved it.
08:45Now, if we come to the table,
08:47there is no record here.
08:49I will simply refresh it.
08:50So, all the records are here.
08:52And the last 21 number record is of our Shahid.
08:56So, let's delete Shahid's record here.
08:59Okay.
09:00So, Shahid's record has been deleted here.
09:02So, are you sure?
09:03So, yes, we do.
09:04We are absolutely sure that we have to delete it.
09:06And after that, you can see here that it is deleted, deleted, deleted, deleted.
09:11It has been deleted everywhere.
09:12And once I refresh it, it will be removed from there.
09:15Okay.
09:16So, the record has been permanently deleted here.
09:18Now, let's add Shahid's record here again.
09:21Because he is my student.
09:22So, it becomes necessary to add his record.
09:26So, for example, we have put his 4th class here.
09:29We have put the date of birth as 04-01.
09:32Okay.
09:33Whatever we have put, let's change it now.
09:35And his fee has been paid Rs. 2500.
09:38He has paid Rs. 1000 for the tuition fee.
09:41Okay.
09:42His pen number, whatever it is, has come.
09:45So, let's just save the record.
09:47And here we refresh it again.
09:49So, you can see what used to happen in the normal table.
09:52That we used to delete any record here.
09:54So, the ID number that used to disappear in it,
09:56the same case happens in this too.
09:58We delete a record in the form too.
10:00So, its ID number also disappears here.
10:03Okay.
10:04So, this is a common thing in both.
10:06So, in this way, you can add your extra button here.
10:10You can do whatever you want to add a button here.
10:14And in this way, you can record your data in your form.
10:19So, basically, we need a lot of data for the upcoming classes.
10:23So, now this much data is enough.
10:25And now I will close the video and enter 10-15 more data here.
10:29So that we can know the upcoming class very well.
10:33So, let's meet in our next class.