TGx:[LINKEDIN LEARNING] Building Solutions Using Excel and Access 2019 Together

Hot Picks

New TV

First Cam

New Movies

1080p x265

Misc

Torrent details for "[LINKEDIN LEARNING] Building Solutions Using Excel and Access 2019 Together - [FCO] TGx Exclusive" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

[LINKEDIN LEARNING] Building Solutions Using Excel and Access 2019 Together - [FCO] TGx Exclusive

Controls:

Report Torrent

Torrent verified by Prom3th3uS

Category:

Other > Training

Language:

English

Total Size:

361.13 MB

Info Hash:

a7185e2ba17c8dad1e09d29c65c73cf6062505d7

Added By:

Prom3th3uS :_verified_uploader:

Added:

03-12-2018 13:24

Views:

1,888

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

529

File	Size
01.Introduction/0101.Increase productivity by leveraging Excel and Access together.mp4	5.69 MB
01.Introduction/0101.Increase productivity by leveraging Excel and Access together.srt	1.79 kB
01.Introduction/0102.What you should know.mp4	463.50 kB
01.Introduction/0102.What you should know.srt	566.00 B
01.Introduction/0103.Exercise files.mp4	2.34 MB
01.Introduction/0103.Exercise files.srt	2.56 kB
02.Understanding How to Use Excel and Access for a Solution/0201.How Excel and Access can work together.mp4	5.54 MB
02.Understanding How to Use Excel and Access for a Solution/0201.How Excel and Access can work together.srt	6.00 kB
02.Understanding How to Use Excel and Access for a Solution/0202.Use the Problem Steps Recorder.mp4	5.99 MB
02.Understanding How to Use Excel and Access for a Solution/0202.Use the Problem Steps Recorder.srt	3.86 kB
02.Understanding How to Use Excel and Access for a Solution/0203.Use Microsoft Office screenshots.mp4	6.16 MB
02.Understanding How to Use Excel and Access for a Solution/0203.Use Microsoft Office screenshots.srt	3.76 kB
03.Building Tables in Excel and Access/0301.Create Access database tables.mp4	11.56 MB
03.Building Tables in Excel and Access/0301.Create Access database tables.srt	10.28 kB
03.Building Tables in Excel and Access/0302.Import and link Excel data as tables.mp4	14.77 MB
03.Building Tables in Excel and Access/0302.Import and link Excel data as tables.srt	10.69 kB
03.Building Tables in Excel and Access/0303.Create Access tables from Excel data.mp4	4.70 MB
03.Building Tables in Excel and Access/0303.Create Access tables from Excel data.srt	3.45 kB
03.Building Tables in Excel and Access/0304.Create basic queries using tables.mp4	5.25 MB
03.Building Tables in Excel and Access/0304.Create basic queries using tables.srt	3.68 kB
03.Building Tables in Excel and Access/0305.Work with the Linked Table Manager.mp4	7.86 MB
03.Building Tables in Excel and Access/0305.Work with the Linked Table Manager.srt	6.55 kB
04.Calculating Data in Excel and Access/0401.Calculate in Excel versus Access.mp4	15.16 MB
04.Calculating Data in Excel and Access/0401.Calculate in Excel versus Access.srt	8.80 kB
04.Calculating Data in Excel and Access/0402.Common formulas for data mining in Excel.mp4	17.73 MB
04.Calculating Data in Excel and Access/0402.Common formulas for data mining in Excel.srt	11.18 kB
04.Calculating Data in Excel and Access/0403.Calculate in Access tables.mp4	4.39 MB
04.Calculating Data in Excel and Access/0403.Calculate in Access tables.srt	3.80 kB
04.Calculating Data in Excel and Access/0404.Calculate totals in Access queries.mp4	5.61 MB
04.Calculating Data in Excel and Access/0404.Calculate totals in Access queries.srt	4.66 kB
05.Building Macros to Run Imports and Queries/0501.Save imports and exports.mp4	20.41 MB
05.Building Macros to Run Imports and Queries/0501.Save imports and exports.srt	11.83 kB
05.Building Macros to Run Imports and Queries/0502.Action queries in Access.mp4	13.53 MB
05.Building Macros to Run Imports and Queries/0502.Action queries in Access.srt	8.88 kB
05.Building Macros to Run Imports and Queries/0503.Build macros to run on-demand queries.mp4	15.44 MB
05.Building Macros to Run Imports and Queries/0503.Build macros to run on-demand queries.srt	10.22 kB
06.Building Reports for Your Solution/0601.Build a basic report.mp4	10.84 MB
06.Building Reports for Your Solution/0601.Build a basic report.srt	7.47 kB
06.Building Reports for Your Solution/0602.Build parameter queries.mp4	14.59 MB
06.Building Reports for Your Solution/0602.Build parameter queries.srt	8.95 kB
06.Building Reports for Your Solution/0602.Build parameter queriess.srt	8.95 kB
06.Building Reports for Your Solution/0603.Build reports on your new queries.mp4	15.25 MB
06.Building Reports for Your Solution/0603.Build reports on your new queries.srt	8.21 kB
06.Building Reports for Your Solution/0604.Export information back to Excel.mp4	16.55 MB
06.Building Reports for Your Solution/0604.Export information back to Excel.srt	10.18 kB
07.Building Forms for Your Solution/0701.Build forms and navigation forms.mp4	21.01 MB
07.Building Forms for Your Solution/0701.Build forms and navigation forms.srt	12.67 kB
07.Building Forms for Your Solution/0702.Add reports to your navigation form.mp4	13.24 MB
07.Building Forms for Your Solution/0702.Add reports to your navigation form.srt	7.13 kB
07.Building Forms for Your Solution/0703.Build forms for parameter queries.mp4	20.53 MB
07.Building Forms for Your Solution/0703.Build forms for parameter queries.srt	12.49 kB
07.Building Forms for Your Solution/0704.Add command buttons for navigation.mp4	10.34 MB
07.Building Forms for Your Solution/0704.Add command buttons for navigation.srt	6.52 kB
07.Building Forms for Your Solution/0705.Build macros on events.mp4	10.33 MB
07.Building Forms for Your Solution/0705.Build macros on events.srt	7.72 kB
08.Using Parameters, Queries, and Macros to Generate Datasets/0801.Build data links to Excel.mp4	13.94 MB
08.Using Parameters, Queries, and Macros to Generate Datasets/0801.Build data links to Excel.srt	8.07 kB
08.Using Parameters, Queries, and Macros to Generate Datasets/0802.Create macros that export data.mp4	18.97 MB
08.Using Parameters, Queries, and Macros to Generate Datasets/0802.Create macros that export data.srt	12.22 kB
08.Using Parameters, Queries, and Macros to Generate Datasets/0803.Use the AutoExec macro in Access.mp4	5.03 MB
08.Using Parameters, Queries, and Macros to Generate Datasets/0803.Use the AutoExec macro in Access.srt	3.41 kB
08.Using Parameters, Queries, and Macros to Generate Datasets/0804.Set the Access database options.mp4	7.01 MB
08.Using Parameters, Queries, and Macros to Generate Datasets/0804.Set the Access database options.srt	5.42 kB
08.Using Parameters, Queries, and Macros to Generate Datasets/0805.Finalize and run the solution.mp4	10.45 MB
08.Using Parameters, Queries, and Macros to Generate Datasets/0805.Finalize and run the solution.srt	7.23 kB
09.Conclusion/0901.Next steps.mp4	1.72 MB
09.Conclusion/0901.Next steps.srt	1.12 kB
Discuss.FreeTutorials.Us.html	165.68 kB
Ex_Files_Building_Solutions_Excel_Access_2019.zip	8.16 MB
FreeCoursesOnline.Me.html	108.30 kB
FreeTutorials.Eu.html	102.23 kB
Presented By SaM.txt	33.00 B
Torrent Downloaded From GloDls.to.txt	84.00 B
[TGx]Downloaded from torrentgalaxy.org.txt	524.00 B

Description

Course by: Robin Hunt
Duration: 2h 29m 12s
Skill Level: Intermediate
Released: November 30, 2018
Subtitle: Included
Torrent Contains: 73 Files, 9 Folders
Course Source: https://www.linkedin.com/learning/building-solutions-using-excel-and-access-2019-together

Course details

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.

Course Transcript

(instructor) In this course you'll learn how to increase your productivity by introducing database skills using Access to your every day Excel life. You'll learn how to link data to Access, automate the data mining you repetitively do in Excel and learn how to link live data back to Excel to leverage its strengths and flexibility in things like pivots. In this course we build on real life examples. I know people do the same repetitive things in Excel ever day and it's usually just to get the next version of the report. These techniques are one's I've used throughout my career and you can use any or all of them to increase your productivity. Hi, I'm Robin Hunt, co founder of ThinkData Solutions an active remember of the data community. I love to work with data of any type to automate steps, build more user friendly solutions and save time providing better reports. Let's get started on adding some very powerful tools and techniques to your data workbench.

For More Udemy Free Courses >>> http://www.freetutorials.eu
For more Lynda and other Courses >>> https://www.freecoursesonline.me/
Our Forum for discussion >>> https://discuss.freetutorials.eu/