Project 3B Overview | Sailor's Age | Query in Query | Structure Modifications | Export XML

Export as XML, view in Browser

There are 2catalyst question on this page

Another recent development is that the Boat Club has installed devices in each boat that broadcast their location (latitude and longitude). When the Boat Club needs to know where a boat is, they can import this data into Access where it's stored in tableLocations. It can then be combined with other information and exported to an XML file which is then stored online where it can be accessed by a web page that uses the Google Maps service.

Now you'll learn how to create the XML file.

1. First create this query:

2. Save it and give it the name queryBoatLocations:

3. Go to the External Data tab, click on the More drop-down list in the Export section and choose XML File:

4. You'll get a dialog box that asks for the location and name of the file that will be created. Name the file BoatLocations.xml:

5. When you click on the OK button, you'll see the message box shown below. Leave the first two boxes checked:

6. Next you'll be asked whether you want to save export steps. Don't bother.. Close this message box.

 

7. Open a browser (Firefox or Internet Explorer), and use File-Open to view BoatLocations.xml:

This is what the file will look like in Firefox:

This is what it will look like in Internet Explorer:

Notice that you can click on the minus signs to collapse records:

8. Collapse the first 5 records. The 6th record has <ID>16</ID>

9. Go to the catalyst and answer question 21 about the 6th record. What is the color and what is the boatType?

10. Now go to this site to see a Google Map that is pulling information from an identical copy of the xml file you just created.

11. Use the Google map to answer question 22 in Catalyst

There is a boat in the far east side of Union Bay. If you click on it, you will see a popup window with the boat's name:

.

Answer question 22 in Catalyst. Assume that the date is June 25, 2008. Who reserved that boat today?

Save the database and your queries and upload to Catalyst Collect It. Be sure to submit the quiz before the deadline.