Lynda - Building Solutions Using Excel 2013 and Access 2013 Together

1. 01. Introduction/01_01-Welcome.mp43.56MB
2. 01. Introduction/01_02-What you should know before watching this course.mp41.43MB
3. 01. Introduction/01_03-Using the exercise files.mp42.62MB
4. 02. Understanding How to Use Excel and Access for a Solution/02_01-Understanding Excel and Access can work together.mp45.73MB
5. 02. Understanding How to Use Excel and Access for a Solution/02_02-Using the Problem Step Recorder.mp47.71MB
6. 03. Building Tables in Excel and Access/03_01-Creating Access database tables from scratch.mp48.8MB
7. 03. Building Tables in Excel and Access/03_02-Importing and linking Excel data as tables.mp414.17MB
8. 03. Building Tables in Excel and Access/03_03-Creating Access database tables from Excel tables.mp46.83MB
9. 03. Building Tables in Excel and Access/03_04-Creating basic queries using tables.mp44.58MB
10. 04. Calculating Data in Excel and Access/04_01-Calculating in Excel 2013 versus Access 2013.mp410.61MB
11. 04. Calculating Data in Excel and Access/04_02-Common formulas for data mining in Excel.mp428.22MB
12. 04. Calculating Data in Excel and Access/04_03-Calculating in Access 2013 tables.mp47.43MB
13. 04. Calculating Data in Excel and Access/04_04-Calculating in Access 2013 queries.mp419.66MB
14. 05. Building Forms for Your Solution/05_01-Building a basic form in Excel tables.mp46.68MB
15. 05. Building Forms for Your Solution/05_02-Setting the database options.mp48.05MB
16. 05. Building Forms for Your Solution/05_03-Adding command buttons for navigation.mp419.47MB
17. 06. Building Reports for Your Solution/06_01-Building parameter queries using forms.mp418.16MB
18. 06. Building Reports for Your Solution/06_02-Setting dropdowns for parameters.mp429.48MB
19. 06. Building Reports for Your Solution/06_03-Building reports on your new queries.mp413.17MB
20. 06. Building Reports for Your Solution/06_04-Adding the new reports to your navigation form.mp415.67MB
21. 06. Building Reports for Your Solution/06_05-Exporting information back to Excel.mp46.6MB
22. 07. Building Macros to Run Imports and Queries/07_01-Building an importexport macro.mp418.91MB
23. 07. Building Macros to Run Imports and Queries/07_02-Appending and updating queries in Access 2013.mp410.71MB
24. 07. Building Macros to Run Imports and Queries/07_03-Building macros to run on demand queries.mp416.74MB
25. 07. Building Macros to Run Imports and Queries/07_04-Understanding the AutoExec macro in Access.mp46.34MB
26. 07. Building Macros to Run Imports and Queries/07_05-Assigning and building macros on events and buttons.mp411.28MB
27. 08. Conclusion/08_01-Next steps.mp42.33MB