Join Robin Hunt for an in-depth discussion in this video Using the Problem Step Recorder, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- Every great project starts with great documentation.…Over the years there have been many tools…to help us capture our screens,…but not everyone has access to every tool available.…If you're using a Windows environment,…you might be interested in the Step Recorder.…The Step Recorder will document the process you follow…every time you work on your solution.…Let's open the Step Recorder and…then I'll show you how to use it.…I'm going to click my Start button,…go to Search, and look for steps.…
Once you see Steps Recorder you can click that.…The Steps Recorder, once you click "Start Record",…will record every click you make for every file you touch,…in essence recording your entire process.…Alright I'll click "Start Record".…I'll go ahead and double-click my…Original Start file in the exercise files.…You notice the two little red highlights.…That was representative of a double-click.…Now an example of a repetitive process would be:…every time I open this file I go put in the city…using a vlookup on the zip code.…
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.
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.