No cover art

[TutorialPace.com] [LINKEDIN LEARNING] Building Solutions Using Excel and Access 2019 Together - [TP]

Size
353 MB
Seeders
0
Leechers
3
Files
67
Category
Added
05/17/19 at 12:39am GMT+1
Infohash
af1f9f086a813a0442c82d0ffca162a9d5d61511

Description
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

File list
  • [TutorialPace.com] [LINKEDIN LEARNING] Building Solutions Using Excel and Access 2019 Together - [TP]
  • 01.Introduction/0101.Increase productivity by leveraging Excel and Access together.mp4 5.7 MB
  • 01.Introduction/0101.Increase productivity by leveraging Excel and Access together.srt 1.8 KB
  • 01.Introduction/0102.What you should know.mp4 463.5 KB
  • 01.Introduction/0102.What you should know.srt 566 B
  • 01.Introduction/0103.Exercise files.mp4 2.3 MB
  • 01.Introduction/0103.Exercise files.srt 2.6 KB
  • 02.Understanding How to Use Excel and Access for a Solution/0201.How Excel and Access can work together.mp4 5.5 MB
  • 02.Understanding How to Use Excel and Access for a Solution/0201.How Excel and Access can work together.srt 6 KB
  • 02.Understanding How to Use Excel and Access for a Solution/0202.Use the Problem Steps Recorder.mp4 6 MB
  • 02.Understanding How to Use Excel and Access for a Solution/0202.Use the Problem Steps Recorder.srt 3.9 KB
  • 02.Understanding How to Use Excel and Access for a Solution/0203.Use Microsoft Office screenshots.mp4 6.2 MB
  • 02.Understanding How to Use Excel and Access for a Solution/0203.Use Microsoft Office screenshots.srt 3.8 KB
  • 03.Building Tables in Excel and Access/0301.Create Access database tables.mp4 11.6 MB
  • 03.Building Tables in Excel and Access/0301.Create Access database tables.srt 10.3 KB
  • 03.Building Tables in Excel and Access/0302.Import and link Excel data as tables.mp4 14.8 MB
  • 03.Building Tables in Excel and Access/0302.Import and link Excel data as tables.srt 10.7 KB
  • 03.Building Tables in Excel and Access/0303.Create Access tables from Excel data.mp4 4.7 MB
  • 03.Building Tables in Excel and Access/0303.Create Access tables from Excel data.srt 3.5 KB
  • 03.Building Tables in Excel and Access/0304.Create basic queries using tables.mp4 5.2 MB
  • 03.Building Tables in Excel and Access/0304.Create basic queries using tables.srt 3.7 KB
  • 03.Building Tables in Excel and Access/0305.Work with the Linked Table Manager.mp4 7.9 MB
  • 03.Building Tables in Excel and Access/0305.Work with the Linked Table Manager.srt 6.6 KB
  • 04.Calculating Data in Excel and Access/0401.Calculate in Excel versus Access.mp4 15.2 MB
  • 04.Calculating Data in Excel and Access/0401.Calculate in Excel versus Access.srt 8.8 KB
  • 04.Calculating Data in Excel and Access/0402.Common formulas for data mining in Excel.mp4 17.7 MB
  • 04.Calculating Data in Excel and Access/0402.Common formulas for data mining in Excel.srt 11.2 KB
  • 04.Calculating Data in Excel and Access/0403.Calculate in Access tables.mp4 4.4 MB
  • 04.Calculating Data in Excel and Access/0403.Calculate in Access tables.srt 3.8 KB
  • 04.Calculating Data in Excel and Access/0404.Calculate totals in Access queries.mp4 5.6 MB
  • 04.Calculating Data in Excel and Access/0404.Calculate totals in Access queries.srt 4.7 KB
  • 05.Building Macros to Run Imports and Queries/0501.Save imports and exports.mp4 20.4 MB
  • 05.Building Macros to Run Imports and Queries/0501.Save imports and exports.srt 11.8 KB
  • 05.Building Macros to Run Imports and Queries/0502.Action queries in Access.mp4 13.5 MB
  • 05.Building Macros to Run Imports and Queries/0502.Action queries in Access.srt 8.9 KB
  • 05.Building Macros to Run Imports and Queries/0503.Build macros to run on-demand queries.mp4 15.4 MB
  • 05.Building Macros to Run Imports and Queries/0503.Build macros to run on-demand queries.srt 10.2 KB
  • 06.Building Reports for Your Solution/0601.Build a basic report.mp4 10.8 MB
  • 06.Building Reports for Your Solution/0601.Build a basic report.srt 7.5 KB
  • 06.Building Reports for Your Solution/0602.Build parameter queries.mp4 14.6 MB
  • 06.Building Reports for Your Solution/0602.Build parameter queries.srt 8.9 KB
  • 06.Building Reports for Your Solution/0602.Build parameter queriess.srt 8.9 KB
  • 06.Building Reports for Your Solution/0603.Build reports on your new queries.mp4 15.3 MB
  • 06.Building Reports for Your Solution/0603.Build reports on your new queries.srt 8.2 KB
  • 06.Building Reports for Your Solution/0604.Export information back to Excel.mp4 16.5 MB
  • 06.Building Reports for Your Solution/0604.Export information back to Excel.srt 10.2 KB
  • 07.Building Forms for Your Solution/0701.Build forms and navigation forms.mp4 21 MB
  • 07.Building Forms for Your Solution/0701.Build forms and navigation forms.srt 12.7 KB
  • 07.Building Forms for Your Solution/0702.Add reports to your navigation form.mp4 13.2 MB
  • 07.Building Forms for Your Solution/0702.Add reports to your navigation form.srt 7.1 KB
  • 07.Building Forms for Your Solution/0703.Build forms for parameter queries.mp4 20.5 MB
  • 07.Building Forms for Your Solution/0703.Build forms for parameter queries.srt 12.5 KB
  • 07.Building Forms for Your Solution/0704.Add command buttons for navigation.mp4 10.3 MB
  • 07.Building Forms for Your Solution/0704.Add command buttons for navigation.srt 6.5 KB
  • 07.Building Forms for Your Solution/0705.Build macros on events.mp4 10.3 MB
  • 07.Building Forms for Your Solution/0705.Build macros on events.srt 7.7 KB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0801.Build data links to Excel.mp4 13.9 MB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0801.Build data links to Excel.srt 8.1 KB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0802.Create macros that export data.mp4 19 MB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0802.Create macros that export data.srt 12.2 KB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0803.Use the AutoExec macro in Access.mp4 5 MB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0803.Use the AutoExec macro in Access.srt 3.4 KB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0804.Set the Access database options.mp4 7 MB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0804.Set the Access database options.srt 5.4 KB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0805.Finalize and run the solution.mp4 10.5 MB
  • 08.Using Parameters, Queries, and Macros to Generate Datasets/0805.Finalize and run the solution.srt 7.2 KB
  • 09.Conclusion/0901.Next steps.mp4 1.7 MB
  • 09.Conclusion/0901.Next steps.srt 1.1 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
460 MB05/24/1910
103 MB05/13/1902
377 MB05/17/1902
353 MB05/17/1902
166 MB05/18/1901
1.2 GB05/18/1901
137 MB05/18/1902
180 MB05/18/1901
530 MB05/18/1901
340 MB05/18/1901
431 MB05/18/1901
266 MB05/18/1901
329 MB05/19/1901
494 MB05/21/1901
804 MB05/21/1901