Lynda Building Solutions Using Excel 2013 and Access 2013 Together

/01. Introduction/

01_01-Welcome.mp4

01_02-What you should know before watching this course.mp4

01_03-Using the exercise files.mp4

/02. Understanding How to Use Excel and Access for a Solution/

02_01-Understanding Excel and Access can work together.mp4

02_02-Using the Problem Step Recorder.mp4

/03. Building Tables in Excel and Access/

03_01-Creating Access database tables from scratch.mp4

03_02-Importing and linking Excel data as tables.mp4

03_03-Creating Access database tables from Excel tables.mp4

03_04-Creating basic queries using tables.mp4

/04. Calculating Data in Excel and Access/

04_01-Calculating in Excel 2013 versus Access 2013.mp4

04_02-Common formulas for data mining in Excel.mp4

04_03-Calculating in Access 2013 tables.mp4

04_04-Calculating in Access 2013 queries.mp4

/05. Building Forms for Your Solution/

05_01-Building a basic form in Excel tables.mp4

05_02-Setting the database options.mp4

05_03-Adding command buttons for navigation.mp4

/06. Building Reports for Your Solution/

06_01-Building parameter queries using forms.mp4

06_02-Setting dropdowns for parameters.mp4

06_03-Building reports on your new queries.mp4

06_04-Adding the new reports to your navigation form.mp4

06_05-Exporting information back to Excel.mp4

/07. Building Macros to Run Imports and Queries/

07_01-Building an importexport macro.mp4

07_02-Appending and updating queries in Access 2013.mp4

07_03-Building macros to run on demand queries.mp4

07_04-Understanding the AutoExec macro in Access.mp4

07_05-Assigning and building macros on events and buttons.mp4

/08. Conclusion/

08_01-Next steps.mp4

/Exercice Files/

Ex_Files_Build_Excel_Acces.zip

Total files 28