Join Robin Hunt for an in-depth discussion in this video Exporting information back to Excel, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- Most organizations like to use Excel for reporting,…so it's important when you build solutions,…to know how to get your data back to Excel,…when the process requires it.…All users like Excel for the same purpose,…they know how to work with it,…and they can easily tweak and change it.…Let me show you a couple of different ways to Export.…We've clicked on the External tab to do Imports.…You can also go there for Exports.…Also you can right-click, and go to Export.…Alright, let's go build our parameters in.…
So I'll go to Reports.…I'm going to choose my Customer Name.…I'll put in my Dates.…And then I'm going to tab out of that,…to make sure it sits.…Okay, then I'm going to right-click my Orders Query,…on the left-hand side,…I'll go to Export,…and I'll choose Excel.…You'll navigate and give it a location.…You can choose to Export it with format and layout.…And if you want to see it as soon as it's done,…you can also tell it to Open the destination file.…
I'll click OK.…Excel immediately opens,…and then I see my results.…
These techniques are the key to better personal productivity data systems. Start watching now.
- 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
Skill Level Intermediate
Q: How do I open the exercise files?
A: Press and hold Shift when opening the exercise files for this course.
1. Understanding How to Use Excel and Access for a Solution
2. Building Tables in Excel and Access
3. Calculating Data in Excel and Access
4. Building Forms for Your Solution
Setting the database options2m 53s
5. Building Reports for Your Solution
6. Building Macros to Run Imports and Queries
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.