Microsoft Office Tutorials and References
In Depth Information
AC 230
Access Integration Feature Sharing Data Among Applications
Feature Summary
In this feature you have learned to import from and link to data in Excel worksheets,
other Access databases, and text fi les; export data to Excel worksheets, Word documents,
and text fi 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 profi 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 diffi 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 fi 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 fi 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 fi le.
Search JabSto ::




Custom Search