Join Robin Hunt for an in-depth discussion in this video Assigning and building macros on events and buttons, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- People are always better at following a marked path,…which is why we have Command button navigation.…It can be essential.…There are more ways to guide and control…through events than just buttons that we put on forms.…But you need to understand…a little bit more about event triggers.…What I want to do is reopen the database…and bypass all the startup options…which will also bypass the autoexec.…And I want to take you in to the design of this now form,…we're going to add an admin button.…And I'll talk to you about the difference between embedded…and stand alone macros.…
So, go ahead and exit if you're following along with me,…and then remember to reopen,…you're going to hold your shift key.…And open up your file.…Okay, let's go to the navigation under forms.…So NAV, going to right click that,…and go to design view.…Throughout the course we've been clicking the command button…and going through the wizard.…I'm going to click the command button,…add a button.…Now, I'm just going to choose cancel here.…Because I really don't want to run through the wizard.…
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
Skill Level Intermediate
Q: How do I open the exercise files?
A: Press and hold Shift when opening the exercise files for this course.
Excel 2013: Data Validation in Depthwith Dennis Taylor1h 5m Intermediate
1. Understanding How to Use Excel and Access for a Solution
2. Building Tables in Excel and Access
3. Calculating Data in Excel and Access
4. Building Forms for Your Solution
Setting the database options2m 53s
5. Building Reports for Your Solution
6. Building Macros to Run Imports and Queries
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.