Microsoft Office Tutorials and References
In Depth Information
Importing and Linking
You may be familiar with this distinction if you’ve worked with other Oi ce programs,
especially Word and Excel. Importing is static. It’s like taking a snapshot of the external data
source (such as a spreadsheet) and bringing it into a database. Changes made to the external data
source are not rel ected in Access. In contrast, linking is dynamic. Changes to the external data
source are automatically updated in Access.
1 Instead of importing the spreadsheet data, link to it. It’s almost the same as the importing
procedure you just completed. Start at Step 2 and follow the importing procedure, except
on the i rst screen of the Get External Data window click the third option ( Link to the
data source by creating a linked table ). The default Linked Table Name is Sheet1.
2 After Access creates the table, open the spreadsheet in Excel and make some changes.
Give a few hitters much better batting averages!
If your linked Access table doesn’t refresh when you change the Excel spreadsheet:
• In Access, make sure you’re looking at the correct table (not Roster, in which you
performed a static import).
• In Excel, make sure you saved your changes.
• Depending on your system, changes may take some time, either way, it should not take
more than 30 seconds.
• If the link still appears broken, in Access, manually update the link by clicking External
Data > Linked Table Manager. (This is especially important if you’ve moved the Excel i le
from its original location.)
Name two ways to create a database in Access 2010.
True or False: When creating a table, the status bar indicates which view you’re using.
True or False: Of the two views in this lesson, Database view of ers the most control over
i eld structure and properties.
You can either create a blank database or use a template.
True, both ends of the status bar indicate the current view.
False, the Design view of ers much more control.