1 00:00:01,078 --> 00:00:03,469 a long look taxes 2013 shoot or ooze 2 00:00:03,470 --> 00:00:07,310 this is going to be the first video in a couple videos 3 00:00:07,309 --> 00:00:10,759 does is making a login form the password 4 00:00:10,759 --> 00:00:15,949 I did a similar thing I've got to login form in Access 2010 videos by Nick 5 00:00:15,949 --> 00:00:16,519 collected 6 00:00:16,519 --> 00:00:21,050 password in so over close naughty boy some gonna put one in 7 00:00:21,050 --> 00:00:25,480 this one seeks here you can do that okie dokie try to play along 8 00:00:25,480 --> 00:00:29,179 for the link below video to them a section of the website and damnit 9 00:00:29,178 --> 00:00:31,409 actress 2013 TV 29 10 00:00:31,410 --> 00:00:34,829 unless of course you've done all the videos from the stock have been using 11 00:00:34,829 --> 00:00:35,410 the same 12 00:00:35,409 --> 00:00:38,619 database which case you're my hero so 13 00:00:38,619 --> 00:00:42,599 and its open on Oct in 2013 keep saying a 14 00:00:42,600 --> 00:00:46,689 because logo are some reasons in 2010 your 15 00:00:46,689 --> 00:00:49,968 okay so a login forms 16 00:00:49,969 --> 00:00:54,410 up were used for I we sense the user login form 17 00:00:54,409 --> 00:00:58,479 as the form that you should open up when you open a database up 18 00:00:58,479 --> 00:01:02,619 I'm to go to choose a user which is fine and 19 00:01:02,619 --> 00:01:05,899 sufficient for most situations this sometimes 20 00:01:05,900 --> 00:01:09,500 you done so much better choose a user without providing a possible 3 21 00:01:09,500 --> 00:01:13,299 is that person and that does spring into some other security 22 00:01:13,299 --> 00:01:16,299 issues pup know more about that 23 00:01:16,299 --> 00:01:19,990 I miss me show you basically give form to Z user and 24 00:01:19,989 --> 00:01:23,489 supply the Posada satiated that little user miss a loser there 25 00:01:23,489 --> 00:01:27,349 the user and again today to raise simple as that okie dokie 26 00:01:27,349 --> 00:01:30,938 so first things first alternate well we need at store 27 00:01:30,938 --> 00:01:34,339 the user's information some minutes till the name of the user 28 00:01:34,340 --> 00:01:37,509 I'm each store the password of the user 29 00:01:37,509 --> 00:01:41,239 so Wellington this video is create that table to create 30 00:01:41,239 --> 00:01:46,489 30 table design obviously 31 00:01:46,489 --> 00:01:49,589 well access works see okay first field 32 00:01:49,590 --> 00:01:54,240 mechanical user I D and that will be 33 00:01:54,239 --> 00:01:57,809 and water number second field user 34 00:01:57,810 --> 00:02:01,890 name and actually short text and third field 35 00:02:01,890 --> 00:02:05,250 password and 36 00:02:05,250 --> 00:02:08,419 click on for struct and two primary key 37 00:02:08,419 --> 00:02:11,939 right click and save cooler table 38 00:02:11,939 --> 00:02:18,939 uses brooch 39 00:02:18,989 --> 00:02:24,039 yes replace it the reason we have 40 00:02:24,039 --> 00:02:28,120 the table was pictures 5 supply those tables for school now 41 00:02:28,120 --> 00:02:35,120 gone for ever so this is only say we've got k so 42 00:02:35,780 --> 00:02:40,259 a sink the torsten are called james Conway for some reason I don't know 43 00:02:40,259 --> 00:02:41,329 james Conway 44 00:02:41,330 --> 00:02:44,819 any likeness to exist in person 45 00:02:44,818 --> 00:02:48,939 is entirely coincidental I get next password 46 00:02:48,939 --> 00:02:52,780 so james Conway you have a partial so let's say that james Conway 47 00:02:52,780 --> 00:02:57,620 password is password far enough okay 48 00:02:57,620 --> 00:03:01,489 any problems yes you guessed it missed or the password 49 00:03:01,489 --> 00:03:04,640 in the table we would be nice if 50 00:03:04,639 --> 00:03:08,389 we I you some kind of mosque so that vote 51 00:03:08,389 --> 00:03:12,429 we can see characters for example the docs like this 52 00:03:12,430 --> 00:03:16,640 to find the dots icon something like this said it's impossible you wanna see 53 00:03:16,639 --> 00:03:17,399 something like that 54 00:03:17,400 --> 00:03:21,019 yes but no more so than the market is going to the table find out ways 55 00:03:21,019 --> 00:03:21,920 password is 56 00:03:21,919 --> 00:03:25,979 XI we gonna do that absurdly simple 57 00:03:25,979 --> 00:03:29,318 to the table into designed you click on 58 00:03:29,318 --> 00:03:33,098 short text I talked password 02 59 00:03:33,098 --> 00:03:38,000 input mosque down here and shoes case was gonna be 60 00:03:38,000 --> 00:03:42,830 you must say say we are save table and choose password 61 00:03:42,830 --> 00:03:47,250 next a solution patient thank you and good night 62 00:03:47,250 --> 00:03:50,729 can go back to the issue so the table again 63 00:03:50,729 --> 00:03:54,568 and because in Italy 64 00:03:54,568 --> 00:03:58,298 that type in password and now we have 65 00:03:58,299 --> 00:04:02,030 password field and table uses 66 00:04:02,030 --> 00:04:06,759 and you cannot see was written in S so if any was able to access to this table 67 00:04:06,759 --> 00:04:10,169 at the very least they want to see the password 68 00:04:10,169 --> 00:04:13,500 I'm re: I'm a key piece on simple that's going to be it 69 00:04:13,500 --> 00:04:17,079 for the first video soon begin to mosque an annex video 70 00:04:17,079 --> 00:04:20,340 you look hair creating formed go with it 71 00:04:20,339 --> 00:04:22,159 so thanks fortune seen actually a