Join Robin Hunt for an in-depth discussion in this video Importing and linking Excel data as tables, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- When you're working with data…you certainly never want to retype…qualified or verified data.…Especially if you can import it…or link it into your new system.…This, of course, reduced error.…The only time we retouch data…is when it's absolutely necessary.…And you always want to do this in a mathematical way…so that you can always rerun with the same results.…This is critical for good reports.…The biggest benefit of importing…is that it allows you to bring in the data…but also allows you to control the design.…
Let's start by importing in one of our sample Excel files.…I'll go to the External Data tab.…I'll go to Excel.…I'm going to browse to my exercise files,…and I'm going to bring in my Original file.…Now, I want to bring in the list of department names.…So, I'll select DepartmentListNames.…Choose Next.…I've made sure that my first row…does contain column headings and that box is checked.…
If you were linking this file,…you wouldn't be presented this option.…Here, I can change the Field Name.…I can adjust the data type.…
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.
Excel 2013: Data Validation in Depthwith Dennis Taylor1h 5m Intermediate
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.