CD-MOTA (Monitor of Tourism Activity) is a compilation of the results of two major surveys conducted by the Bureau of Tourism Research. The International Visitor Survey (IVS) and Domestic Tourism Monitor (DTM) hold information on the movements, characteristics and travel patterns of visitors to Australia and Australians choosing to travel domestically. This database is the accumulated results as they have been tabulated and analysed.

From the UQ Library's home page http://www.library.uq.edu.au/

• Click on the link
• Go into the C link and click on CD-MOTA

NOTE: If prompted for a password, contact your branch library.

• Click on the option in the CD-MOTA database toolbar
• ask at the Information Desk in any branch library

1. Open CD-MOTA from the Library Databases page. If an error message appears, click on OK. The catalogue page will then open.

2. You need to choose which database you want to search. From this window, click once on the plus + sign beside BTR. There are two databases you can use - DTM (Domestic Tourism Monitor) and IVS (International Visitors Survey). Each of these also contains a number of databases. Click once on the plus + sign beside DTM (Domestic Tourism Monitor) to display these available databases.

3. Right mouse click on the database you want to use eg. Trips Database and select AutoRun by clicking once on it.

4. The box will then close so click on the OK. From this point, the next window will appear along with a box listing available fields.

5. In the box to the right, labeled Fields, double-click on the field you want included eg. Calender Year.

6. Choose the information you want from the window that appears. For example, for the Calender Year field, double-click on 1997 (Jan - Jun) or click once on 1997 (Jan - Jun) and then click on the Singly button. This will move that selection across to the Recode Values box. It is possible to select more than one year by highlighting each year or highlighting a group and clicking on the Singly button to move them to the Recode Values box. To highlight more than one year, click once on a year, hold down the Shift key and click the Singly button. This will move the highlighted selection across. It is also possible to group more than one value into a single group. Click on a year, hold down the Shift key and then using the arrows on the keyboard, select other years.

7. Click in the Group Name box and allocate a name for the group. Then click on the button. This will move the group to the Recode Values box.

Now click on the OK button. This will take you back to the main table page.

8. Choose the next field to be included in you table. For example, click on Main Regional Dest. in the fields and hold down the left mouse key. Drag the rectangle across to the left hand column to add it to your table.

Release the mouse key to drop all the fields into that column.

9. Choose the next field to be included. For example, click once on State of Origin and hold down the mouse key. Drag the rectangle across to the top column and release the mouse key. Click on the minimize button in the Fields toolbar to minimize the Fields box.

10. Click on the button in the top toolbar and a message about cross-tabulating records will come up, then the results will be shown on the screen.

1. Currently it is not possible to print or save directly from the CD-MOTA database. The easiest and best way to print or save your results, is to move the information across to an Excel document.

2. From the Edit menu, click on Select All. Click once again in the Edit menu then click on Copy.

3. Open Microsoft Excel. From the Edit menu in Excel, click on Paste. This will transfer all the information in the table across into the Excel document. It is possible now to print and save the results.

With CD-MOTA, there is a training module on how to make tables and do more in depth tasks. While in the main Table page, click on Help and choose the Demonstrations option. This will then list all the different demonstrations you can watch a movie for.

Updated November 2003

Ask at the Information Desk in any Branch Library

Back to the "How-to" guides Index