MS Access _ Class 07 - Create Buttons _ Hindi_ Urdu _ - video Dailymotion

Earning & Learning

ALL TUTORIALS.

Transcript

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.

MS Access _ Class 07 - Create Buttons _ Hindi_ Urdu _

Category

Transcript

Recommended