Building solutions with Excel & Access
By: Robin Hunt
Duration: 1h 46m
Date: 9/15/2015
Description:
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.
Topics include:
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries
Contents:
Introduction
1. Understanding How to Use Excel and Access for a Solution
2. Building Tables in Excel and Acce.ss
3. Calculating Data in Excel and Access
4. Building Forms for Your Solution
5. Building Reports for Your Solution
6. Building Macros to Run Imports and Queries
Conclusion
Get Download Robin Hunt – Building solutions with Excel & Access at coursesblock.com today!
Delivery Method
– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.
– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from coursesblock.com
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible at 8:00 AM – 8:00 PM (UTC 8).
Thank You For Shopping With Us!
