ALL TUTORIALS.
Category
📚
LearningTranscript
00:00Welcome again, this is another new class of MS Access Course
00:05Till now, we have learned how to create table, query and form in MS Access Course
00:11So, one more important thing that we are going to learn in this course is
00:17Report
00:18So, basically, why do we create a report?
00:21First of all, let me tell you that
00:23You can see that in primary table, we get all the data
00:30Student's name, enrollment number, class, date of birth, complete set of data
00:38So, if we want to summarize this data, we can do it with the help of our report
00:44For example, let me give you an example
00:47Let me give you an example, if you have a test book
00:50So, you can see all the data in the test book in the index page
00:58In the same way, you can also consider this report as an index
01:03So, you can see the summarized data
01:07Student's name, enrollment number, class date of birth, complete set of data
01:16And if you want, you can also see the full data from there
01:20So, let's start creating a report
01:23So, you have to come to the create section
01:25You will get the third option from the ribbon, create
01:27Here you will get the report section
01:30So, there are many types of reports to create
01:32Like we have seen in form, query and table
01:35But the best and easiest type to create is report wizard
01:41Like we have seen in form wizard and query wizard
01:45So, we will start with this and create our report
01:49After creating, a window opens in front of us
01:53In this, we are asked which data do you want to summarize
01:57Or for overall summary, which data do you require
02:01So, here I will put the name, enrollment number, class date of birth, fees
02:12After that, we simply put a PAN number
02:15After that, we click on next
02:17So, here we are asked if you want to group this report
02:22So, basically you can group it name wise or class wise
02:26Which is a very easy way to do it
02:28Simply drag it here if you want to group it
02:31So, now we don't want to group it
02:33We want to collect the combined data
02:36After that, when we click on next
02:39So, here we are asked in which order do you want the data
02:42In ascending order or descending order
02:44If you want it in ascending order, then in which field do you want it
02:49So, if you select name, you will get it in alphabetical order
02:54Enrollment number is ascending in small to large order
02:57Class is small to large
02:59Like students of first class will come up
03:02After that, students of second class will come down
03:05In class, we have put 1st, 2nd, 3rd
03:08So, it will be in alphabetical order
03:10After that, fees paid will be above paid
03:13Non-paid will be below
03:14PAN number in alphabetical order
03:16So, here we select enrollment number
03:18So, basically we will get to know from enrollment number
03:21Who got admission first and then who got admission
03:23So, here we select enrollment number
03:26Then we click on next
03:30After that, we are asked about the layout of the report
03:35So, here you can do column based, table based or justified
03:40So, here table based layout is very good for report
03:44So, here we select table based
03:46Next, after that we are asked about the name of the report
03:51So, like we have table, table query, query form, primary form
03:56So, here we select primary report
03:59So, here we select primary report
04:01Now, we are asked to preview or modify the report
04:06You can select any option from both
04:09If you click on preview, it will take you to preview window
04:12If you click on modify, it will take you to modify window
04:15So, we click on preview
04:17After that, I will tell you what opens in modify
04:20So, if you click on preview, your print view will open
04:24So, this is our print view
04:26So, we simply close it
04:29And if you select modify, this type of design view opens
04:35So, the only difference is that
04:37If you click on view, your print view opens
04:41If you select modify, your design view opens
04:44So, let's come back to print view
04:48So, let's see the print preview
04:50So, 1, 2, 3, 4, 5...
04:52You can see total 5 fields here
04:55You can see the enrollment number is cut
04:58So, let's correct it
05:00After that, we will change the name
05:02And we will group it
05:05We will put line, border
05:07So, how do we do that?
05:09So, let's know that and practice it
05:13So, first of all, we have to come to arrange section
05:17You can see all the details here
05:20If you click on it, all the details will be selected
05:22And click on tabular
05:24So, now it is in tabular form
05:26You have to do the same for page header and tabular
05:29So, if you do tabular, it will slide down
05:31So, you don't have to do anything
05:33You can slide it up again
05:36And let me arrange it here
05:38Okay, perfect
05:39So, now it has been slided up
05:41Now, you have to do grid line
05:43Now, as you can see here
05:45Grid line is selected in page header
05:47If I do both of them
05:49Now, let me show you the view
05:52So, let me show you the layout view
05:55So, here you can see a small border
05:57You can see a border line
05:58A light border line
05:59Okay
06:00So, here we have a border line
06:02And our page is ready
06:04Now, what we have to do is
06:05Enrollment number is not complete
06:07So, let's increase the section of enrollment number
06:10And let's reduce the name
06:12Because there is a lot of free space here
06:14So, let's reduce the name of page
06:16And there is a lot of free space in pen section
06:18So, let's reduce it
06:19And before reducing it
06:21Let me show you this line
06:23The line you are seeing
06:24This is actually line of page margin
06:26In our page setup selected
06:28The length of the page is given here
06:32So, it has a margin line here
06:34Now, to know which page is selected
06:36You have to come to page setup
06:38If you click on size
06:40You can see there are two sizes available
06:42Letter and A4
06:43Letter size is selected
06:44If we select A4
06:45It will reduce a little bit
06:46So, you can see
06:47It has reduced a little bit by selecting A4
06:49Okay
06:50So, let's manage it a little bit
06:52Let's reduce the name tab
06:53Pen tab
06:54So, it will look good overall
06:56So, let's have a look at the print view
06:59How is the print view
07:00Print preview
07:01So, in print preview
07:03You can see that
07:04The border we had set up
07:06It is set up
07:07But it is not looking good in the border
07:09Because the border is of light color
07:11So, let's darken the border
07:14Let's make it black and bold
07:16So, it will look good
07:18And the border
07:19Let's make it in line
07:22So, let's come back to the design view
07:26So, first of all
07:27Let's change the color
07:29Let's go to format
07:31Let's make it black
07:32And let's make it bold
07:34So, it will look good
07:37Okay
07:38After that
07:39I am not able to get the details
07:40And the enrollment number
07:41So, what I will do
07:42I will select both of them at the same time
07:43Because one by one
07:44I can't judge the size
07:45So, I will select both of them at the same time
07:47Then I will increase its size a little bit
07:50And you can see
07:51Its enrollment number is not aligned
07:53So, I will align it to the left
07:54So, both of them will look similar
07:55Okay
07:56Now, what was the name section
07:57The name section was big
07:59So, let's reduce the name section a little bit
08:02The name section is reduced
08:04Let's reduce it a little bit more
08:06Because the names of our students are not that big
08:09The pen number section was also big
08:11It was coming out of our page
08:13So, let's reduce it a little bit
08:15What is the motive of selecting both of them at the same time
08:18Whenever I will set its length
08:20It will change in our header
08:22And it will also change in the detail section
08:24If I select both of them at the same time
08:26Okay
08:27Everything is selected here
08:28If I select both of them at the same time
08:30You can see
08:31Only this one will be big
08:32And the upper one will be like this
08:33So, I have to select both of them separately
08:36So, it is not necessary that I have to select both of them at the same time
08:40If the size of the upper and the lower one is less
08:42Then it will not look good
08:44So, I will undo it with the help of CTRL Z
08:46This size is perfect now
08:48So, now what we have to do
08:50The grid line was also above
08:51So, let's set the grid line in this also
08:54So, basically we come to arrange
08:56In grid line, let's do only vertical
08:58Okay
08:59Then only vertical line will be visible to me
09:01So, let's come back to the design
09:03Print preview
09:04So, you can see
09:05Only vertical line is visible to you
09:07And you can see
09:08I was sizing it a little bit
09:10So, now you can see the difference here
09:12That a little table
09:14Has been slid on the right hand side
09:16Okay
09:17Because you can see
09:18It is visible on the right hand side
09:19And if you look carefully
09:21Then in the middle of the line
09:23You can see a little space
09:24Let me zoom in a little more
09:28So, you can see
09:29I have zoomed in a little more here
09:30You can see a little space
09:31In the middle of the two lines
09:33And here also you can see a little space
09:35So, let's fix this space a little bit
09:37And
09:38The tab of the enrollment number
09:40Has been slid there
09:41The detail one
09:42Let's fix that also
09:44So, to repair this
09:45We have to come back
09:46Okay
09:47We have come to the design view
09:48So, basically
09:49The problem of the line
09:50The space was in the middle of the line
09:52That means
09:53This area
09:55Of the page footer
09:57There is a little gap
09:58Between it and the detail
09:59Okay
10:00Sorry
10:01It got selected here
10:02So, let's move this
10:03To the upper side
10:04Okay
10:05So, here
10:06If I move it to the upper side
10:07Then the little space in the middle
10:09Will be removed
10:11After that
10:12Let me select all of them here
10:14Let me move them a little bit up
10:15And a little bit lightly here
10:17Now the space above
10:19Will also get cancelled
10:21And
10:22Here
10:23We shifted it a little bit up
10:24So, let's shift the page footer
10:25A little bit up
10:26Okay
10:27Now, let's come back
10:28To our print preview
10:29So, you can see
10:30There is a little space here
10:32And
10:33The left hand side
10:34Has been slid a little bit more
10:35Okay
10:36As you can see here
10:37Okay
10:38It's perfect here
10:39Okay
10:40Only these two sections
10:41Have a problem
10:42So, it's okay
10:43If there is a little problem
10:44Then there is no issue
10:45So, my
10:46My whole setup is ready
10:48In this
10:49Normally
10:50Let's zoom it 100%
10:51So, you can see
10:52Here
10:53In my whole page
10:54Everything is visible
10:55So, this is my
10:56So, this is my
10:57Data summarize
10:58I have made a report
10:59Okay
11:00So, you can also make
11:01A report like this
11:02And
11:03In that
11:04You can summarize
11:05Your data
11:06Like
11:07On the enrollment base
11:08123
11:09Enrollment number
11:10Is of a guy named Ali
11:11Who studies in class 3
11:12He has paid his fees
11:13And his pen number is this
11:14Okay
11:15So, like this
11:16You can also
11:17Prepare your report
11:18And basically
11:19Everything is
11:20Everything is
11:21Saved in our main
11:22Primary table
11:23That's why
11:24Everything is happening
11:25As you can see
11:26Here
11:27124
11:28Enrollment number
11:29Is of a guy named
11:30Aarti
11:31Who studies in class 4
11:32She has not paid her fees
11:34So, if she
11:35Pays her fees
11:36And here
11:37Here is Aarti
11:38I click here
11:39She has paid her fees
11:40She has paid her tuition fees
11:41Okay
11:42After that
11:43I come here
11:44I refresh it
11:45Okay
11:46And
11:47Here
11:49Okay
11:50I didn't save it here
11:51So, I will
11:52Save it
11:53Okay
11:54So,
11:55Again
11:56Okay
11:57Here
11:58It is not taking
11:59So, no issue
12:00Because
12:01It is of print preview
12:02I just came to my mind
12:03That I opened
12:04Print preview
12:05That's why
12:06It was not selecting
12:07As soon as
12:08I do normal layout
12:09You can see
12:10Aarti's tick
12:11Has come here
12:12In print preview
12:13Basically
12:14What happens is
12:15At that time
12:16The sheet was ready
12:17Same to same
12:18Same printing
12:19Goes in preview
12:20So, the command
12:21Of refresh
12:22Doesn't work
12:23Here
12:24Okay
12:25So, in the same way
12:26You can create a report
12:27Here
12:28I forgot to change
12:29The name of the report
12:30So, let's do that
12:31First of all
12:32I set the size
12:33Okay
12:34And
12:35From here
12:36I will
12:37Set it like this
12:38So, let's keep
12:39Its name
12:40Primary report
12:41Its name
12:42Is not looking good
12:43I will put
12:44Student list
12:45So, student list
12:46Name
12:47Will fit
12:48In this
12:49I will select it
12:50Let's come to
12:51Format
12:52And
12:53I will
12:54Set it
12:55As
12:56I will
12:57Set it
12:58As
12:59I will
13:00Set it
13:01As
13:02I will
13:03Set it
13:04As
13:05I will
13:06Set it
13:07As
13:08I will
13:09Set it
13:10As
13:11I will
13:12Set it
13:13As
13:14I will
13:15Set it
13:16As
13:17I will
13:18Set it
13:19As
13:20I will
13:21Set it
13:22As
13:23I will
13:24Set it
13:25As
13:26I will
13:27Set it
13:28As
13:29I will
13:30Set it
13:31As
13:32I will
13:33Set it
13:34As
13:35I will
13:36Set it
13:37As
13:38I will
13:39Set it
13:40As
13:41I will
13:42Set it
13:43As
13:44I will
13:45Set it
13:46As
13:47I will
13:48Set it
13:49As
13:50I will
13:51Set it
13:52As
13:53I will
13:54Set it
13:55As
13:56I will
13:57Set it
13:58As
13:59I will
14:00Set it
14:01As
14:02I will
14:03Set it
14:04As
14:05I will
14:06Set it
14:07As
14:08I will
14:09Set it
14:10As
14:11I will
14:12Set it
14:13As
14:14I will
14:15Set it
14:16As
14:17I will
14:18Set it