Microsoft Office Tutorials and References
In Depth Information
Access Integration Feature Sharing Data Among Applications
To Create a New Database
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
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 ﬂ ash drive.
1 With a USB ﬂ ash drive connected to one of the computer’s USB ports, click Blank Database
in the Getting Started with Microsoft Ofﬁ 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 ﬂ ash drive
as the new save location.
4 Click the OK button to select the USB ﬂ ash drive as the location for the database and to
return to the Getting Started with Microsoft Ofﬁ ce Access screen.
5 Click the Create button to create the database on the USB ﬂ ash drive with the ﬁ le name,
To Import XML Data
The following steps import both the Client and Recruiter tables stored in the XML ﬁ le called Client. In
addition to having the same data, the ﬁ elds in both tables will have precisely the same data types and sizes as in the
original database. Also, the same ﬁ elds will have been designated primary keys.
• With the JSP Consulting database
open, click External Data on the
Ribbon to display the External
• Click the XML File button in the
Import group on the External Data
tab to display the Get External
Data - XML File dialog box.
Client ﬁ le
• Click the Browse button in the Get
External Data - XML File dialog
box to display the File Open
• If necessary, select UDISK 2.0 (E:) in
the Look in list.
• Click the Client ﬁ le to select it
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.