From the course: Building Solutions Using Excel and Access 2019 Together
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add command buttons for navigation
From the course: Building Solutions Using Excel and Access 2019 Together
Add command buttons for navigation
- [Instructor] To make our databases user friendly as possible, and since we're using a navigation form, let's go add some command buttons to make it even better. So, we're already on the navigation form. Let's go to Department List. Again, our Department List forms scroll up. This Department List form is the one that comes from our Excel file. Let's go to Managers. We have the Managers and the Department Names. The Managers and the Department Names are both forms, I'm just clicking between them on the navigation, that we'll add things to them, and we'll change them, right? So, let's go ahead and add a couple of Add New buttons just to make it simple for the users. That way, they don't have to think or learn how to add records automatically. We can just give them buttons to read. All right, I'm going to go ahead and on my Navigation pane, scroll down and navigate to my forms. Okay, I'll go ahead and right-click Managers and go to the Design View. I'll close my Property Sheet, I don't…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.