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

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size352.6 MB
  • Uploaded ByTutorialPace
  • Downloads201
  • Last checkedMay. 18th '19
  • Date uploadedMay. 17th '19
  • Seeders 7
  • Leechers1
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : AF1F9F086A813A0442C82D0FFCA162A9D5D61511

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

Files:

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

Code:

  • udp://tracker.openbittorrent.com:80/announce
  • udp://tracker.opentrackr.org:1337/announce