The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

MS Access 2007 Intro Training

Posted: Wednesday, August 26, 2009

There are still seats available for the Data Warehouse: Introduction to Queries Using MS Access 2007 training on:

  • September 14, 2009 (1 p.m. -5 p.m.) and September 15, 2009 (8:30 a.m. - 12 p.m.)
  • Location: 23 Willard Building
  • Cost: $50/person

Prerequisite(s): Data Warehouse access is required; Data Warehouse & EIS: An Overview and Comparison or equivalent knowledge and skills.

This hands-on training session is designed for new users of Microsoft Access 2007 who will use Access to retrieve data from Penn State's Data Warehouse. The session covers only those features of Access that are needed to retrieve and manipulate Data Warehouse data effectively and efficiently. While learning Access, participants will also learn how to use Web resources to identify the databases, tables, and fields needed to retrieve data. This workshop makes use of a training database that includes tables from the Student Database. The session emphasizes those tables and fields in the Student Database that are most commonly used although the skills can be applied to all of the Penn State's Data Warehouse databases. A manual will be provided in this workshop.

Objectives:

  • Describe database fundamentals
  • Describe Penn State Data Warehouse fundamentals
  • Connect to the Data Warehouse
  • Create simple queries
  • Create new tables from a query
  • Sort and filter query results
  • Describe Data Warehouse security

To register, go to https://register4its.psu.edu/Public/ShowDetail.asp?scheduleid=106812. You must first log in to the registration system using your Penn State userID and password, then click on the Register button to complete your registration for the course.

For questions, contact itstraining@psu.edu or call (814)863-9522.

Content Questions: AIS Support