Building Solutions Using Excel 2013 and Access 2013 Together Год выпуска: 2015 Производитель: Lynda Сайт производителя: lynda.com Автор: Robin Hunt Продолжительность: 1:46 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: What happens when you combine Excel and Access? You get the best of both programs. Learn how to use Excel 2013 to get the most out of Access 2013 and save time building database solutions and running reports. Robin Hunt shows how to import and link to Excel data, run calculations in Excel and Access, build forms and reports in both programs, and automate tasks with macros, including the AutoExec startup macro in Access. These techniques are the key to better personal productivity data systems. Start watching now. Техники работы в Excel и Access для улучшения эффективности.
Содержание
Introduction Welcome What you should know before watching this course Using the exercise files 1. Understanding How to Use Excel and Access for a Solution Understanding Excel and Access can work together Using the Problem Step Recorder 2. Building Tables in Excel and Access Creating Access database tables from scratch Importing and linking Excel data as tables Creating Access database tables from Excel tables Creating basic queries using tables 3. Calculating Data in Excel and Access Calculating in Excel 2013 versus Access 2013 Common formulas for data mining in Excel Calculating in Access 2013 tables Calculating in Access 2013 queries 4. Building Forms for Your Solution Building a basic form in Excel tables Setting the database options Adding command buttons for navigation 5. Building Reports for Your Solution Building parameter queries using forms Setting dropdowns for parameters Building reports on your new queries Adding the new reports to your navigation form Exporting information back to Excel 6. Building Macros to Run Imports and Queries Building an import/export macro Appending and updating queries in Access 2013 Building macros to run on demand queries Understanding the AutoExec macro in Access Assigning and building macros on events and buttons Conclusion Next steps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
