ALL TUTORIALS.
Category
📚
LearningTranscript
00:00MS Access is another new class
00:03In this class, we will learn how to create a form
00:06So basically, why do we create a form?
00:09and how do we do it?
00:11We will learn both in this class
00:13So let's start today's class
00:15To create anything, you get the first option in the ribbon
00:19To create anything, you get the first option in the ribbon
00:24If you click on create, you will get a form tool or form tab
00:29You will get a lot of forms in the form tab
00:32So which form do you want to create?
00:34First of all, I will tell you that almost all the forms work in the same way
00:39Just the way they are viewed, their preview is different
00:43Rest, the working is common and similar
00:47I will open 4-5 forms here and show you
00:50First of all, we click on the normal form
00:53So my normal form has been opened
00:56So this is my normal form
00:58I will close the property sheet
01:00This is my normal form
01:02You can see the entry of ID 1
01:06I have 8 entries
01:08I can click on it and see the next record
01:11I can click on it and see the next record
01:13I can see all the records in the front
01:16If I want to create a new record, I can create a new record
01:21So this is how this form works
01:24So now what we have to do
01:26We have seen how the normal form works
01:30Now let's close this
01:33Now let's see how the next form works
01:37So here is the form design
01:38So basically form design means we can design according to our form
01:42You can adjust the length of the form according to the cursor of the mouse
01:49You can also make it bigger from below
01:51If you want to add or edit anything
01:55You can simply add a text box
01:59If you want to add a label, you can add a label
02:02If you want to add a hyperlink, you can add a hyperlink
02:05Whatever you want to do, you can see all the tools here
02:09If you want to bring any data from the primary table
02:14You can simply see the add existing field option
02:19You click on it and you will get the primary table option
02:23If you want to add a name for the primary table, you can see the name
02:28If you want to add an enrollment number, you can simply double click on it
02:31You will get the enrollment number, class, date of birth, fees and fees paid
02:38If you want to add a photo, you can see the photo
02:41You will get the tuition fees, tuition fees paid or not
02:45You will get the pen card option
02:47so this is how you can design your custom form
02:50so let's close this
02:53let's see the third form
02:56so this is also the same way
02:59you can design your form here
03:02the only difference is the format
03:05as I told you that everything is going to be common in the form
03:08only the visual will be different
03:11everything else is going to be common
03:14everything else is going to be common
03:17so these are the things
03:20let's close this
03:23let's see few more forms
03:26then form wizard
03:29so form wizard also works like this
03:32you can add any field from the primary table
03:35so basically if you want to add all the fields
03:38then add all the fields
03:41name, enrollment number, class, date of birth
03:44these are the common fields
03:47so here we have to
03:50open the form to view or enter information
03:53or modify the form design
03:56so if you want to modify the form design
03:59then click on it and finish
04:02so here you can modify the form design
04:05so here we have to modify the form design
04:08so what happened is
04:11it opened in the design view
04:14if we want to open it directly
04:17then it would have opened in the form view
04:20so we can directly enter the text
04:23so here it opened in the design view
04:26so we can design here
04:29if you want to add something in the primary table
04:32then you can add something
04:36so here I have written the admission form
04:39and I can bring it in the middle
04:42or not bring it in the middle
04:45I can make the box bigger
04:48and I can align the text
04:51which I will get in the format
04:54I will add the font
04:57I will make it bold
05:00I will make the font size 28
05:03I will slide it up
05:06now it is looking good
05:09now I will see it in the view tab
05:12it is looking good
05:15you can see the blank space
05:18so if you want to add something
05:21you can add it
05:24so this is how the form works
05:27so let's close it
05:30so we have seen the form
05:33now let's see 2 more forms
05:36in navigation you will get almost the same
05:39in more form you will get the same
05:42now the 2 important forms
05:45which were used a lot in MS office 2003 and 2007
05:48so let's cover them
05:51so the first one is multiple form
05:54so what is there in multiple form
05:57so this is how the form opens
06:00you can see all the data entered in the primary table
06:03field wise
06:06so all the data opens here
06:09so what is the difference
06:12you can see the photo here
06:15in the photo there is an attachment icon
06:18so it is the same
06:21you just need to see the big boxes
06:24so there is no difference
06:27so let's close it
06:30now let's see the last one
06:33split form
06:36I used to use it a lot
06:39so you get the form above
06:42and you get the original data below
06:45so you can carry it
06:48that I have worked in this data
06:51so what happens
06:54you get used to it
06:57so when I learned MS Access
07:00I used to use it a lot
07:03because I got used to it
07:06so I could work easily
07:09but when I got to know MS Access
07:12then I realized that if I enter some data in the form
07:15it will be added to the table
07:18so we don't need to add anything
07:21or keep an eye on it
07:24so you can use this field
07:27if you want
07:30so let's close it
07:33now let's start our normal form design
07:36so we will create a form
07:39we won't take any id
07:42as I told you
07:45so I have created a form
07:48so let's finish it
07:51so I have created a form
07:54so let's edit it
07:57so let's go to the design tab
08:00so let's go to the design tab
08:03and edit the form
08:06so let's close the field list
08:09because we have already added everything
08:12let's enlarge it
08:15so let's add our name
08:18Admission form
08:21so let's add our name
08:25so let's enlarge it
08:28so let's align it
08:31so let's align it
08:34so let's align it
08:37so let's underline it
08:40so everything is ready here
08:43you can change point 1 if you want
08:46it's up to you
08:49you can add background image if you want
08:52you can add your own logo
08:55I will show you that in a while
08:58you can customize everything here
09:01for example, the box for enrollment number was small
09:04so I made it bigger
09:07so I will make it bigger
09:10the box for class is perfect
09:13the box for date of birth is small so I will make it bigger
09:16the box for fees is ok
09:19the box for photos is ok
09:22the box for tuition fees is ok
09:25the box for 10 digit pen card is ok
09:28so I will make it smaller
09:31so this way you can edit your form
09:34you can edit it as per your liking
09:37after that right click
09:40you will get the option of fill background color
09:43you can add color if you want
09:46for example, the color above is dark blue
09:49you can add color in contrast
09:52for example, this color
09:55it's in contrast so I will keep it
09:58now you can see
10:01I have written the details
10:04I want to change the color
10:07because the background is dark
10:10so I will make it bold
10:13so it will be visible
10:16now we come to form view
10:19so you can see
10:22it's a little bit different
10:25I have changed the color
10:28with this you can design your according
10:31no one knows better than you to design
10:34you can design according to your requirement
10:37you can design according to your requirement
10:40no one else has anything to do with it
10:43as you can see, date of birth is on right
10:46name is on left
10:49so you can align it
10:52I have taught you how to align it
10:55now we come to design section
10:58and as I told you
11:01I will teach you how to edit logo
11:04you will get the option of logo
11:07there is no special setting
11:10you can add your logo
11:13I will take a logo of KB
11:16I will take PNG file
11:19I have taken PNG file
11:22I can make it as big as I want
11:25I have made the admission form
11:28so my logo is set
11:31title is already there
11:34but if title is not there
11:37then I can keep the title
11:40so I will delete it
11:43you can add date and time
11:46you can add date and time
11:49you can add date and time
11:52you can add date and time
11:55you can select the format
11:58I want to add only date
12:01date format is 16 march 2020
12:04I want to keep it in this format
12:07you can see the date command
12:10I will show you in form view
12:13you can see my date is set
12:16you can design it as per your requirement
12:19this is the normal form
12:22all forms look like this
12:25now we are going to add special
12:28we are going to add many things
12:31you can add different things
12:34as per your requirement
12:37you can see the name of the cursor
12:40you can see the name of the cursor
12:43you can guess the name of the cursor
12:46you can select anything
12:49now select option is selected
12:52now we have text box option
12:55text box means we have to make a box
12:58here we have label
13:01here we have label means we have to make a label
13:04here we have command key
13:07here we have command key
13:10here you can create buttons
13:13I will tell you how to create buttons
13:16let's see the commands
13:19here we have tab control command
13:22here we have hyperlink command
13:25here we have web browser command
13:28here we have navigation command
13:31here we have group option
13:34here we have group option
13:37for example
13:40here I have created a box
13:43in the side you can see option
13:46there are 4-5 fields
13:49if you want to check any field
13:52you can select that thing
13:55now let's cancel it
13:58next we have page break command
14:01next we have combo box command
14:04like in this, we can check only one thing
14:07in this, we can check more than one thing
14:10like in this, there is a select option
14:13in this, there is a check button
14:16in this, you can check different things
14:19after that, if you want to draw a line
14:22for that also, there is a command
14:25after that, there is a toggle button command
14:28toggle button is basically used for that
14:31you can make the font bigger or smaller
14:34you can make it in upper case or lower case
14:37you can do all that from here
14:40after that, there is a list box
14:43after that, there is a rectangular box
14:46after that, there is a check box
14:49after that, if you want to frame an object
14:52or you want to do an attachment
14:55or you want to do an option box
14:58this is a very simple command
15:01we can find all these commands in MS Word, MS Excel
15:04and in Powerpoint
15:07all these commands are same
15:10except few commands, there are
15:13label, text box and button command
15:16which we use very less
15:19you can find all these in MS Access
15:22but here in MS Access
15:25basically, we use button command
15:28to give you an example
15:31we use button command
15:34I select the button
15:37I can make it as big as I want
15:40basically, I will make a square box button
15:43I can find 5-6 categories
15:46in record navigation
15:49in record navigation category
15:52navigation means
15:55we can navigate all the data
15:58there is a command button
16:01which we can click to go to next data
16:04there is another command button
16:07which we can click to go to find record
16:10we can find any text
16:13after that, we can go to first record, last record
16:16next record or previous record
16:19after that, we can go to last record
16:22sorry, we can go to first record
16:25we can make a command button
16:28I click on next
16:31you can name the command button
16:34you can find this type of image
16:37I click on finish
16:40this is the button
16:43this is the button
16:46you might have seen it somewhere else
16:49we will come to form view
16:52you can see these buttons
16:55this is first record button
16:58we click on first button
17:01we will come to first record
17:04we have added a big version of this button
17:07I will click on it
17:10we can make big buttons
17:13we can add more buttons
17:16button plays a very important role
17:19in this form
17:22we have added one button
17:25I will add one more button
17:28this is the last command
17:31we will come to previous command
17:34I click on next
17:37after that, we click on next
17:40we add one more button
17:43this is next record
17:46we click on finish
17:49this is next record command
17:52we add one more button
17:55this is last record
17:58we click on last record
18:01we have 4 buttons
18:04we can add more buttons
18:07I can add different types of buttons
18:10I have many categories for buttons
18:13category includes record navigation
18:16record operation
18:19we can add new record, delete record, duplicate record, print record, save record
18:22and undo record
18:25basically, we will add new record button
18:28I will record a data
18:31and we will end our video
18:35we come to add new record
18:38you will get this type of button
18:41but we can get confused with this type of button
18:44we can use text
18:47we don't have to use picture for button
18:50we can use text
18:53I will type add new record
18:56add new record
18:59I click on next
19:03you can see this button
19:06text is written here
19:09I can edit this text
19:12basically, its color is pinkish
19:15I will change its color to white
19:18I will change its color to black
19:21so that it looks good
19:24I will place it here
19:27I will adjust its size
19:30you can adjust it as per your requirement
19:33you can design it as per your requirement
19:36everything is ready here
19:39we come to form view
19:42from form view
19:45we can see next record
19:48we can record next record
19:51we can record last record
19:54we can record previous record
19:57I will click on record
20:00I can add my record
20:03to add record
20:06I have to enter everything
20:09I want to enter student's name
20:12I will put student's name
20:15I will put enrollment number
20:18I will put drop down menu
20:21I will put 4th class
20:24we have calendar
20:27we can select from calendar
20:30we can type manually
20:33we have chosen 2003-2002
20:36we have to enter student's fee
20:39suppose, its 1000rs
20:42check it
20:45we can insert photo
20:48by double clicking
20:51we can directly insert the photo
20:54I will take a class thumbnail
20:57for example, my previous class thumbnail
21:00and my photo has been added
21:03after that comes the tuition fees
21:06for example, tuition fees was Rs.500
21:09so have I paid Rs.500 or not?
21:12yes, I have paid Rs.500
21:15if I don't check, then I haven't paid
21:18in pen number, we have put input marks
21:21so in the starting 4 characters
21:24we have to type a letter
21:27we can't type a number in that
21:30for example, I am not typing a number
21:33but if I type a character, it will be typed
21:36after 5 characters, we get 4 numbers
21:39and at the end, we get a character
21:42so this is our pen number
21:45with the help of this, we can type a specific thing
21:48and as you can see, everything is in capital
21:51why? because we have put input marks
21:54after everything is done, I will click on ok
21:57now I will come to the next record
22:00so you can see, my record has been saved
22:03the problem here is
22:06I have put the data here and it has been saved
22:09but we can also put a save button
22:12with the help of this, the record will be saved
22:15so we can work with this
22:18so here I have saved a record
22:21so you can record your data from your form
22:24I can simply click on next or previous
22:27and my data will be shown here
22:30so you can record your data from your form
22:33and now we will meet in our next class
22:36till then, you can try this form
22:39and create your form
22:42Thank you