[AccessD] Teaching Access Course

Jim Hewson JHewson at karta.com
Mon Feb 9 09:55:39 CST 2004


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>




More information about the AccessD mailing list