Microsoft Office Tutorials and References
In Depth Information
AC 228
Access Integration Feature Sharing Data Among Applications
To Create a New Database
Quick Reference
For a table that lists how
to complete the tasks
covered in this topic
using the mouse, Ribbon,
shortcut menu, and
keyboard, see the Quick
Reference Summary at
the back of this topic, or
visit the Access 2007 Quick
Reference Web page
(scsite.com/ac2007/qr).
Before importing the data from the JSP Recruiters database, you need to create the
new JSP Consulting database that will contain the data. The following steps create the
JSP Consulting database on a USB fl ash drive.
1 With a USB fl ash drive connected to one of the computer’s USB ports, click Blank Database
in the Getting Started with Microsoft Offi ce Access screen to create a new blank database.
2 Type JSP Consulting in the File Name text box and then click the ‘Browse for a location
to put your database’ button to display the File New Database dialog box.
3 Click the Save in box arrow to display a list of available drives and folders and then click
UDISK 2.0 (E:) (your letter may be different) in the Save in list to select the USB fl ash drive
as the new save location.
4 Click the OK button to select the USB fl ash drive as the location for the database and to
return to the Getting Started with Microsoft Offi ce Access screen.
5 Click the Create button to create the database on the USB fl ash drive with the fi le name,
JSP Consulting.
To Import XML Data
The following steps import both the Client and Recruiter tables stored in the XML fi le called Client. In
addition to having the same data, the fi elds in both tables will have precisely the same data types and sizes as in the
original database. Also, the same fi elds will have been designated primary keys.
1
With the JSP Consulting database
open, click External Data on the
Ribbon to display the External
Data tab.
External
Data tab
XML File
button
Click the XML File button in the
Import group on the External Data
tab to display the Get External
Data - XML File dialog box.
UDISK 2.0
(E:) selected
Client fi le
selected
Click the Browse button in the Get
External Data - XML File dialog
box to display the File Open
dialog box.
If necessary, select UDISK 2.0 (E:) in
the Look in list.
Click the Client fi le to select it
(Figure 23).
Should I click the xsd version?
No. If you do, you will import both
tables, but none of the data. That
is, the tables will be empty.
XML selected
automatically
Open button
Figure 23
 
Search JabSto ::




Custom Search