In this video, discover how to use the Problem Steps Recorder to build and document your steps.
Author
Released
12/9/2017
By combining the power of Microsoft Excel and Access 2016, you can build better end-user solutions and greatly enhance your own personal productivity. In this course, learn how to leverage Excel and Access, and get the most out of both tools working together. Robin Hunt shares strategies and techniques that can help you work smarter with these two programs, and avoid needing to manually rebuild each time you run reports by building solutions. Robin kicks off the course by reviewing how Excel and Access can be used together, and explaining how to build tables and calculate data in these two programs. She also explains how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more.
Topics include:
- How Excel and Access can work together
- Using the Problem Steps Recorder
- Leveraging screen capture tools
- Building tables in Excel and Access
- Creating basic queries using tables
- Maintaining linked tables
- Calculating in Excel versus Access
- Building a basic form on Excel tables
- Building macros to run on-demand queries
- Generating datasets using parameters, queries, and macros
Skill Level Intermediate
2h 19m
Duration
58,714
Views
Show More
Show Less
Related Courses
-
Access 2013: Queries
with Adam Wilbert4h 23m Intermediate -
Access 2013: Tips & Tricks
with Adam Wilbert2h 50m Intermediate -
Excel 2013: Data Validation
with Dennis Taylor1h 5m Intermediate -
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate
-
Introduction
-
Welcome30s
-
-
1. Understanding How to Use Excel and Access for a Solution
-
2. Building Tables in Excel and Access
-
Maintaining linked tables1m 27s
-
3. Calculating Data in Excel and Access
-
4. Building Forms for Your Solution
-
5. Building Reports for Your Solution
-
6. Building Macros to Run Imports and Queries
-
7. Using Parameters, Queries, and Macros to Generate Datasets
-
Conclusion
-
Next steps19s
-
Show MoreShow Less
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Using the Problem Steps Recorder