ALL TUTORIALS.
Category
📚
LearningTranscript
00:00This is the last and final video of our MS Access course
00:05In this video, I am going to tell you a step
00:09With the help of which you can open this form as a separate application
00:15So basically, before opening it as a separate application
00:19Let's add some more features in this form
00:23So that we don't need these tools again and again
00:27So what is left in the feature?
00:29So these three reports are left in the feature
00:32Let's add these three reports in our form
00:35Now what will be the benefit of this?
00:37Our form is going to open as an application
00:39So in that application, we don't need to come again and again
00:43The report file will open with one click
00:46So now what we will do is, we will add a button
00:48A separate button for these three
00:51And how to add a button, you must know
00:53You just have to come to the design view
00:55And here we will get the button option
00:58After clicking, we will come down a little
01:02We will create a button for all three of them
01:05So first of all, let's start with the button of our primary class report
01:10So where do we want to create the button?
01:13Here we will get the report operation
01:15Here we will get the open report
01:17We will simply click on next
01:19Now which report do we want to open?
01:21We want to open the primary class report
01:24We will write the text as open report
01:27So instead of open report, we will write student list
01:36Now our student list is going to open with one click
01:40And let's make it a little bigger
01:45Perfect, let's mention it here
01:48So now our student list will be created with one click
01:51Let's copy and paste it here
01:56So now the format is perfect
02:00Similarly, let's make a shortcut for the other two reports
02:04So now we have a student list
02:06Let me access it first
02:08After that, we will make our next button
02:12So basically, when I click on it
02:14It will ask which student list do you want?
02:18So let's say I want the list of first class students
02:22So the report of first class students will appear here
02:26So it will work like this
02:28So let's close it
02:29And basically, we have to edit the name
02:33So it will be class wise student list
02:35Because our main list was primary report
02:38So it will have all student list
02:40So let's write class wise
02:42So that we don't have any problem
02:45So let's make a bracket for student list
02:52Class wise
02:54So now we have a bracket here
02:57Let's make it a little bigger
02:59Here we can see the complete test
03:02So we get student list class wise
03:05Let's make it a little bigger
03:09And let's bring it down
03:14Okay, so here
03:16Okay, perfect
03:18It's looking good
03:19Now let's create one more button here
03:21All student list button
03:23Which is mandatory
03:25Because if we are giving so many students
03:27Then we have to give all students too
03:29So basically, here
03:30Sorry, here
03:31Report operation
03:32Open report
03:33And here we will get primary report
03:36Now we will write here
03:39All students list
03:44And here I forgot to cut it
03:47Okay, so here
03:49We wrote all student list
03:51And we finished it
03:52So here
03:53Okay, here I think the button has come
03:55How did it come here?
03:56So let's move it here
04:02Okay
04:03So I think it was selected there
04:05Because of the cursor of the mouse
04:07It went there
04:08So let's make it a little bigger
04:10Button will be almost of this size
04:12Perfect
04:13Now in this
04:14We are going to do the same thing
04:17Format painting
04:18Okay, perfect
04:19So now here it's done
04:21These two buttons are ready
04:23Let's come back to our view tab
04:25And if I click on all student list
04:27Then all my students list comes here
04:30So it's perfect here
04:32Okay
04:33After that here
04:34Student list class wise
04:36So for example
04:37If I type second class here
04:38So all the students of second class
04:40Their list comes here
04:41And it was also written above
04:43Report of class second
04:44Perfect
04:45And here we have to make one more button
04:47In which we have to do
04:49Unpaid list
04:50Students who have not paid the fees
04:52Okay
04:53So let's make a button for that too
04:55Let's come back to our view
05:00Design view
05:02One more button please
05:03And let's make a button here
05:07Report
05:09Open report
05:11Fees
05:12Unpaid
05:13We will write the text here
05:16Unpaid student
05:19Spelling mistake here
05:22Students
05:23Okay
05:25So here we have written unpaid student
05:28We will make it bigger
05:29And we will change the color of this
05:32So that it looks a little different
05:35From the rest of the list
05:37So let's copy the format here
05:42And let's paste it here
05:44Okay
05:45So here it looks red
05:46So not red
05:47Red is not looking good
05:49Let's make it purple
05:51Purple is also not looking good
05:52We have to take a little dark color
05:54Okay
05:55So this color is okay here
05:56Let's come to the view once
05:58How is this color looking
05:59Okay
06:00Perfect
06:01Was it okay
06:02We will have to change the color again
06:08Because I am not liking the color
06:10So let's keep a color that matches
06:12The last option is red
06:14But we get something else other than red
06:16Green
06:17Okay
06:18Green is looking perfect
06:19And it matches with the background
06:20And it matches with the text
06:22Okay
06:23So here all these keys are made
06:25Now all the work is done in these keys
06:27I will arrange it a little
06:29It will come down
06:30Unpaid student
06:31Okay
06:32Okay
06:33Perfect
06:34So here all these things are made
06:36So let's come back to our normal form view
06:42Let's come to the form view
06:43We have to record the add new
06:45Here I can add new
06:46I will write the name of the student
06:48I will write the enrollment number
06:51155
06:52I will select the class from here
06:555th class
06:56I will write the date of birth
06:5831
06:5910
07:002005
07:02And here
07:03I forgot to mark
07:04Okay perfect
07:05So here I will write the date of birth
07:07So here it is written
07:08Please select the correct date of birth
07:10So
07:11I think there is a mark problem
07:14So I will put this sign here
07:17Okay
07:18So there is no error here
07:20Actually here
07:21I put the minus sign
07:22May be because of that
07:23There is an error
07:24So here their fees is 10,000 rupees
07:26It has come
07:27Okay
07:28After that
07:29We don't have to put the photo
07:30After that
07:31Here tuition fees
07:325,000 rupees
07:33That has also been paid
07:34Let's type their pen number
07:36Here
07:37Pen number also came
07:38And here we have saved the record
07:40Okay
07:41After that simply add new record
07:42If you want to come to the previous record
07:44Whatever record we want
07:45You can see here
07:46And here
07:47Let's put one more thing
07:48On the enrollment number base
07:49Let's put a search button
07:51So that
07:52We can search directly from the enrollment number
07:54Our student
07:56So let's put a last button
07:58After that
07:59I will teach you how to convert it in the software
08:01So for the last button
08:02Let's come back to our button tab
08:04And
08:05Let's put this
08:06Let's put it here
08:08And let's make it small
08:10First let's do one thing
08:11Our tab
08:12Enrollment number
08:13Let's make it small
08:15Because enrollment number
08:16We don't have a big one
08:18And let's do this
08:19Align center
08:20Okay
08:21So there is not a big enrollment number
08:22We have three digit enrollment number
08:24That's enough for this
08:25Space
08:26After that
08:27Let's put a button
08:28On this side
08:29So that
08:30We can know
08:31That we are putting a button for this
08:32Okay
08:33So here
08:34This button came
08:37Ctrl Z
08:38Yes
08:39Delete
08:40Again
08:41Ctrl Z
08:43Okay
08:44So basically
08:45The button was clicking there
08:46Again and again
08:47So here
08:48Let's put a button here
08:49Okay
08:50Here
08:51So basically
08:52What was the problem here
08:53I made a mistake
08:55Because
08:56Instead of design view
08:57I was working in layout view
08:59That's why
09:00I was not able to select there
09:01Okay
09:02So here
09:03We come back to design view
09:04And here
09:05We select the button
09:06And here
09:07We make our button
09:09So simply
09:10We make a button of find record
09:11And here
09:12We write text
09:14Search
09:15Okay
09:16And here
09:17Next
09:18Finish
09:19Now here you can see
09:20I have a search command
09:21Has come
09:22Now
09:23What I have to do
09:24Is
09:25Simply
09:26I copy the format
09:27From here
09:29Quit
09:30Okay
09:31Sorry
09:33Here
09:34I have to copy the format
09:35And here
09:36I paste it
09:37Okay
09:38So here
09:39I have a search button
09:40Has come
09:41So let's test it
09:42Once
09:43We come to form view
09:44And here
09:45We search
09:46Now
09:47Here
09:48I have to search
09:49My 124 number data
09:50So simply
09:51I will search here
09:52You can see
09:53Here
09:54My
09:55Data
09:56Has come
09:57155
09:58I search
09:59Here
10:00Data
10:01Has come
10:02148
10:03I search
10:04So data of Khushi
10:05Has come here
10:06And
10:07I search
10:08129
10:09So
10:10In 129
10:11Name was empty
10:12So that data
10:13Has come here
10:14In 130
10:15Data of King
10:16Has come
10:17In 135
10:18Data of Mayank
10:19Has come here
10:20Okay
10:21So from this type
10:22We can search
10:23Okay
10:24So here
10:25Till now
10:26We have learnt
10:27How to search
10:28Data
10:29Almost
10:30Everything is done
10:31So let's close
10:32The report
10:33And
10:34Now
10:35Our software
10:36Here
10:37The file
10:38Which we have made
10:39In MS Excel
10:40We convert it
10:41In our
10:42Software
10:43How to convert
10:44In software
10:45Now
10:46The step
10:47Which is coming
10:48Is
10:49To convert
10:50The file
10:51Now
10:52The step
10:53Which is coming
10:54Is very
10:55Important
10:56So watch
10:57Carefully
10:58Because
10:59Now we are going
11:00To convert
11:01Our MS Excel
11:02File in a
11:03Software
11:04Based
11:05How to
11:06Convert
11:07So let's
11:08Start
11:09First
11:10You have to
11:11Come on
11:12File
11:13And
11:14You will get
11:15An option
11:16Of option
11:17Okay
11:18So here
11:19I click
11:20On
11:21Option
11:22And
11:23I click
11:24On
11:25Option
11:26And
11:27I click
11:28On
11:29Option
11:30And
11:31I click
11:32On
11:33Option
11:34And
11:35I click
11:36On
11:37Option
11:38And
11:39I click
11:40On
11:41Option
11:42And
11:43I click
11:44On
11:45Option
11:46And
11:47I click
11:48On
11:49Option
11:50And
11:51I click
11:52On
11:53Option
11:54And
11:55I click
11:56On
11:57Option
11:58And
11:59I click
12:00On
12:01Option
12:02And
12:03I click
12:04On
12:05Option
12:06And
12:07I click
12:08On
12:09Option
12:10And
12:11I click
12:12On
12:13Option
12:14And
12:15I click
12:16On
12:17Option
12:18And
12:19I click
12:20On
12:21Option
12:22And
12:23I click
12:24On
12:25Option
12:26And
12:27I click
12:28On
12:29Option
12:30And
12:31I click
12:32On
12:33Option
12:34And
12:35I click
12:36On
12:37Option
12:38And
12:39I click
12:40On
12:41Option
12:42And
12:43I click
12:44On
12:45Option
12:46And
12:47I click
12:48On
12:49Option
12:50And
12:51I click
12:52On
12:53Option
12:54And
12:55I click
12:56On
12:57Option
12:58And
12:59I click
13:00On
13:01Option
13:02And
13:03I click
13:04On
13:05Option
13:06And
13:07I click
13:08On
13:09Option
13:10And
13:11I click
13:12On
13:13Option
13:14And
13:15I click
13:16On
13:17Option
13:18And
13:19I click
13:20On
13:21Option
13:22And
13:23I click
13:24On
13:25Option
13:26And
13:27I click
13:28On
13:29Option
13:30And
13:31I click
13:32On
13:33Option
13:34And
13:35I click
13:36On
13:37Option
13:38And
13:39I click
13:40On
13:41Option
13:42And
13:43I click
13:44On
13:45Option
13:46And
13:47I click
13:48On
13:49Option
13:50And
13:51I click
13:52On
13:53Option
13:54And
13:55I click
13:56On
13:57Option
13:58And
13:59I click
14:00On
14:01Option
14:02And
14:03I click
14:04On
14:05Option
14:06And
14:07I click
14:08On
14:09Option
14:10And
14:11I click
14:12On
14:13Option
14:14And
14:15I click
14:16On
14:17Option
14:18And
14:19I click
14:20On
14:21Option
14:22And
14:23I click
14:24On
14:25Option
14:26And
14:27I click
14:28On
14:29Option
14:30And
14:31I click
14:32On
14:33Option
14:34And
14:35I click
14:36On
14:37Option
14:38And
14:39I click
14:40On
14:41Option
14:42And
14:43I click
14:44On
14:45Option
14:46And
14:47I click
14:48On
14:49Option
14:50And
14:51I click
14:52On
14:53Option
14:54And
14:55I click
14:56On
14:57Option
14:58And
14:59I click
15:00On
15:01Option
15:02And
15:03I click
15:04On
15:05Option
15:06And
15:07I click
15:08On
15:09Option
15:10And
15:11I click
15:12On
15:13Option
15:14And
15:15I click
15:16On
15:17Option
15:18And
15:19I click
15:20On
15:21Option
15:22And
15:23I click
15:24On
15:25Option
15:26And
15:27I click
15:28On
15:29Option
15:30And
15:31I click
15:32On
15:33Option
15:34And
15:35I click
15:36On
15:37Option
15:38And
15:39I click
15:40On
15:41Option
15:42And
15:43I click
15:44On
15:45Option
15:46And
15:47I click
15:48On
15:49Option
15:50And
15:51I click
15:52On
15:53Option
15:54And
15:55I click
15:56On
15:57Option
15:58And
15:59I click
16:00On
16:01Option
16:02And
16:03I click
16:04On
16:05Option
16:06And
16:07I click
16:08On
16:09Option
16:10And
16:11I click
16:12On
16:13Option
16:14And
16:15I click
16:16On
16:17Option
16:18And
16:19I click
16:20On
16:21Option
16:22And
16:23I click
16:24On
16:25Option
16:26And
16:27I click
16:28On
16:29Option
16:30And
16:31I click
16:32On
16:33Option
16:34And
16:35I click
16:36On
16:37Option
16:38And
16:39I click
16:40On
16:41Option
16:42And
16:43I click
16:44On
16:45Option
16:46And
16:47I click
16:48On
16:49Option
16:50And
16:51I click
16:52On
16:53Option
16:54And
16:55I click
16:56On
16:57Option
16:58And
16:59I click
17:00On
17:01Option
17:02And
17:03I click
17:04On
17:05Option
17:06And
17:07I click
17:08On
17:09Option
17:10And
17:11I click
17:12On
17:13Option
17:14And
17:15I click
17:16On
17:17Option
17:18And
17:19I click
17:20On
17:21Option
17:22And
17:23I click
17:24On
17:25Option
17:26And
17:27I click
17:28On
17:29Option
17:30And
17:31I click
17:32On
17:33Option
17:34And
17:35I click
17:36On
17:37Option
17:38And
17:39I click
17:40On
17:41Option
17:42And
17:43I click
17:44On
17:45Option
17:46And
17:47I click
17:48On
17:49Option
17:50And
17:51I click
17:52On
17:53Option
17:54And
17:55I click
17:56On
17:57Option
17:58And
17:59I click
18:00On
18:01Option
18:02And
18:03I click
18:04On
18:05Option
18:06And
18:07I click
18:08On
18:09Option
18:10And
18:11I click
18:12On
18:13Option
18:14And
18:15I click
18:16On
18:17Option
18:18And
18:19I click
18:20On
18:21Option
18:22And
18:23I click
18:24On
18:25Option
18:26And
18:27I click
18:28On
18:29Option
18:30And
18:31I click
18:32On
18:33Option
18:34And
18:35I click
18:36On
18:37Option
18:38And
18:39I click
18:40On
18:41Option
18:42And
18:43I click
18:44On
18:45Option
18:46And
18:47I click
18:48On
18:49Option
18:50And
18:51I click
18:52On
18:53Option
18:54And
18:55I click
18:56On
18:57Option
18:58And
18:59I click
19:00On
19:01Option
19:02And
19:03I click