Microsoft Office Tutorials and References
In Depth Information
Access Integration Feature Sharing Data Among Applications
In this feature you have learned to import from and link to data in Excel worksheets,
other Access databases, and text ﬁ les; export data to Excel worksheets, Word documents,
and text ﬁ les; publish reports; and export and import XML data. The items listed below
include all the new Access skills you have learned in this chapter.
1. Import an Excel Worksheet (AC 212)
2. Import Data from Another Access Database (AC 217)
3. Link to Data in Another Access Database (AC 217)
4. Import Data from or Link Data to a Text File (AC 219)
5. Export Data to Excel (AC 221)
6. Export Data to Word (AC 223)
7. Export Data to a Text File (AC 224)
8. Publish a Report (AC 225)
9. Export XML Data (AC 226)
10. Import XML Data (AC 228)
If you have a SAM user proﬁ le, you may have access to hands-on instruction, practice, and
assessment. Log in to your SAM account (http://sam2007.course.com) to launch any assigned
training activities or exams that relate to the skills covered in this chapter.
In The Lab
Design, create, modify, and/or use a database following the guidelines, concepts, and skills
presented in this feature. Labs are listed in order of increasing difﬁ culty.
Lab 1: Importing Data to an Access Database
Problem: TAL Woodworks sells custom wood accessories for the home. TAL uses worksheets to
keep track of inventory and customers. TAL realizes that customer data would be better handled if
maintained in an Access database. The company wants to maintain the products inventory in Excel but
also would like to be able to use the query and report features of Access.
Instructions: For this assignment, you will need two ﬁ les: Customer.csv and Product.xlsx. See the inside
back cover of this topic for instructions for downloading the Data Files for Students, or see your
instructor for information on accessing the ﬁ les required in this topic. Perform the following tasks:
1. Start Access and create a new database in which to store all the objects for TAL Woodworks. Call
the database TAL Woodworks.
2. Import the Customer worksheet shown in Figure 26 into Access. The worksheet is saved as a .csv ﬁ le.