Manual Access 2007

Technology Training Services

Introduction To Microsoft Access 2007

Introduction to Access 2007

Written by Kathleen A. Moser, PhD Technology Training Services April 2008

Maricopa County Community College District

© April, 2008

The Maricopa County Community College District is an EEO/AA institution. This training manual may be duplicated or put on the Internet for instructionalpurposes. Please give credit to the Maricopa Community Colleges and to the author(s). This training manual is not to be sold for profit.

Technology Training Services Maricopa Community Colleges 2411 West 14th Street Tempe, Arizona 85281-6942 http://www.maricopa.edu/training

(480) 731-8287

TECHNOLOGY TRAINING SERVICES VISION & MISSION
Vision Technology Training Services is dedicated toimproving employee job performance at all levels by exceeding expectations in the areas of technology training, instructional design, and customer support. Technology Training Services provides leadership and support to the Maricopa Community College District as the District implements new technologies that address challenging administrative needs and educational standards. We design, develop, anddeliver the highest quality in-service technology training, materials, and support to all of the employees of the Maricopa Community Colleges. To fulfill this mission we: • • • Provide responsive and accessible technology training on a variety of administrative systems and desktop applications. Design and develop comprehensive training and reference materials. Provide technology training support ina variety of ways including telephone help lines, one-on-one assistance, online help, troubleshooting, consultation, and referral services. Support the colleges' technology training efforts by delivering onsite technology training, delivering Train-the-Trainer sessions, and providing training materials. Provide leadership and support to the teams implementing new technologies and administrativesystems within the organization. Cultivate positive partnerships with our colleges to meet and exceed their training needs and expectations. Collaborate with organizational teams to develop strategies to meet future technology training needs. Chair and host the Regional Training Committee (RTC) to collaboratively develop training strategies, maintain technology training consistency, and overcomethe challenging technology training needs throughout the District. Expand and update our knowledge and skills in the areas of technology, training, and instructional design.

Mission

•

•

• • •

•

TABLE OF CONTENTS
Access 2007 Objectives .................................................................. 1 Database Concepts.......................................................................... 2 Start Access..................................................................................... 4 The Access User Interface .............................................................. 6 Database Objects............................................................................. 8 Exploring An Existing Database................................................... 10 Tables –Getting Familiar With Datasheet View.......................... 12 Displaying Records In A Subdatasheet ........................................ 14 Finding And Editing Records ....................................................... 16 Replace Or Edit Data .................................................................... 18 SortingRecords............................................................................. 20 Applying And Removing Filters................................................... 23 Filtering By Selection ................................................................... 24 Filter By Form............................................................................... 25 Previewing & Printing – Formatting The Datasheet .................... 27 Tables – Taking Control With...