ALL TUTORIALS.
Category
📚
LearningTranscript
00:00Welcome again, in the last class, as I told you
00:04In this class, we will learn how to make a class-wise report
00:08If you want to make a class-wise report
00:11Then you have to take the data from somewhere
00:14We are going to take the data from the primary table
00:17It's a common thing
00:18We are going to take the data from the primary table
00:20And we have to collect all the data equally
00:23And we can't make a new table
00:25Because the main table of storage is the primary table
00:30So how can we make a new table and put the data in the report section
00:35The solution for this is query creation
00:38As we made a primary query here
00:41In which the data of the primary table was complete
00:44As you can see here, this is our query
00:47And this is our primary table
00:49Both had similar data
00:50But we can add one or two additional fields
00:54In the same way, we will create another query
00:57Which will be connected to our primary table
01:00And we are going to put that new query in the report
01:04So how are we going to do this?
01:06First of all, let's close all of them
01:10So we have closed all of them
01:12Let's leave it open
01:14And here we come to create
01:16We will create from query wizard
01:18Simple query wizard
01:21Now we can see what all we need
01:24So basically, we are going to take all the data from the report section
01:30There is no point in taking more data
01:32Because it is not useful for us
01:34So let's take ID, Name, Enrollment number, Class
01:38Class is important because we are going to separate it from the class
01:42Date of birth, Fees paid and Pen number
01:46So we have taken this
01:48Let's click on next
01:50Let's click on detail and next
01:52And let's name it
01:54Instead of primary table query
01:56Let's name it as primary class query
01:58And let's click on finish
02:00So you can see here
02:02I have all the data
02:04Here I have 3rd, 4th, 5th, 2nd, 7th
02:08I have all the combined data of all the classes
02:11Now what I have to do is
02:13I have to create a criteria
02:15That I have data of the class I want
02:17How can we do that?
02:19For that, I have to come here
02:21In design view
02:23So let's come in design view
02:25So you can see primary class query is open
02:27And here is the criteria section
02:29What do we have to put in criteria?
02:31We have to put it in our class
02:33So in class, we put criteria
02:35With a command
02:37What is the command?
02:39So the command is like
02:41Then after that
02:43We have to create a box bracket
02:45After that we have to write
02:47Type class
02:49And let's take an example
02:51eg
02:53Let's give an example
02:55First
02:57So for this type
02:59We need our data
03:01Now let's save it with the help of ctrl s
03:03And let's come back
03:05In our view
03:07In view
03:09So when we come in view section
03:11We are asked which class data do you want?
03:13So here we put
03:15First class
03:17So now you can see I have only first class data
03:19Available
03:21It is showing only first class data
03:23So this is a very good setup
03:25Whenever I come back in view
03:27Now I put second
03:29So now I have only second class data
03:31So from this type
03:33This is an amazing command
03:35Which distributes class wise
03:37Now with the help of this query
03:39We will create our report
03:41How will we do that?
03:43Normally we create a report
03:45By clicking on report wizard
03:47And from here
03:49We get to select
03:51From which report
03:53You want to create
03:55So here we have primary table, primary query
03:57And primary class query
03:59Which we created recently
04:01So from this we need name
04:03Enrollment number, class, date of birth
04:05Fees paid or not
04:07And PAN card
04:09So here we have selected 6 fields
04:11And I think date of birth is not required
04:13So let's remove date of birth
04:155 fields are enough
04:17Now let's click on next
04:19We don't want to do grouping
04:21We want to do ascending order
04:23Enrollment number wise
04:25Tabular in layout
04:27What should we name it?
04:29We want to name it
04:31Class report
04:33So here
04:35Primary class report will open
04:37Now I will click on finish
04:39As soon as our primary class report is ready
04:41It asks which class data do you want
04:43For example
04:45You can type first
04:47So you can type
04:49FIRST
04:51FIRST
04:53So you can see
04:55I have first class data
04:57And nothing else
04:59We can edit it
05:03To edit it
05:05You have to follow the same settings
05:07Which we followed in our last class
05:09So follow the same
05:11It's not good to repeat the same
05:13You have learned it once
05:15So follow it
05:17I will give you a hint
05:19What you have to do
05:21You have to set borderline, tabular
05:23Then grade line
05:25And name it
05:27It will look good
05:29Let's name it
05:31Let's bold it
05:33And
05:35Our class
05:37Let's name it
05:39What is it's name?
05:41Class
05:43Report
05:45Or
05:47Let's do this
05:49Report
05:51Of
05:53Class
05:55Let's make it red
05:57Let's bold it
05:59Let's make it
06:01Bigger
06:03Ok
06:05So report of class
06:07We have typed this much
06:09Now
06:11I have thought something new
06:13Let me show you
06:15Let's go to view
06:17You can see first
06:19So basically
06:21Everything is given in class
06:23But
06:25We don't need it
06:27Because we have searched first class data
06:29So we don't need to
06:31Write first class student
06:33So we don't need it
06:35How can we change it?
06:37Let's go to
06:39Design view
06:41I have two things
06:43Let's select both
06:45Let's bring it up
06:47It didn't come up
06:49Ok
06:51One by one
06:53It will come up
06:59Ok
07:01It comes up
07:03Ok
07:05Let's delete it
07:07It's not useful
07:09And
07:11Let's slide it
07:13Little bit
07:15And
07:17Let's slide it
07:19Little bit
07:21And
07:23Let's make it bigger
07:25Ok
07:27It's perfect
07:29Let's align it
07:31In format
07:33Align left
07:35So
07:37Our class
07:39Will be written here
07:41Let me show you
07:43Let's view it
07:45So
07:47You can see
07:49Report of class 2nd
07:51In bracket
07:53We have put class
07:55Now it's here
07:57Now we can see
07:59Name, Fees, Payment
08:01And we can see
08:03It's a 2nd class report
08:05We can edit it
08:07It's looking different
08:09Let's do the same
08:11With the help of format painter
08:13Let's put bold words
08:15So that it looks
08:17Similar
08:19Ok
08:21Now
08:23Let's select
08:25Format painter
08:27After that
08:29Here
08:35Let's select it
08:37And put it in the middle
08:39Ok
08:41So
08:43It's looking same
08:45And
08:47Actually
08:49It's a little bit difficult
08:51To adjust
08:53So
08:55Let's adjust it
08:57Ok
08:59Now
09:01It's easy
09:03Let's put
09:053rd class
09:07Now you can see
09:09The report
09:11Let's change the color
09:13So that it looks different
09:15And we can see
09:17It's a 3rd class report
09:19Let's slide it
09:21It's very easy to learn
09:23MS Access
09:25I hope you understood
09:27How we work in MS Access
09:29I think
09:31It's very easy
09:33I have made this course
09:35Very simple for you
09:37So that you don't have to
09:39Work hard
09:41And what we are doing now
09:43It's an advanced level course
09:45Because
09:47We won't teach you
09:49How to make a form
09:51We won't teach you how to connect a table
09:53So here
09:55I have mixed all my knowledge
09:57And made a basic advanced level course
09:59So that you can easily
10:01Understand
10:03How you can use MS Access
10:06So
10:08Let's see
10:10The last example
10:12So here
10:14I can see the report of class 2nd
10:16So
10:18In this way
10:20You can mix your report
10:22So you don't have to
10:24Make a class wise report
10:26Simply
10:28We have created a query
10:30Based on the query
10:32We have created a report
10:34You can see
10:36This is our class wise report
10:38Now you have to
10:40Who has paid the fees
10:42Who hasn't
10:44If you want to get the report
10:46How will you get it
10:48There are many ways
10:50Let's create a new query
10:52We will put a command
10:54We will put a formula
10:56Who hasn't paid the fees
10:58Let's learn it
11:00So
11:02Here
11:04We come to create
11:06Here
11:08Simple query wizard
11:10We have to take everything
11:12From the primary table
11:14So from the primary table
11:16Which data we will like to take
11:18For our report
11:20Name, enrollment number, class, date of birth
11:22And fees paid
11:24Or not
11:26Which is important
11:28After that
11:30Let's do it
11:32We have to name it
11:34Primary
11:36Fees
11:38Unpaid
11:40List
11:42Unpaid spelling is wrong
11:44Let's correct it
11:46We are creating a list
11:48So
11:50All the data is here
11:52Who has paid the fees
11:54Now
11:56We have to come back
11:58Design view
12:00And
12:02Which data type we have put
12:04Yes or no
12:06I will write simply
12:08And or no
12:10After that
12:12You can see
12:14Who hasn't paid the fees
12:16I can see their name
12:18In the same way
12:20Let's create a report
12:22Wizard the report
12:24Yes
12:26Unpaid list
12:28Next
12:30In ascending order
12:32Next
12:34And finish
12:36You can see
12:38The list of people who haven't paid the fees
12:40You can do it
12:42According to your requirement
12:44I hope you got to know
12:46How you can arrange
12:48Data class wise
12:50How you can arrange data fees wise
12:52How you can make a report
12:54If you haven't paid the fees
12:56Now
12:58The course is almost over
13:00I am going to bring the last class
13:02Which is going to be very interesting
13:04As you can see
13:06We have created a form
13:08Primary table form
13:10We have added a lot of keys
13:12We have made a good form
13:14Now
13:16We have to show this to our staff
13:18They will get confused
13:20If I tell my staff
13:22Here is the table
13:24Start working on it
13:26The staff will get confused
13:28Because they haven't seen this
13:30They haven't used this
13:32If they are not familiar with computer
13:34They just know how to use
13:36A normal data entry software
13:38For that
13:40We will make our MS Access
13:42A data entry software
13:44Because our MS Access
13:46Is a database management system
13:48So here
13:50We will make it a software
13:52In which only our form will be visible
13:54Nothing else
13:56So how do we do that
13:58I am going to tell you in detail
14:00In the last class of this course
14:02So the course is almost over
14:04There is one last class
14:06Which will come very soon
14:08So let's meet in our last
14:10MS Access class