| 0101.Increase productivity by leveraging Excel and Access together.mp4 | 5.7 MB | ||
| 0101.Increase productivity by leveraging Excel and Access together.srt | 1.8 KB | ||
| 0102.What you should know.mp4 | 463.5 KB | ||
| 0102.What you should know.srt | 614.4 B | ||
| 0103.Exercise files.mp4 | 2.3 MB | ||
| 0103.Exercise files.srt | 2.6 KB | ||
| 0201.How Excel and Access can work together.mp4 | 5.5 MB | ||
| 0201.How Excel and Access can work together.srt | 6 KB | ||
| 0202.Use the Problem Steps Recorder.mp4 | 6 MB | ||
| 0202.Use the Problem Steps Recorder.srt | 3.9 KB | ||
| 0203.Use Microsoft Office screenshots.mp4 | 6.2 MB | ||
| 0203.Use Microsoft Office screenshots.srt | 3.8 KB | ||
| 0301.Create Access database tables.mp4 | 11.6 MB | ||
| 0301.Create Access database tables.srt | 10.3 KB | ||
| 0302.Import and link Excel data as tables.mp4 | 14.8 MB | ||
| 0302.Import and link Excel data as tables.srt | 10.7 KB | ||
| 0303.Create Access tables from Excel data.mp4 | 4.7 MB | ||
| 0303.Create Access tables from Excel data.srt | 3.5 KB | ||
| 0304.Create basic queries using tables.mp4 | 5.2 MB | ||
| 0304.Create basic queries using tables.srt | 3.7 KB | ||
| 0305.Work with the Linked Table Manager.mp4 | 7.9 MB | ||
| 0305.Work with the Linked Table Manager.srt | 6.6 KB | ||
| 0401.Calculate in Excel versus Access.mp4 | 15.2 MB | ||
| 0401.Calculate in Excel versus Access.srt | 8.8 KB | ||
| 0402.Common formulas for data mining in Excel.mp4 | 17.7 MB | ||
| 0402.Common formulas for data mining in Excel.srt | 11.2 KB | ||
| 0403.Calculate in Access tables.mp4 | 4.4 MB | ||
| 0403.Calculate in Access tables.srt | 3.8 KB | ||
| 0404.Calculate totals in Access queries.mp4 | 5.6 MB | ||
| 0404.Calculate totals in Access queries.srt | 4.7 KB | ||
| 0501.Save imports and exports.mp4 | 20.4 MB | ||
| 0501.Save imports and exports.srt | 11.8 KB | ||
| 0502.Action queries in Access.mp4 | 13.5 MB | ||
| 0502.Action queries in Access.srt | 8.9 KB | ||
| 0503.Build macros to run on-demand queries.mp4 | 15.4 MB | ||
| 0503.Build macros to run on-demand queries.srt | 10.2 KB | ||
| 0601.Build a basic report.mp4 | 10.8 MB | ||
| 0601.Build a basic report.srt | 7.5 KB | ||
| 0602.Build parameter queries.mp4 | 14.6 MB | ||
| 0602.Build parameter queries.srt | 8.9 KB | ||
| 0602.Build parameter queriess.srt | 8.9 KB | ||
| 0603.Build reports on your new queries.mp4 | 15.3 MB | ||
| 0603.Build reports on your new queries.srt | 8.2 KB | ||
| 0604.Export information back to Excel.mp4 | 16.5 MB | ||
| 0604.Export information back to Excel.srt | 10.2 KB | ||
| 0701.Build forms and navigation forms.mp4 | 21 MB | ||
| 0701.Build forms and navigation forms.srt | 12.7 KB | ||
| 0702.Add reports to your navigation form.mp4 | 13.2 MB | ||
| 0702.Add reports to your navigation form.srt | 7.1 KB | ||
| 0703.Build forms for parameter queries.mp4 | 20.5 MB | ||
| 0703.Build forms for parameter queries.srt | 12.5 KB | ||
| 0704.Add command buttons for navigation.mp4 | 10.3 MB | ||
| 0704.Add command buttons for navigation.srt | 6.5 KB | ||
| 0705.Build macros on events.mp4 | 10.3 MB | ||
| 0705.Build macros on events.srt | 7.7 KB | ||
| 0801.Build data links to Excel.mp4 | 13.9 MB | ||
| 0801.Build data links to Excel.srt | 8.1 KB | ||
| 0802.Create macros that export data.mp4 | 19 MB | ||
| 0802.Create macros that export data.srt | 12.2 KB | ||
| 0803.Use the AutoExec macro in Access.mp4 | 5 MB | ||
| 0803.Use the AutoExec macro in Access.srt | 3.4 KB | ||
| 0804.Set the Access database options.mp4 | 7 MB | ||
| 0804.Set the Access database options.srt | 5.4 KB | ||
| 0805.Finalize and run the solution.mp4 | 10.5 MB | ||
| 0805.Finalize and run the solution.srt | 7.2 KB | ||
| 0901.Next steps.mp4 | 1.7 MB | ||
| 0901.Next steps.srt | 1.1 KB | ||
| ▲ 67 total files | |||
By combining the powers of Microsoft Excel and Access 2019, you can automate repetitive Excel tasks and boost your personal productivity. In this course, learn strategies and techniques that can help you work smarter with Excel and Access, and avoid needing to manually rebuild each time you run reports by building solutions. Discover how to most effectively leverage these two programs, and get the most out of both tools working together. 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 demonstrates how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more.
Stream Building Solutions Using Excel and Access 2019 Together
Course Online
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
[TutorialPace] [LINKEDIN LEARNING] C Essential Training 1 The Basics - [TP] Posted by
TutorialPace in Other
|
377.4 MB | TutorialPace | 6 years | 1 | 1 |
|
[TutorialPace] [LINKEDIN LEARNING] Developing Investment Acumen - [TP] Posted by
TutorialPace in Other
|
340.5 MB | TutorialPace | 6 years | 0 | 0 |
|
[TutorialPace] [LINKEDIN LEARNING] Windows Server 2019 Essential Training - [TP] Posted by
TutorialPace in Other
|
369.6 MB | TutorialPace | 6 years | 0 | 0 |
|
[TutorialPace] [LINKEDIN LEARNING] Building a Web Application on Microsoft Azure - [TP] Posted by
TutorialPace in Other
|
326.9 MB | TutorialPace | 6 years | 1 | 1 |
|
[TutorialPace] [LINKEDIN LEARNING] Transitioning from Manager to Leader - [TP] Posted by
TutorialPace in Other
|
569.4 MB | TutorialPace | 6 years | 0 | 0 |
All Comments