spacer
On-campus Noncredit Courses Certified Financial Planning Career Exploration Office Contact CEd Ohio State Links Register for CEd Programs Program 60 Online Noncredit Courses On-campus Noncredit Courses Contractual Outreach Conference Management Certified Manager Program Calendar of Events Bridge Program Information Academic Advising About CEd Academic Advising Bridge Program Information Calendar of Events Career Exploration Office Certified Financial Planning Certified Manager Program Certified Financial Planning Conference Management Contractual Outreach On-campus Noncredit Courses On-campus Noncredit Courses On-campus Noncredit Courses Online Noncredit Courses Program 60 Register for CEd Programs Contact CEd Ohio State Links
CEd Home Page
About Us
Academic Advising
Alumni
Bridge Program
Calendar of Events
Career Exploration Office
CFP® Program
CFP® Program
Conference Management Services
Contractual Outreach
Directions to CEd
Distance Learning Facility
Distance Learning Facility
On-campus Noncredit Courses
Online Noncredit Courses
Program 60
Register for CEd Programs
Mail CEd
Ohio State Links
spacer spacer
Computer Classes
Access 2003-Level 1

Fee:

Date / Course#:

$145

 Friday 4/11/08
Tuesday 4/15/08
Friday 6/27/08
Tuesday 7/1/08		 S18C
S18C1
U19C
U19C1
Time: Registration: 
8:30 a.m.-4:30 p.m.
 Click Here for Registration Information
Learning Objectives:
bullet Organize data efficiently by using a database management system; start Access and open Access databasess; and use the Help feature.
bullet Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
bullet Modify a table's design; use the Find feature and the spelling checker; and sort, filter, and delete records.
bullet Set field properties; create input masks; set validation rules; and create single and multiple-field indices.
bullet Create queries, and sort and filter the results; modify queries; and perform operations in queries.
bullet Create, modify, and work with forms; and use them to find, sort, and filter records.
bullet Create reports by using AutoReport, the Report Wizard, Design view, and queries; and modify and print report.
Course Outline :

Unit 1: Getting started
Topic A: Database concepts
Topic B: Exploring the Access environment
Topic C: Getting help
Topic D: Closing a database and Access

Unit 2: Databases and tables
Topic A: Planning and designing databases
Topic B: Exploring tables
Topic C: Creating tables

Unit 3: Fields and records
Topic A: Changing the design of a table
Topic B: Finding and editing records
Topic C: Organizing records

Unit 4: Data entry rules
Topic A: Setting field properties
Topic B: Working with input masks
Topic C: Setting validation rules
Topic D: Using indexes

Unit 5: Simple queries
Topic A: Creating and using queries
Topic B: Modifying query results and queries
Topic C: Performing operations in queries\

Unit 6: Using forms
Topic A: Creating forms
Topic B: Using the Form Wizard
Topic C: Using Design view
Topic D: Finding, sorting, and filtering records

Unit 7: Working with reports
Topic A: Creating reports
Topic B: Modifying and printing reports