Access 2003-Level 1

CEd Home Buckeye Link Campus Map Find People Webmail

CEd

Mount Hall | 1050 Carmack Road | Columbus, OH 43210-1002 | (614) 292-8860

CEd Programs Credit Programs Credit Online Courses Noncredit On-campus Courses Noncredit Online Courses Academic Advising Accelerated CFP® Bridge Certified Manager Program Military Nonprofit Leadership Program Program 60 Contact CEd

Corporate Training

University Collaboration

Information for Businesses Distance Learning Facility Contact CEd

Information for Faculty and Staff Conference Management Distance Learning Facility Contact CEd

Buckeye Link Master Schedule of Classes Tips for Adult Students Academic Advising Career Exploration Office CEd Office Hours Class Registration

Directions and Campus Map Financial Aid Information Military Engaged Campuses Contact CEd

Credit Courses Noncredit Courses Noncredit Online Courses

CEd Programs CEd Staff Mission & Vision Statements CEd In The News Contact CEd

On-campus Courses

Business and
Communication
Courses

Computer Courses

Language and
Culture Courses

Noncredit On-Campus Courses

Access 2003-Level 1
Fee:	Date / Course#:
$150	Monday 10/19/09 Wednesday 2/10/10	F10B W10B
Time:	Registration:
8:30 a.m.-4:30 p.m.	Click Here for Registration Information
Learning Objectives:
Organize data efficiently by using a database management system; start Access and open Access databasess; and use the Help feature. Plan and create a database; use Datasheet view and Design view; and create tables and work in tables. Modify a table's design; use the Find feature and the spelling checker; and sort, filter, and delete records. Set field properties; create input masks; set validation rules; and create single and multiple-field indices. Create queries, and sort and filter the results; modify queries; and perform operations in queries. Create, modify, and work with forms; and use them to find, sort, and filter records. 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

The Ohio State University | CEd Home Page
Site Map | Contact Webmaster

2009 Office of Continuing Education