microsoft access 2003.pdf

iTech Professional Enhancement Training
2
Introduction: This workshop consists of lecture as well as hands-on training for the Microsoft Access database application. Participants will gained basic skills in starting Access, creating database tables, building forms for data entry, running queries within the database environment, as well as creating reports for the data obtained from the queries. Participants are required to have basic computing skills prior to attending this training session. Learning Objectives Database terminology and principles Planning and designing a database Create simple database and objects Table Form Queries Reports What is Access anyway A program produced by Microsoft that enables users to organize information into lists Allows user to store, find, extract (or filter) portions, analyze, print, manage, and share large amounts of data Powerful relational database ("RDB") management system Access Definitions Database - collection of information organized into a list Relational Database - divides information into discrete groups (tables) which can then be related to each other using a common "key" or identifier Object - method of input or output to enter, view, or manipulate the data in a database Planning To Use Access Identify the purpose How will I use this What reports and lists do I need to produce What data do I need to collect Break the information into discreet pieces Determine fields (columns) and what type of data will be inserted Use multiple tables (each with fields related to a specific subject) to avoid redundancy Determine the relationship between tables Sketch a diagram or outline first Anticipate future (International Zip code extensions, etc.)
iTech Professional Enhancement Training
3
Examples of Table design: These are examples of different table designs, and it is important that you design your tables correctly so to utilize the full functions of Access. Name John Smith Angie Johnson George Ecks Bad Table Design First Last John Smith Angie Johnson George Ecks Good Table Design Address 408 W. Park 100 E. Central 501 3rd Street Address 408 W. Park, Lincoln, NE 68522 100 E. Central, Minneapolis, MN 55413 501 3rd Street, Houston, TX 77338

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