Home»2023»January»29»Lynda Building Solutions Using Excel 2013 and Access 2013 Together
11:49:17
Lynda Building Solutions Using Excel 2013 and Access 2013 Together
Included Exercise Files
Skill Level : Intermediate
Duration : 1h 46m
Number of lessons: 65
Date Released : 9/15/2015
Language : English
Size : 277,64 Mb
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.
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
