[AccessD] Teaching Access Course

Are they users or soon to be developers?

Martin


----- Original Message ----- 
From: "Jim Hewson" <JHewson at karta.com>
To: "'AccessD'" <accessD at databaseadvisors.com>
Sent: Monday, February 09, 2004 3:55 PM
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>
>
>
>


----------------------------------------------------------------------------
----


> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>