[AccessD] Teaching Access Course

Teaching them to use an Access application is one thing.  Teaching them
to use Access itself is something else entirely.  Unless these people
are going to be developers, you don't need to do any of those things.
If they *are* going to be developers, 2 days are not nearly enough.

Charlotte Foust

-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com] 
Sent: Monday, February 09, 2004 7:56 AM
To: 'AccessD'
Subject: [AccessD] Teaching Access Course



Our customer has added a tasking on our contract.
I have developed several Access databases for this customer on several
different contracts.  They want a two-day course to teach 6-10 people.
A classroom with computers and Access loaded on them will be on their
site. The student's experience ranges from someone who knows how to
spell Access to someone who thinks they know how to use it. I do have
experience conducting courses - just not Access.

My first cut of a syllabus is below.  Any suggestions?

Thanks in advance.
Jim

1.  Introduction to Databases
	a.	Systems [Software] Development Life Cycle (SDLC
	b.	Database Nomenclature
	c.	Naming Conventions
	d.	Normalization
	e.	Relational Database
	f.	Database design concepts
2.  Introduction to Access
	a.	Access Specifications
	b.	Short cut keys
	c.	Reserved Words
	d.	Access Objects
	e.	Relationships between tables
3.  Access Tables
	a.	Primary keys
	b.	Fields and records
	c.	Navigate through records
	d.	Enter, edit and delete records
	e.	Format tables
	f.	Filtering data in tables
4.  Designing Access Tables
	a.	Design view
	b.	Adding and naming fields
	c.	Assigning Field types
	d.	Assigning Field Properties
	e.	Creating Key Fields
	f.	Creating relationships
5.  Designing Access Queries
	a.	Using "And" and "Or" statements
	b.	"=" vs "like"
	c.	Parameter Queries
	d.	Auto lookup Queries
	e.	Advanced Queries (Nested Queries, Sub-queries)
	f.	Insert/Update/Delete/Make-Table Queries
6.   Access Form Design
	a.	Designing a Form
	b.	Formatting forms
	c.	Adding controls
	d.	Combo boxes / list boxes
	e.	Groups
	f.	MS Visual Basic
	g.	Using Wizards
7.  Access Report Design
	a.	Creating a report
	b.	Formatting reports
	c.	Using Wizards


Jim H. Hewson
Marketing/Proposal Support Manager
Karta Technologies, Inc.
5555 Northwest Parkway
San Antonio, Texas 78249
210-582-3233 
jhewson at karta.com <mailto:jhewson at karta.com>