Join Robin Hunt for an in-depth discussion in this video Adding command buttons for navigation, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- View Offline
- If you get excited about using forms…and your setup options,…then you might find it easier to…build some basic navigation forms.…Let's do a simple navigation structure.…Remember, if you're joining me now…and you open your exercise files,…you want to hold Shift to bypass the setup options.…Let's go ahead and open up my department list again.…You can double click it if you'd like…and then let's go to the Design View.…When people look at this form it's not always obvious…that the little new button is on the…bottom left-hand side of the navigation.…
We'd much rather give them a…bigger button called Add New People.…So, I'm going to go to the DESIGN tab of my Form tools…and I'm going to use the Command button,…I'm going to click on my Form,…and the Command Button Wizard prompts me…with all sorts of awesome options.…I'm going to go to Record Operations.…I want a button that will add a new record.…You see all your other options here.…Save is also a good one.…
I'll do Next.…Now, over the years I've learned that people can usually…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries