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 3

Prerequisites: Access 2003: Level 2 or equivalent experience

Fee:

Date / Course#:

$145

 Friday 5/9/08
Friday 5/16/08
Friday 7/25/08
Friday 8/1/08		 S18C4
S18C5
U19C4
U19C5
Time: Registration: 
8:30 a.m.-4:30 p.m.
 Click Here for Registration Information
Learning Objectives:
bullet Use SQL statements and examine them in Access, write SQL statements to create queries, and attach an SQL statement to a command button.
bullet Create crosstab queries to summarize grouped data, create parameter queries to view results based on specified criteria, and create action queries to add, delete, and modify data in tables and to create new tables.
bullet Create and run macros to automate tasks and attach macros to the events of database objects.
bullet Create data validation and data-entry macros, create macros that run parameter queries, create the AutoKeys and AutoExec macros, and create macros to import and export database objects.
bullet Import Access objects into an active database from another Access database and from Excel, export objects from one active database to another Access database, export and import XML documents, link objects from one database to another and update the links, and export and import tables and queries to the Windows SharePoint Services site.
bullet Work with Database utilities to optimize resources, and replicate and synchronize a database.
bullet Use a password to secure database files, encrypt and decrypt databases, and set specific permissions for users to secure database objects.
Course Outline :

Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls

Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries

Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects

Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating the AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer

Unit 5: Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Interacting with the XML documents
Topic D: Linking Access objects
Topic E: Working with Windows SharePoint Services

Unit 6: Database management
Topic A: Optimizing resources
Topic B: Replicating and synchronizing databases

Unit 7: Security fundamentals
Topic A: Protecting databases
Topic B: Encrypting and decrypting databases
Topic C: User-level security