This tutorial builds upon the "Attaching a table in Access" tutorial. Here you will learn how to utilize the attached tables "FA97SLCT" and "userids" to create a file that can be pasted into a Eudora nickname file.

1) Bring up Access.
2) Open the database in which you had previously attached the "FA97SLCT" table and the "userid" table. Your database should include the tables as shown below.

3) Click on the Queries tab at the top of the window, Access 2.0 users will have the Queries tab listed to the left. Select "Design View" and click "OK".

4) Add both tables to the query by clicking on each file and then clicking "Add". Your query should then look like this. Close the show table dialog box. Next you want to click on the "STUDENT_ID" field of the "dbo_FA97SLCT" table; while holding the mouse key down, drag the field to the "SSN" field of the "dbo_userids" table and release the mouse key (drag-and-drop).

5) At this point you should have the tables joined as indicated by the line extending between the two tables. At this point you will add a couple of fields to the query to produce a nickname file. In this example we will pretend that we wish to generate a nickname file for all female students. Drag-and-drop the field "SEX" onto the first column of the table at the bottom of the screen releasing it on the "Field:" row. Type a capital "F" in the "Criteria" row of the same column and tap <enter>. Click the check box of the "Show:" row, this will hide the column when the query is executed. Next drag-and-drop the "Name" and "STATUS" fields to columns 3 and 4, skipping column 2, we will handle this next.

In column 2, cut&paste the following text:
expr: Trim([ACC_USERID]) & " (" & Trim([dbo_FA97SLCT].[NAME]) & ")"

This expresssion (expr:) creates the email id along with the "@psu.edu" suffix, followed by the person's name in parentheses. First the expr trims the ACC_USERID field removing trailing spaces. Next the string "@PSU.EDU" is concatenated to the trimmed ACC_USERID. Then the name, in parentheses, is added. After editting the query, save the query by selecting "File/Save". Now you are ready to run you query. You can run you query by selecting "Query/Run" from the menu bar or clicking on the "!" icon.

6) The output of your query should look something like this. You can now cut and paste as many of these records as you wish into a Eudora nickname file.