How to Create MENU using NAVIGATION form in Microsoft Access | Edcelle John Gulfan

hello everyone and welcome to this channel in today's video I'm going to show you on how to create a simple menu I call this as a minimalist menu because this is really a simple and it's just like a wave design so no further intro let's start so let's click this create menu and then let's go to form groups and then let us select this navigation and there are lots of styles but I'll choose this one horizontal tabs the menu is in the top Okay click this then close that one and also this one so to give some space so sample button we have a employee next is um asset like acid transfer next is asset list next is um reports next is settings I think back up okay this one we can adjust this guys can adjust the button okay so now let's try okay this is the format and then um let's set to and then for the format no no that's correct this one neither okay and then I have to put some space you put in the center okay and then let us rename this though like so for solution in the end um bold color white and then the color of this the color is this one and then let's try so this is the result and let's make it maximize to see the whole background so let's go to event then unload this is a online code guess the maximize the CMD that maximize okay close and then let's try to open okay it's maximized and then this is the format at the top so for this button below um let us highlight all let us drag this wait it's not being dragged okay this one so let's try again okay this one guys so employee as a transfer the reports this is automatic because there are forms that the name is the same with this spilling reports see things back up so for the current user and also the icons let us go to the design view and also let us add a button guys delete and then the format make it a circle if you have not watched my video about inserting a icon for the current user you can watch my video or you can also watch this okay uh we can put color like white and then let's go to format let us add some icon browse select icon to view so I'll find this one okay so this is it and then I have to select transparent and the Border style also transparent okay in that area so now let us go to form View here we go guys but if you can see the the icon is in the center not in the right portion so in that case we have to use the anchoring right click anchoring and then select this one top right so that when the form uh is on load or open automatically just like this so it's placed in the right corner so now let us add a text box for the name of the current user okay for the format okay the color white and then let's go to the Border style of the text box this is transparent and also transparent here we go let's check there's no data so if you have not watched my video about um creating a login form so it's part of this video so you can watch it also but for the meantime I have to put a simple data using the computer computer username so here but okay this one takes 20 all right user so remember this name me that current user is equals to Environ username this is the computer username okay so let's try user this one this is the name of my computer okay user user design view so it's also put it in the right position anchoring top right and then you have to lock so in order to click this enabled no luck yes how are you guys this one so let's proceed below this one okay can highlight and then home uh let us choose this color and then for the color one color this color is white ball okay here we go this is the result but as you can see there's no highlight color or hover color if you point this no color so let us apply the hover color guys so how to do that so highlight this then untick the add new and also the the square okay this one and then you will see here a hover color my hover color will be I'll choose this one okay and then the color of pawns when we point okay this color violet or blue let's try okay so it's working guys and then if we press no preschooler so let us insert a preschooler guys so the same um procedure so a while ago we choose this hover color but now we have to choose this four a press color so the preschooler will be like this much more darker and in the color would be the baseball color would be the um black I like black so let's try so employee acid but the problem is as you can see employee asset transfer and asset list is also colored yellow but if we point so the color is has been changed so we have to add another function guys for active control actually the original code for the active controls for the hover color is very um what we call this one we can consider very massive good but I made this uh very simple guys just only one code productive controls so highlight or click that before that click this and this one the square and then the name of the square is navigation Ctrl 0 copy paste copy and then let's go to or create our tick um anywhere and then click event on click code Builder okay so now for the private sub let's type function let's change the subtle function private function and then let us change this tool um over something like this and then um me that that's a query so this only one code guys it didn't copy paste the hover button this name close and then let's select and then here on click let's type equals and then paste now let's try employee okay asset transfer asset list reports settings so it's really working guys so no more um colors unnecessary colors um before that I have to sit also format this one and we can also insert guys a a welcome page welcome page but we will hide uh the name so since this is a welcome page the first page to open so we will put this in the first place so let's try okay this one in example data okay Target it's in the sample okay this one sample now let us open okay so this is the first form to open guess so so since this is a first uh since this is um a welcome page or Landing fields we will hide this we can select or no and then to give some space for the employee okay that one then here we go this is the result now let us add or guys if you want to to delete this color blue below you can just right click and then delete out remove it out okay no more and then let us add a form to finalize this tutorial so data employee let us check employee list and then for this asset transfer copy of asset transfer this one okay asset less okay so this only three so here we go but um I have to align this okay and here you guys so employee when we click this okay so this is the result and then as a transfer reports back up but by the way the log out here uh visible I will add you it's not a problem okay log out format is this anchoring top right and then the hover color it's red okay and then tab okay either with the Border style is transparent okay let's check okay this one guys employee transfer like this to none and here we go guys so this is it so clean as like a website so that's all and if you want to learn more about Microsoft Access and also if you have not subscribed to this Channel and guys um please consider subscribing this channel for more informative videos and if you have some questions about this feel free to comment below and I will try my best to answer that that's all guys thank you and see you to my next video

Channel: Edcelle John Gulfan

Views: 64,312

Keywords: Microsoft access 365 tutoring, ms access tutorial for beginners

Id: lLunMSjd9xM

Length: 16min 51sec (1011 seconds)

Published: Thu Sep 29 2022