Skip to main content
Search
Connect
Watch fullscreen
Like
Bookmark
Share
More
Add to Playlist
Report
MS Access_ Class 10 - The End _ Hindi_ Urdu
Earning & Learning
Follow
1 year ago
ALL TUTORIALS.
Category
📚
Learning
Transcript
Display full video transcript
00:00
This is the last and final video of our MS Access course
00:05
In this video, I am going to tell you a step
00:09
With the help of which you can open this form as a separate application
00:15
So basically, before opening it as a separate application
00:19
Let's add some more features in this form
00:23
So that we don't need these tools again and again
00:27
So what is left in the feature?
00:29
So these three reports are left in the feature
00:32
Let's add these three reports in our form
00:35
Now what will be the benefit of this?
00:37
Our form is going to open as an application
00:39
So in that application, we don't need to come again and again
00:43
The report file will open with one click
00:46
So now what we will do is, we will add a button
00:48
A separate button for these three
00:51
And how to add a button, you must know
00:53
You just have to come to the design view
00:55
And here we will get the button option
00:58
After clicking, we will come down a little
01:02
We will create a button for all three of them
01:05
So first of all, let's start with the button of our primary class report
01:10
So where do we want to create the button?
01:13
Here we will get the report operation
01:15
Here we will get the open report
01:17
We will simply click on next
01:19
Now which report do we want to open?
01:21
We want to open the primary class report
01:24
We will write the text as open report
01:27
So instead of open report, we will write student list
01:36
Now our student list is going to open with one click
01:40
And let's make it a little bigger
01:45
Perfect, let's mention it here
01:48
So now our student list will be created with one click
01:51
Let's copy and paste it here
01:56
So now the format is perfect
02:00
Similarly, let's make a shortcut for the other two reports
02:04
So now we have a student list
02:06
Let me access it first
02:08
After that, we will make our next button
02:12
So basically, when I click on it
02:14
It will ask which student list do you want?
02:18
So let's say I want the list of first class students
02:22
So the report of first class students will appear here
02:26
So it will work like this
02:28
So let's close it
02:29
And basically, we have to edit the name
02:33
So it will be class wise student list
02:35
Because our main list was primary report
02:38
So it will have all student list
02:40
So let's write class wise
02:42
So that we don't have any problem
02:45
So let's make a bracket for student list
02:52
Class wise
02:54
So now we have a bracket here
02:57
Let's make it a little bigger
02:59
Here we can see the complete test
03:02
So we get student list class wise
03:05
Let's make it a little bigger
03:09
And let's bring it down
03:14
Okay, so here
03:16
Okay, perfect
03:18
It's looking good
03:19
Now let's create one more button here
03:21
All student list button
03:23
Which is mandatory
03:25
Because if we are giving so many students
03:27
Then we have to give all students too
03:29
So basically, here
03:30
Sorry, here
03:31
Report operation
03:32
Open report
03:33
And here we will get primary report
03:36
Now we will write here
03:39
All students list
03:44
And here I forgot to cut it
03:47
Okay, so here
03:49
We wrote all student list
03:51
And we finished it
03:52
So here
03:53
Okay, here I think the button has come
03:55
How did it come here?
03:56
So let's move it here
04:02
Okay
04:03
So I think it was selected there
04:05
Because of the cursor of the mouse
04:07
It went there
04:08
So let's make it a little bigger
04:10
Button will be almost of this size
04:12
Perfect
04:13
Now in this
04:14
We are going to do the same thing
04:17
Format painting
04:18
Okay, perfect
04:19
So now here it's done
04:21
These two buttons are ready
04:23
Let's come back to our view tab
04:25
And if I click on all student list
04:27
Then all my students list comes here
04:30
So it's perfect here
04:32
Okay
04:33
After that here
04:34
Student list class wise
04:36
So for example
04:37
If I type second class here
04:38
So all the students of second class
04:40
Their list comes here
04:41
And it was also written above
04:43
Report of class second
04:44
Perfect
04:45
And here we have to make one more button
04:47
In which we have to do
04:49
Unpaid list
04:50
Students who have not paid the fees
04:52
Okay
04:53
So let's make a button for that too
04:55
Let's come back to our view
05:00
Design view
05:02
One more button please
05:03
And let's make a button here
05:07
Report
05:09
Open report
05:11
Fees
05:12
Unpaid
05:13
We will write the text here
05:16
Unpaid student
05:19
Spelling mistake here
05:22
Students
05:23
Okay
05:25
So here we have written unpaid student
05:28
We will make it bigger
05:29
And we will change the color of this
05:32
So that it looks a little different
05:35
From the rest of the list
05:37
So let's copy the format here
05:42
And let's paste it here
05:44
Okay
05:45
So here it looks red
05:46
So not red
05:47
Red is not looking good
05:49
Let's make it purple
05:51
Purple is also not looking good
05:52
We have to take a little dark color
05:54
Okay
05:55
So this color is okay here
05:56
Let's come to the view once
05:58
How is this color looking
05:59
Okay
06:00
Perfect
06:01
Was it okay
06:02
We will have to change the color again
06:08
Because I am not liking the color
06:10
So let's keep a color that matches
06:12
The last option is red
06:14
But we get something else other than red
06:16
Green
06:17
Okay
06:18
Green is looking perfect
06:19
And it matches with the background
06:20
And it matches with the text
06:22
Okay
06:23
So here all these keys are made
06:25
Now all the work is done in these keys
06:27
I will arrange it a little
06:29
It will come down
06:30
Unpaid student
06:31
Okay
06:32
Okay
06:33
Perfect
06:34
So here all these things are made
06:36
So let's come back to our normal form view
06:42
Let's come to the form view
06:43
We have to record the add new
06:45
Here I can add new
06:46
I will write the name of the student
06:48
I will write the enrollment number
06:51
155
06:52
I will select the class from here
06:55
5th class
06:56
I will write the date of birth
06:58
31
06:59
10
07:00
2005
07:02
And here
07:03
I forgot to mark
07:04
Okay perfect
07:05
So here I will write the date of birth
07:07
So here it is written
07:08
Please select the correct date of birth
07:10
So
07:11
I think there is a mark problem
07:14
So I will put this sign here
07:17
Okay
07:18
So there is no error here
07:20
Actually here
07:21
I put the minus sign
07:22
May be because of that
07:23
There is an error
07:24
So here their fees is 10,000 rupees
07:26
It has come
07:27
Okay
07:28
After that
07:29
We don't have to put the photo
07:30
After that
07:31
Here tuition fees
07:32
5,000 rupees
07:33
That has also been paid
07:34
Let's type their pen number
07:36
Here
07:37
Pen number also came
07:38
And here we have saved the record
07:40
Okay
07:41
After that simply add new record
07:42
If you want to come to the previous record
07:44
Whatever record we want
07:45
You can see here
07:46
And here
07:47
Let's put one more thing
07:48
On the enrollment number base
07:49
Let's put a search button
07:51
So that
07:52
We can search directly from the enrollment number
07:54
Our student
07:56
So let's put a last button
07:58
After that
07:59
I will teach you how to convert it in the software
08:01
So for the last button
08:02
Let's come back to our button tab
08:04
And
08:05
Let's put this
08:06
Let's put it here
08:08
And let's make it small
08:10
First let's do one thing
08:11
Our tab
08:12
Enrollment number
08:13
Let's make it small
08:15
Because enrollment number
08:16
We don't have a big one
08:18
And let's do this
08:19
Align center
08:20
Okay
08:21
So there is not a big enrollment number
08:22
We have three digit enrollment number
08:24
That's enough for this
08:25
Space
08:26
After that
08:27
Let's put a button
08:28
On this side
08:29
So that
08:30
We can know
08:31
That we are putting a button for this
08:32
Okay
08:33
So here
08:34
This button came
08:37
Ctrl Z
08:38
Yes
08:39
Delete
08:40
Again
08:41
Ctrl Z
08:43
Okay
08:44
So basically
08:45
The button was clicking there
08:46
Again and again
08:47
So here
08:48
Let's put a button here
08:49
Okay
08:50
Here
08:51
So basically
08:52
What was the problem here
08:53
I made a mistake
08:55
Because
08:56
Instead of design view
08:57
I was working in layout view
08:59
That's why
09:00
I was not able to select there
09:01
Okay
09:02
So here
09:03
We come back to design view
09:04
And here
09:05
We select the button
09:06
And here
09:07
We make our button
09:09
So simply
09:10
We make a button of find record
09:11
And here
09:12
We write text
09:14
Search
09:15
Okay
09:16
And here
09:17
Next
09:18
Finish
09:19
Now here you can see
09:20
I have a search command
09:21
Has come
09:22
Now
09:23
What I have to do
09:24
Is
09:25
Simply
09:26
I copy the format
09:27
From here
09:29
Quit
09:30
Okay
09:31
Sorry
09:33
Here
09:34
I have to copy the format
09:35
And here
09:36
I paste it
09:37
Okay
09:38
So here
09:39
I have a search button
09:40
Has come
09:41
So let's test it
09:42
Once
09:43
We come to form view
09:44
And here
09:45
We search
09:46
Now
09:47
Here
09:48
I have to search
09:49
My 124 number data
09:50
So simply
09:51
I will search here
09:52
You can see
09:53
Here
09:54
My
09:55
Data
09:56
Has come
09:57
155
09:58
I search
09:59
Here
10:00
Data
10:01
Has come
10:02
148
10:03
I search
10:04
So data of Khushi
10:05
Has come here
10:06
And
10:07
I search
10:08
129
10:09
So
10:10
In 129
10:11
Name was empty
10:12
So that data
10:13
Has come here
10:14
In 130
10:15
Data of King
10:16
Has come
10:17
In 135
10:18
Data of Mayank
10:19
Has come here
10:20
Okay
10:21
So from this type
10:22
We can search
10:23
Okay
10:24
So here
10:25
Till now
10:26
We have learnt
10:27
How to search
10:28
Data
10:29
Almost
10:30
Everything is done
10:31
So let's close
10:32
The report
10:33
And
10:34
Now
10:35
Our software
10:36
Here
10:37
The file
10:38
Which we have made
10:39
In MS Excel
10:40
We convert it
10:41
In our
10:42
Software
10:43
How to convert
10:44
In software
10:45
Now
10:46
The step
10:47
Which is coming
10:48
Is
10:49
To convert
10:50
The file
10:51
Now
10:52
The step
10:53
Which is coming
10:54
Is very
10:55
Important
10:56
So watch
10:57
Carefully
10:58
Because
10:59
Now we are going
11:00
To convert
11:01
Our MS Excel
11:02
File in a
11:03
Software
11:04
Based
11:05
How to
11:06
Convert
11:07
So let's
11:08
Start
11:09
First
11:10
You have to
11:11
Come on
11:12
File
11:13
And
11:14
You will get
11:15
An option
11:16
Of option
11:17
Okay
11:18
So here
11:19
I click
11:20
On
11:21
Option
11:22
And
11:23
I click
11:24
On
11:25
Option
11:26
And
11:27
I click
11:28
On
11:29
Option
11:30
And
11:31
I click
11:32
On
11:33
Option
11:34
And
11:35
I click
11:36
On
11:37
Option
11:38
And
11:39
I click
11:40
On
11:41
Option
11:42
And
11:43
I click
11:44
On
11:45
Option
11:46
And
11:47
I click
11:48
On
11:49
Option
11:50
And
11:51
I click
11:52
On
11:53
Option
11:54
And
11:55
I click
11:56
On
11:57
Option
11:58
And
11:59
I click
12:00
On
12:01
Option
12:02
And
12:03
I click
12:04
On
12:05
Option
12:06
And
12:07
I click
12:08
On
12:09
Option
12:10
And
12:11
I click
12:12
On
12:13
Option
12:14
And
12:15
I click
12:16
On
12:17
Option
12:18
And
12:19
I click
12:20
On
12:21
Option
12:22
And
12:23
I click
12:24
On
12:25
Option
12:26
And
12:27
I click
12:28
On
12:29
Option
12:30
And
12:31
I click
12:32
On
12:33
Option
12:34
And
12:35
I click
12:36
On
12:37
Option
12:38
And
12:39
I click
12:40
On
12:41
Option
12:42
And
12:43
I click
12:44
On
12:45
Option
12:46
And
12:47
I click
12:48
On
12:49
Option
12:50
And
12:51
I click
12:52
On
12:53
Option
12:54
And
12:55
I click
12:56
On
12:57
Option
12:58
And
12:59
I click
13:00
On
13:01
Option
13:02
And
13:03
I click
13:04
On
13:05
Option
13:06
And
13:07
I click
13:08
On
13:09
Option
13:10
And
13:11
I click
13:12
On
13:13
Option
13:14
And
13:15
I click
13:16
On
13:17
Option
13:18
And
13:19
I click
13:20
On
13:21
Option
13:22
And
13:23
I click
13:24
On
13:25
Option
13:26
And
13:27
I click
13:28
On
13:29
Option
13:30
And
13:31
I click
13:32
On
13:33
Option
13:34
And
13:35
I click
13:36
On
13:37
Option
13:38
And
13:39
I click
13:40
On
13:41
Option
13:42
And
13:43
I click
13:44
On
13:45
Option
13:46
And
13:47
I click
13:48
On
13:49
Option
13:50
And
13:51
I click
13:52
On
13:53
Option
13:54
And
13:55
I click
13:56
On
13:57
Option
13:58
And
13:59
I click
14:00
On
14:01
Option
14:02
And
14:03
I click
14:04
On
14:05
Option
14:06
And
14:07
I click
14:08
On
14:09
Option
14:10
And
14:11
I click
14:12
On
14:13
Option
14:14
And
14:15
I click
14:16
On
14:17
Option
14:18
And
14:19
I click
14:20
On
14:21
Option
14:22
And
14:23
I click
14:24
On
14:25
Option
14:26
And
14:27
I click
14:28
On
14:29
Option
14:30
And
14:31
I click
14:32
On
14:33
Option
14:34
And
14:35
I click
14:36
On
14:37
Option
14:38
And
14:39
I click
14:40
On
14:41
Option
14:42
And
14:43
I click
14:44
On
14:45
Option
14:46
And
14:47
I click
14:48
On
14:49
Option
14:50
And
14:51
I click
14:52
On
14:53
Option
14:54
And
14:55
I click
14:56
On
14:57
Option
14:58
And
14:59
I click
15:00
On
15:01
Option
15:02
And
15:03
I click
15:04
On
15:05
Option
15:06
And
15:07
I click
15:08
On
15:09
Option
15:10
And
15:11
I click
15:12
On
15:13
Option
15:14
And
15:15
I click
15:16
On
15:17
Option
15:18
And
15:19
I click
15:20
On
15:21
Option
15:22
And
15:23
I click
15:24
On
15:25
Option
15:26
And
15:27
I click
15:28
On
15:29
Option
15:30
And
15:31
I click
15:32
On
15:33
Option
15:34
And
15:35
I click
15:36
On
15:37
Option
15:38
And
15:39
I click
15:40
On
15:41
Option
15:42
And
15:43
I click
15:44
On
15:45
Option
15:46
And
15:47
I click
15:48
On
15:49
Option
15:50
And
15:51
I click
15:52
On
15:53
Option
15:54
And
15:55
I click
15:56
On
15:57
Option
15:58
And
15:59
I click
16:00
On
16:01
Option
16:02
And
16:03
I click
16:04
On
16:05
Option
16:06
And
16:07
I click
16:08
On
16:09
Option
16:10
And
16:11
I click
16:12
On
16:13
Option
16:14
And
16:15
I click
16:16
On
16:17
Option
16:18
And
16:19
I click
16:20
On
16:21
Option
16:22
And
16:23
I click
16:24
On
16:25
Option
16:26
And
16:27
I click
16:28
On
16:29
Option
16:30
And
16:31
I click
16:32
On
16:33
Option
16:34
And
16:35
I click
16:36
On
16:37
Option
16:38
And
16:39
I click
16:40
On
16:41
Option
16:42
And
16:43
I click
16:44
On
16:45
Option
16:46
And
16:47
I click
16:48
On
16:49
Option
16:50
And
16:51
I click
16:52
On
16:53
Option
16:54
And
16:55
I click
16:56
On
16:57
Option
16:58
And
16:59
I click
17:00
On
17:01
Option
17:02
And
17:03
I click
17:04
On
17:05
Option
17:06
And
17:07
I click
17:08
On
17:09
Option
17:10
And
17:11
I click
17:12
On
17:13
Option
17:14
And
17:15
I click
17:16
On
17:17
Option
17:18
And
17:19
I click
17:20
On
17:21
Option
17:22
And
17:23
I click
17:24
On
17:25
Option
17:26
And
17:27
I click
17:28
On
17:29
Option
17:30
And
17:31
I click
17:32
On
17:33
Option
17:34
And
17:35
I click
17:36
On
17:37
Option
17:38
And
17:39
I click
17:40
On
17:41
Option
17:42
And
17:43
I click
17:44
On
17:45
Option
17:46
And
17:47
I click
17:48
On
17:49
Option
17:50
And
17:51
I click
17:52
On
17:53
Option
17:54
And
17:55
I click
17:56
On
17:57
Option
17:58
And
17:59
I click
18:00
On
18:01
Option
18:02
And
18:03
I click
18:04
On
18:05
Option
18:06
And
18:07
I click
18:08
On
18:09
Option
18:10
And
18:11
I click
18:12
On
18:13
Option
18:14
And
18:15
I click
18:16
On
18:17
Option
18:18
And
18:19
I click
18:20
On
18:21
Option
18:22
And
18:23
I click
18:24
On
18:25
Option
18:26
And
18:27
I click
18:28
On
18:29
Option
18:30
And
18:31
I click
18:32
On
18:33
Option
18:34
And
18:35
I click
18:36
On
18:37
Option
18:38
And
18:39
I click
18:40
On
18:41
Option
18:42
And
18:43
I click
18:44
On
18:45
Option
18:46
And
18:47
I click
18:48
On
18:49
Option
18:50
And
18:51
I click
18:52
On
18:53
Option
18:54
And
18:55
I click
18:56
On
18:57
Option
18:58
And
18:59
I click
19:00
On
19:01
Option
19:02
And
19:03
I click
Be the first to comment
Add your comment
MS ACCESS Data Base
18:45
|
Up next
MS Access_ Class 10 - The End _ Hindi_ Urdu
Earning & Learning
1 year ago
14:15
MS Access_ Class 09 - Query Trick _ Hindi_ Urdu
Earning & Learning
1 year ago
13:53
MS Access_ Class 08 - Create Report _ Hindi_ Urdu
Earning & Learning
1 year ago
22:42
MS Access _ Class 06 - Create Form _ Hindi_ Urdu _ KB Tech India
Earning & Learning
1 year ago
10:37
MS Access _ Class 07 - Create Buttons _ Hindi_ Urdu _
Earning & Learning
1 year ago
18:33
MS Access _ Class 01 - Introduction _ Hindi_ Urdu
Earning & Learning
1 year ago
Recommended
0:51
Former Aide Claims She Was Asked to Make a ‘Hit List’ For Trump
Veuer
2 years ago
1:08
Musk’s X Is ‘the Platform With the Largest Ratio of Misinformation or Disinformation’ Amongst All Social Media Platforms
Veuer
2 years ago
4:50
59 companies that are changing the world: From Tesla to Chobani
Fortune
2 years ago
0:46
3 Things to Know About Coco Gauff's Parents
People
2 years ago
0:35
8 Things to Do in the Morning to Improve Productivity
Martha Stewart Living
2 years ago
1:18
USC vs. Colorado: Can Caleb Williams Earn a New Heisman Moment?
SportsGrid
2 years ago
1:04
Vic Mensa Reveals Celebrity Crush, Biggest Dating Pet Peeve & More on Speed Dating | Billboard News
Billboard
2 years ago
1:09
Hollywood Writers Reach ‘Tentative Agreement’ With Studios After 146 Day Strike
Veuer
2 years ago
1:26
Love is Blind stars admit they're burnt out from social media
Fortune
2 years ago
2:01
NHA Customers in Limbo as Company Faces Potential Merger
SportsGrid
2 years ago
9:33
Mila Kunis’s Secret to Quick, Super Snatched Glam
Vogue
5 weeks ago
0:46
This Black Bean & Corn Salad Goes With (& On!) Everything
Delish
6 months ago
0:36
Charlie Heaton Shares His Thoughts on Jonathan and Nancy's Story Ending in 'Stranger Things'
People
2 days ago
1:47
LA Firestorm: Extended Trailer for REELZ Wildfire Documentary
ReelzChannel
4 days ago
5:30
How A Tiny Polish Startup Became The Multi-Billion-Dollar Voice Of AI
Forbes
5 weeks ago
0:47
3 Things to Know About Fran Drescher
People
3 days ago
6:13
James Comer: This Is What We Want To Hear From Karine Jean-Pierre Ahead Of Deposition About Biden
Forbes Breaking News
4 months ago
3:17
2025 was the second hottest year on record
AccuWeather
3 days ago
5:57
Chicago Bears Season Review and Playoff Predictions
SportsGrid
20 hours ago
0:53
Charlie Kirk Is Mourned Outside Of Turning Point USA's Headquarters In Phoenix, Arizona
Forbes Breaking News
4 months ago
9:30
We Rode in Xpeng’s Semi-Autonomous EVs. Tesla Should Be Worried
MotorTrend
5 weeks ago
4:37
Key Predictions for NFL Player Props: Wildcard Weekend
SportsGrid
20 hours ago
4:43
Coaching Carousel & Changes in NFL Markets for 2026
SportsGrid
21 hours ago
16:10
Lucy Liu Revisits Her Life in Looks—From Charlie’s Angels to Her Red Carpet Wins
Vogue
4 days ago
1:30
Domestic Violence Suspect Stopped After PIT and Taser Takedown
ReelzChannel
6 weeks ago
0:46
Heavy snow sweeps from Colorado into Kansas
AccuWeather
1 day ago
1:30
Trump plan to send U.S. Big Oil into Venezuela isn't so simple—here's why
Fortune
3 days ago
6:24
Tyler Robinson Said Charlie Kirk 'Was Full Of Hate' At Recent Dinner With Family_ Utah Governor
Forbes Breaking News
4 months ago
2:37
Hunting Dogs Chase Bear Up A Tree | Defenders of the Wild Clip | EarthX
EarthX Media
10 months ago
20:54
Does Mads Mikkelsen Know His Lines?
Variety
3 weeks ago
Be the first to comment