Create Login Tracking Database Part 1: MS Access

hello welcome back my name is e1 in this video I will show you how to create a user login tracking we can track the use login on this database and how long belonging we need to create a table first to create and table design ok you start with login ID as Auto and user ID e to get the user from the juice of login on our database and login time use a date and Tom data time and long outcome same thing date another high but in this video just show you the simple tracking log in and we save that as a table login Tom we don't have fun ok you can assign a login as a penalty feed you can open to check it we have the M empty table at this time we just finished a login login turntable the next step we need to create the function get user login function or free it and put module we put the function under marshal up we use a public Oh get user login get user login equal to in why wrong function use the name that's it after we have the login function I have it under my shoe one get user login you know just a long ego - in my wrong username and say 'hey you know the simple function and now I need to create a query design on login query we add login time table Oh now we chained to a pin query now we'll show you in detail how to do some pin query a pin to table log in time and what we need to obtain - with a pin - user we need to get the user login and a pin to deduce ID and a pin wrong in time log out time we use a get user login function for the user log in the fill and login time long in equal to now we use now function to capture the date and the time in p.m. and log out uh we use it no no we don't want anything at this time when we login you just leave it blank for logout come then we can view it looks good and we close it and save as a query long in time after we have the query login Tom query now we need the long-term query for the design query log in time and now we change to update query we need to update query for the long count on what we need to update we need to update local time and we update to use a now function to the current time current day criteria is no update on the one its brain on log out Tom where the login ID equal to get user get user login function now we use the get user log in the current user on this computer and stem the current time no function now and then where is no and we got it in shape and name is a long out all out tom now you can see the query is different picture a lot of logging time is a pain is you have the plus sign and log out tom is a update query AB some kind like the writing pencil in there now we need to put some code on the form the first form will be open it it and then we call this longing functions to stem the time we can put under navigation form in this example beside you on the road even we need to call we started demon sting top name and string for the quarry name don't mean equal query log in time and do man open query string down name abnormal egg 80 that's it now we finish a code to open a query a query log in time save and we view the form open now you can see when we open the form of uniform and now we get a user login from the computer here issue my t1 and then login time is seven three seven fourteen times nine nineteen and long outcome is showing new because we used new on the query you see here one thing we need to delete the table from here we just use a pin type into user ID we don't need any show any table over here okay long time we can show the table we need to put the log out Tom on the forum win or after we close the form okay we looking for on course even now login we use under all road even and now log out come we use on their own closet win on course and do the same thing like log in game don't name s string not name equal to query log oh come do command open for query name of queries dog mean heck normal edit then we done save and we'll form now when you see here we have three maybe greedily done at the to leave the clean one here and now we hold this form it's mean on Kosovan is supposed to update now it is it does now we showed that in love outcome here belonging on the nightfall and love our nine thirteen and now we open try again we open the form again and open the login table now we open it 913 today goes in and hold the form and check it again now we stamp the date 1939 a second p.m. it's looking very good when you open the form and then when you hold the form is stem the time for the user login and logout come and this user you you know who they are because users you can link this user to the user table over here and now we come up with this person I just inside polling and grants login on this computer and thank you for watching and it's for up on the second part of my login tracking we implement some code and report to that

Channel: T Golden Eye

Views: 52,764

Rating: 4.8282208 out of 5

Keywords: Howto, how to, access 2010, MS access 2010, vba access, access tutorial, login, tracking, tracking user login, Logi trackg, create user login tracking database, create login tracking

Id: nWgLaehaqnc

Length: 12min 14sec (734 seconds)

Published: Sat Mar 08 2014