| | 018 Setting dropdowns for parameters.mp4 | 29.48 MB |
| | 011 Common formulas for data mining in Excel.mp4 | 28.22 MB |
| | 013 Calculating in Access 2013 queries.mp4 | 19.66 MB |
| | 016 Adding command buttons for navigation.mp4 | 19.47 MB |
| | 022 Building an import-export macro.mp4 | 18.91 MB |
| | 017 Building parameter queries using forms.mp4 | 18.16 MB |
| | 024 Building macros to run on demand queries.mp4 | 16.74 MB |
| | 020 Adding the new reports to your navigation form.mp4 | 15.67 MB |
| | 007 Importing and linking Excel data as tables.mp4 | 14.17 MB |
| | 019 Building reports on your new queries.mp4 | 13.17 MB |
| | 026 Assigning and building macros on events and buttons.mp4 | 11.28 MB |
| | 023 Appending and updating queries in Access 2013.mp4 | 10.71 MB |
| | 010 Calculating in Excel 2013 versus Access 2013.mp4 | 10.61 MB |
| | 006 Creating Access database tables from scratch.mp4 | 8.8 MB |
| | 015 Setting the database options.mp4 | 8.05 MB |
| | 005 Using the Problem Step Recorder.mp4 | 7.71 MB |
| | 012 Calculating in Access 2013 tables.mp4 | 7.43 MB |
| | 008 Creating Access database tables from Excel tables.mp4 | 6.83 MB |
| | 014 Building a basic form in Excel tables.mp4 | 6.68 MB |
| | 021 Exporting information back to Excel.mp4 | 6.6 MB |
| | 025 Understanding the AutoExec macro in Access.mp4 | 6.34 MB |
| | 004 Understanding Excel and Access can work together.mp4 | 5.73 MB |
| | 009 Creating basic queries using tables.mp4 | 4.58 MB |
| | 001 Welcome.mp4 | 3.56 MB |
| | 003 Using the exercise files.mp4 | 2.62 MB |
| | 027 Next steps.mp4 | 2.33 MB |
| | 002 What you should know before watching this course.mp4 | 1.43 MB |
| | Recording_20150803_1250.mht | 2.05 MB |
| | 01_03_ProcessSteps_Finished.zip | 917.12 KB |
| | 01_03_Original_Finished.xlsx | 14.74 KB |
| | 01_03_Original_Start.xlsx | 13.95 KB |
| | 01_02_ExcelAndAccessSolution_Finish.accdb | 852 KB |
| | 01_02_ExcelAndAccessSolution_Start.accdb | 788 KB |
| | 01_02_ImportFile_StartOnly.xlsx | 13.95 KB |
| | 01_02_Original_StartOnly.xlsx | 13.9 KB |
| | 03_02_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.53 MB |
| | 03_02_SampleSolutions_ImportsAndLinks_Start.accdb | 1004 KB |
| | 03_02_ImportFile_Finish.xlsx | 18.78 KB |
| | 03_02_ImportFile_Start.xlsx | 14.97 KB |
| | 03_02_Original_Start.xlsx | 13.95 KB |
| | 03_03_SampleSolutions_ImportsAndLinks_Start.accdb | 1024 KB |
| | 03_03_SampleSolutions_ImportsAndLinks_Finish.accdb | 792 KB |
| | 03_03_ImportFile_Start.xlsx | 18.75 KB |
| | 03_03_Original_Start.xlsx | 13.95 KB |
| | 03_04_SampleSolutions_ImportsAndLinks_Start.accdb | 1004 KB |
| | 03_04_SampleSolutions_ImportsAndLinks_Finish.accdb | 792 KB |
| | 03_04_ImportFile_Start.xlsx | 18.75 KB |
| | 03_04_Original_Start.xlsx | 13.95 KB |
| | 03_04_NewHires_Start.xlsx | 12.28 KB |
| | 03_01_SampleSolutions_ImportsAndLinks_Finish.accdb | 792 KB |
| | 03_01_SampleSolutions_ImportsAndLinks_Start.accdb | 576 KB |
| | 03_01_ImportFile_Finish.xlsx | 14.97 KB |
| | 03_01_ImportFile_Start.xlsx | 14.01 KB |
| | 03_01_Original_Start.xlsx | 13.95 KB |
| | 06_05_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.2 MB |
| | 06_05_SampleSolutions_ImportsAndLinks_Start.accdb | 1.14 MB |
| | 06_05_All Orders All Dates_Start.xlsx | 35.02 KB |
| | 06_05_Orders_Start.xlsx | 33.04 KB |
| | 06_05_ImportFile_Start.xlsx | 18.75 KB |
| | 06_05_Original_Start.xlsx | 13.95 KB |
| | 06_05_NewHires_Start.xlsx | 12.01 KB |
| | 06_05_Customer_Start.xlsx | 9.09 KB |
| | 06_01_SampleSolutions_ImportsAndLinks_Start.accdb | 1.14 MB |
| | 06_01_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.14 MB |
| | 06_01_All Orders All Dates_Start.xlsx | 35.02 KB |
| | 06_01_Orders_Start.xlsx | 33.04 KB |
| | 06_01_ImportFile_Start.xlsx | 18.75 KB |
| | 06_01_Original_Start.xlsx | 13.95 KB |
| | 06_01_NewHires_Start.xlsx | 12.27 KB |
| | 06_01_Customer_Start.xlsx | 9.09 KB |
| | 06_03_SampleSolutions_ImportsAndLinks_Start.accdb | 1.14 MB |
| | 06_03_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.14 MB |
| | 06_03_All Orders All Dates_Start.xlsx | 35.02 KB |
| | 06_03_Orders_Start.xlsx | 33.04 KB |
| | 06_03_ImportFile_Start.xlsx | 18.75 KB |
| | 06_03_Original_Start.xlsx | 13.95 KB |
| | 06_03_NewHires_Start.xlsx | 12.27 KB |
| | 06_03_Customer_Start.xlsx | 9.09 KB |
| | 06_04_SampleSolutions_ImportsAndLinks_Start.accdb | 1.14 MB |
| | 06_04_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.14 MB |
| | 06_04_All Orders All Dates_Start.xlsx | 35.02 KB |
| | 06_04_Orders_Start.xlsx | 33.04 KB |
| | 06_04_ImportFile_Start.xlsx | 18.75 KB |
| | 06_04_Original_Start.xlsx | 13.95 KB |
| | 06_04_NewHires_Start.xlsx | 12.01 KB |
| | 06_04_Customer_Start.xlsx | 9.09 KB |
| | 06_02_SampleSolutions_ImportsAndLinks_Start.accdb | 1.14 MB |
| | 06_02_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.14 MB |
| | 06_02_All Orders All Dates_Start.xlsx | 35.02 KB |
| | 06_02_Orders_Start.xlsx | 33.04 KB |
| | 06_02_ImportFile_Start.xlsx | 18.75 KB |
| | 06_02_Original_Start.xlsx | 13.95 KB |
| | 06_02_NewHires_Start.xlsx | 12.27 KB |
| | 06_02_Customer_Start.xlsx | 9.09 KB |
| | 05_05_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.14 MB |
| | 05_05_SampleSolutions_ImportsAndLinks_Start.accdb | 1.14 MB |
| | 05_05_All Orders All Dates_Finish.xlsx | 35.02 KB |
| | 05_05_Orders_Start.xlsx | 33.04 KB |
| | 05_05_ImportFile_Start.xlsx | 18.75 KB |
| | 05_05_Original_Start.xlsx | 13.95 KB |
| | 05_05_NewHires_Start.xlsx | 12.28 KB |
| | ORDERS.xlsx | 9.29 KB |
| | 05_05_Customer_Start.xlsx | 9.09 KB |
| | ReportNav.xlsx | 8.8 KB |
| | 05_04_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.14 MB |
| | 05_04_SampleSolutions_ImportsAndLinks_Start.accdb | 1.13 MB |
| | 05_04_Orders_Start.xlsx | 33.04 KB |
| | 05_04_ImportFile_Start.xlsx | 18.75 KB |
| | 05_04_Original_Start.xlsx | 13.95 KB |
| | 05_04_NewHires_Start.xlsx | 12.28 KB |
| | 05_04_Customer_Start.xlsx | 9.09 KB |
| | 05_03_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.13 MB |
| | 05_03_SampleSolutions_ImportsAndLinks_Start.accdb | 1.04 MB |
| | 05_03_Orders_Start.xlsx | 33.04 KB |
| | 05_03_ImportFile_Start.xlsx | 18.75 KB |
| | 05_03_Original_Start.xlsx | 13.95 KB |
| | 05_03_NewHires_Start.xlsx | 12.28 KB |
| | 05_03_Customer_Start.xlsx | 9.09 KB |
| | 05_02_SampleSolutions_ImportsAndLinks_Start.accdb | 1.04 MB |
| | 05_02_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.04 MB |
| | 05_02_Orders_Start.xlsx | 33.04 KB |
| | 05_02_ImportFile_Start.xlsx | 18.75 KB |
| | 05_02_Original_Start.xlsx | 13.95 KB |
| | 05_02_NewHires_Start.xlsx | 12.28 KB |
| | 05_02_Customer_Start.xlsx | 9.09 KB |
| | 05_01_SampleSolutions_ImportsAndLinks_Finish.accdb | 1.04 MB |
| | 05_01_SampleSolutions_ImportsAndLinks_Start.accdb | 964 KB |
| | 05_01_Orders_Start.xlsx | 33.04 KB |
| | 05_01_ImportFile_Start.xlsx | 18.75 KB |
| | 05_01_Original_Start.xlsx | 13.95 KB |
| | 05_01_NewHires_Start.xlsx | 12.28 KB |
| | 05_01_Customer_Start.xlsx | 9.09 KB |
| | 04_02_SampleSolutions_ImportsAndLinks_Finished.accdb | 1.04 MB |
| | 04_02_SampleSolutions_ImportsAndLinks_Start.accdb | 856 KB |
| | 04_02_ImportFile_Start.xlsx | 18.75 KB |
| | 04_02_Original_Start.xlsx | 13.95 KB |
| | 04_02_NewHires_Start.xlsx | 12.28 KB |
| | 04_01_SampleSolutions_ImportsAndLinks_Start.accdb | 1.02 MB |
| | 04_01_SampleSolutions_ImportsAndLinks_Finish.accdb | 808 KB |
| | 04_01_ImportFile_Start.xlsx | 18.75 KB |
| | 04_01_Original_Start.xlsx | 13.95 KB |
| | 04_01_NewHires_Start.xlsx | 12.28 KB |
| | 04_03_SampleSolutions_ImportsAndLinks_Finish.accdb | 964 KB |
| | 04_03_SampleSolutions_ImportsAndLinks_Start.accdb | 856 KB |
| | 04_03_ImportFile_Start.xlsx | 18.75 KB |
| | 04_03_Original_Start.xlsx | 13.95 KB |
| | 04_03_NewHires_Start.xlsx | 12.28 KB |
| | 02_01_SampleSolutions_ImportsAndLinks_Start.accdb | 624 KB |
| | 02_04_SampleSolutions_ImportsAndLinkss_Start.accdb | 556 KB |
| | 02_04_SampleSolutions_ImportsAndLinks_Finish.accdb | 544 KB |
| | 02_02_SampleSolutions_ImportsAndLinks_Finish.accdb | 520 KB |
| | 02_02_SampleSolutions_ImportsAndLinks_Start.accdb | 500 KB |
| | 02_02_Original_Start.xlsx | 13.95 KB |
| | 02_02_ImportFile_Start.xlsx | 13.95 KB |
| | 02_03_SampleSolutions_ImportsAndLinks_Start.accdb | 516 KB |
| | 02_03_SampleSolutions_ImportsAndLinks_Finish.accdb | 504 KB |
| | 02_03_ImportFile_Start.xlsx | 13.95 KB |
| | 02_03_Original_Start.xlsx | 13.95 KB |