Building Solutions Using Excel 2013 and Access 2013 Together With Robin Hunt

[xidau123 13]

Building Solutions Using Excel 2013 and Access 2013 Together With Robin Hunt

Size: 351MB | Duration: 1h 46m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

 

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

 

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.