Email addresses for new admits

Description: This short tutorial demonstrates how to pull university email addresses for new program admits.
Program Used: Microsoft Office – Access
Skill Level: Basic

Query Setup

  1. In Microsoft Access navigate to the Create tab and select Query Design.
  2. Search through your table listings on the left and pull dbo_htv_email_addr and dbo_htv_mojor_program into the Query1 design window.
  3. Join the tables on ID by clicking and dragging the ID field from one table to the ID field in the other.
  4. Find the field EmailAddr from the dbo_htv_email_addr table and double-click on it to add it to the list of fields that will display in your report.
    1. Do the same for ProgramCode, Status and SemAdmitted in the dbo_htv_major_program table

Filters

Adding Criteria to fields to filter the data

  1. Status: = 1 (Represents open programs only)
  2. SemAdmitted: = 201505 (For FL2015 program admit)
  3. ProgramCode: Like “EN%” – (In this instance we will get back all of the Engineering undergrad division programs)


Your final setup should look similar to the image below.
You can uncheck the Show checkboxes for ProgramCode, Status and SemAdmitted if you only want to see the Email Address

October 2015 SIS Reporting Database Newsletter – RCroft