CEd Home    Buckeye Link    Campus Map    Find People    Webmail    
CEd
Mount Hall | 1050 Carmack Road | Columbus, OH 43210-1002 | (614) 292-8860    
 

On-campus Courses

Business and
Communication
Courses

Computer Courses

Language and
Culture Courses

Registration

 

spacer

Noncredit On-Campus Courses

a
 

 

 

a
spacer
Computer Classes
Access 2007-Level 1

Fee:

Date / Course#:

$150

Monday 10/26/09
Wednesday 1/6/10
F10C
W10C
Time:
Registration: 
8:30 a.m.-4:30 p.m.
Learning Objectives:
This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports.
Course Outline:

Unit 1: Getting started
Topic A: Database concepts
Topic B: Exploring the Access environment
Topic C: Getting help

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

Unit 5: Basic 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 Design view
Topic C: Sorting and filtering records

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

 

 

a
         

Give Access Feedback and Report Concerns
The Ohio State University | CEd Home Page
Site Map | Contact Webmaster

    2009 Office of Continuing Education