TorBT - Torrents and Magnet Links Search Engine
Lynda - Building Solutions Using Excel 2013 and Access 2013 Together
- Date: 2026-09-17
- Size: 310 MB
- Files: 28
File Name
Size
01. Introduction/01_01-Welcome.mp4
3.6 MB
01. Introduction/01_02-What you should know before watching this course.mp4
1.4 MB
01. Introduction/01_03-Using the exercise files.mp4
2.6 MB
02. Understanding How to Use Excel and Access for a Solution/02_01-Understanding Excel and Access can work together.mp4
5.7 MB
02. Understanding How to Use Excel and Access for a Solution/02_02-Using the Problem Step Recorder.mp4
7.7 MB
03. Building Tables in Excel and Access/03_01-Creating Access database tables from scratch.mp4
8.8 MB
03. Building Tables in Excel and Access/03_02-Importing and linking Excel data as tables.mp4
14 MB
03. Building Tables in Excel and Access/03_03-Creating Access database tables from Excel tables.mp4
6.8 MB
03. Building Tables in Excel and Access/03_04-Creating basic queries using tables.mp4
4.6 MB
04. Calculating Data in Excel and Access/04_01-Calculating in Excel 2013 versus Access 2013.mp4
11 MB
04. Calculating Data in Excel and Access/04_02-Common formulas for data mining in Excel.mp4
28 MB
04. Calculating Data in Excel and Access/04_03-Calculating in Access 2013 tables.mp4
7.4 MB
04. Calculating Data in Excel and Access/04_04-Calculating in Access 2013 queries.mp4
20 MB
05. Building Forms for Your Solution/05_01-Building a basic form in Excel tables.mp4
6.7 MB
05. Building Forms for Your Solution/05_02-Setting the database options.mp4
8.1 MB
05. Building Forms for Your Solution/05_03-Adding command buttons for navigation.mp4
20 MB
06. Building Reports for Your Solution/06_01-Building parameter queries using forms.mp4
18 MB
06. Building Reports for Your Solution/06_02-Setting dropdowns for parameters.mp4
30 MB
06. Building Reports for Your Solution/06_03-Building reports on your new queries.mp4
13 MB
06. Building Reports for Your Solution/06_04-Adding the new reports to your navigation form.mp4
16 MB
06. Building Reports for Your Solution/06_05-Exporting information back to Excel.mp4
6.6 MB
07. Building Macros to Run Imports and Queries/07_01-Building an importexport macro.mp4
19 MB
07. Building Macros to Run Imports and Queries/07_02-Appending and updating queries in Access 2013.mp4
11 MB
07. Building Macros to Run Imports and Queries/07_03-Building macros to run on demand queries.mp4
17 MB
07. Building Macros to Run Imports and Queries/07_04-Understanding the AutoExec macro in Access.mp4
6.3 MB
07. Building Macros to Run Imports and Queries/07_05-Assigning and building macros on events and buttons.mp4
11 MB
08. Conclusion/08_01-Next steps.mp4
2.3 MB
Exercice Files/Ex_Files_Build_Excel_Acces.zip
4.8 MB