Using Banner Reports in Microsoft Access

Quicknote #36

October 2007

Introduction:

This Quicknote is intended as a reports index for UM-Flint Banner Users.  It describes the Banner reports available through Microsoft Access in the ssem2000 database, how to open the database, and where to locate additional information about using each report.  Please refer to supplemental Quicknotes 36A, 36B 36C and 36E for additional instructions on using each type of report, as described below.

Table of Contents

¨       Introduction

¨       Before You Begin

¨       Opening the SSEM2000 Database

¨       Additional Resources

Quicknote 36A:

Course Information

¨       Course Rosters

¨       Waitlists

¨       Missing Grades

¨       Grade Verification

¨       Department Enrollment

¨       Closed Classes

¨       Classes Near Capacity

For detailed instructions on using Course Information reports refer to Quicknote 36A.

Quicknote 36B:

Student Information

¨       Current Students by Major (Address/Phone)

¨       Current Students by Major (Detailed)

¨       Current Students by Minor (Address/Phone)

¨       Minority Students Registered

¨       Advising Report by Major

¨       Registration Audit Report

For detailed instructions on using Student Information reports refer to Quicknote 36B.

Quicknote 36C:

Transcript Analysis

¨       Check Holds

¨       Institutional Transcript Analysis

¨       Transfer Transcript Analysis

For detailed instructions on using Transcript Analysis refer to Quicknote 36C.

Quicknote 36E:

Graduation Information

¨       Graduated Students for Selected MAJOR(s) All Terms

¨       Graduated Students for Selected MAJOR(s) Select term

¨       Anticipated Graduates for Selected MAJOR(s) and Selected term

For detailed instructions on using Graduation Information reports refer to Quicknote 36E

Note:  All reports require the user to enter his/her Banner ID and Password when the report is run.

(highlight DSAMIDA  and type your Banner ID)

1. From the Start menu, select Programs, then Microsoft Access.

2. Make sure Open an Existing Database is selected, then select More Files.... and click Ok.

3. In the space at the bottom titled File Name: type 
n:\user\Banner Reports\ssem2000.mdb and click Open.

**Note: After first use of the ssem2000 database, the file name will automatically appear in the space under, “Open an existing file," and you may simply double-click on the file name to reopen it.