Using Banner-Access Databases

Opening the Database

1. Open the Banner folder.
2. Click on the Access icon for the database you wish to use (Development).
3. When Access starts, select a database linked to Banner (Phonathon (Development)).
4. Click OK.

Creating a Query

1. Create a new database and select the tables SATURN_SPRIDEN, SATURN_SPRADDR and SATURN_SPRTELE.

2. Click on the Queries tab.
3. Click on New.
 
4. Select Design View.
5. Click OK (all the tables selected for this database (SPRIDEN, SPRADDR and SPRTELE) will be listed).

6. Select all the tables by clicking on them.
7. Click Add, then Click Close. Each of the selected tables will be added to the new query.

8. Notice the key fields are bolded.  The "common thread" linking all 3 of these tables together is PIDM.

9. To link the tables, click on the PIDM column in a table and, while holding the left mouse button down, drag it to the PIDM file in the table (column) on its right. Do this two times to link all 3 tables together.

10. Address information in SPRADDR has to be linked with the same information in SPRTELE.  Click on SPRADDR_ATYP and, while holding the left mouse button down, drag it and drop it on SPRTELE_ATYP.  Likewise, do the same from SPRADDR_SEQ to SPRTELE_ADDR.

11. Double click on the fields you want to use to sort the query.  In this instance, we double clicked on SPRIDEN_CHANGE_IND in the SATURN_SPRIDEN table.  Also click on the box on the Show line, removing the checkmark, to ensure this data does not appear on screen when you later run the report.  Repeat with the following, all from the SATURN_SPRADDR table:

    • SPRADDR_ATYP_CODE
    • SPRADDR_FROM_DATE
    • SPRADDR_TO_DATE
    • SPRADDR_STAT_CODE


12. The last step is to enter the criteria you wish to use to sort the database. In this instance, we entered the following criteria on the Criteria line:

    • SPRIDEN_CHANGE_IND is null
    • SPRADDR_ATYP_CODE is MA
    • SPRADDR_FROM_DATE is null or prior to today
    • SPRADDR_TO_DATE is null or after today
    • SPRADDR_CITY_CODE is Anchorage
    • SPRADDR_STAT_CODE is AK

13. Click the exclamation point on the menu bar to run the query.

Remember to click the icon in the Banner folder when you want to report on Banner data. You can't double-click on a database or use the regular Start menu icon (because the path won't be setup correctly to connect with Banner).

Original instructions provided by Steve Read.

Go to PREVIOUS document in sequence:  Creating New Banner-Access Databases
Go to NEXT document in sequence:  Changing Links from Test to Production