Services Offered Training Course Calendar Course Catalog Community Centers of Excellence Information & Resources
Course CatalogUnderstand and use sophisticated software for streamlined management of your data.
If you regularly use a database, it is critical to understand the concepts and terminology to do your work faster and with higher quality. Understanding how data systems work and how to talk about them and generate fundamental queries and reports helps your organization get the most out of their information systems. Learn these critical skills using Microsoft Access 2003. This is a “hands on” training using a real world example to learn how to create and use a typical nonprofit donor list. Skills taught include creating and populating database tables - fields, relationships, keys, data entry shortcuts- ,basic selection queries, and simple report creation.
For more sophisticated data system users, it is important to understand how to get quality data into systems using a user friendly, self checking graphical user interface. Also, being proficient at creating powerful queries can have a large impact on an agency’s ability to show program and operational results to managers and funders. In today’s funding environment, agencies that can report their community impact often attract additional funding. Work with a series of hands-on examples in Microsoft Access 2003 to explore form design, field manipulation, and display features. Create simple forms for data entry as well as drop down menus to ensure consistent data. Learn intermediate queries with calculated fields, table joins, Append Queries, Make Table Queries, Update Queries and crosstabs for flexible data manipulation and analysis.