microsoft access 2003.pdf

Microsoft Access 2003
(iTech Professional Enhancement Training)
Wesley Lance Blackwell
iTech Training Coordinator Wesley.Blackwell@usm.edu March 14, 2005
Documentation Outline Introduction …………………………………………………………………... Learning Objectives ………………………………………………………….. What is Access ……………………………………………………………… Access Definitions …………………………………………………………… Planning To Use Access ……………………………………………………… Examples of Table design …………………………………………………….. Access Walk Through - Open Microsoft Access …………………………………………………. - Database Objects ……………………………………………………. - Design Wizards ………………………………………………………….. - Tables …………………………………………………………………… - Table Diagram …………………………………………………………… - Navigational Aids ……………………………………………………….. - Table – DESIGN VIEW …………………………………………………. - Data Types & Example data …………………………………………….. - Forms ……………………………………………………………………. - Form Diagram …………………………………………………………… - Form – DESIGN VIEW …………………………………………………. - Queries ………………………………………………………………….. - Query Diagram ………………………………………………………….. - Query – DESIGN VIEW ……………………………………………….. - Reports …………………………………………………………………… - Report Diagram ………………………………………………………….. - Report – DESIGN VIEW ………………………………………….. Exercises 1. Creating Simple Tables a. Creating Tables using the Wizard ………………………… b. Creating Tables Manually ………………………………… c. Enter Data Into Tables Manually …………………………. 2. Creating Simple Forms a. Creating Forms using the Wizard ………………………… b. Creating Forms Automatically …………………………… c. Enter Data Into Tables Using Forms ……………………… 3. Creating Queries a. Creating Queries using the Wizard & One Table …………. b. Creating Queries using multiple tables ……………………. 4. Creating Reports a. Creating Reports using Wizard …………………………… b. Creating Reports using an Automatic Process ……………. 5. Importing Excel Spreadsheets a. Import Spreadsheet using Wizard ………………………… b. Created Query & Report from Imported Table …………… Access Components Review ………………………………………………….. 3 3 3 3 3 4 5 5 5 5 6 6 7 7 8 8 8 9 9 9 10 10 10
11 15 17 19 23 26 29 31 35 39 41 46 50

下一页

文档基本属性
文档语言：
文档格式：	pdf
文档作者：	超優
关键词：
主题：
备注：
点击这里显示更多文档属性
经理：
单位：
分类：
创建时间：
上次保存者：
修订次数：
编辑时间：
文档创建者：
修订：
加密标识：
幻灯片：
段落数：
字节数：
备注：
演示格式：
上次保存时间：