[AccessD] Teaching Access Course

I run a couple of courses here

Users are taught how to work with existing systems. We do teach them a
little about table construction and relationships in the context of the work
they do with the existing systems. We dont teach norminisation, reserved
words etc which we cover in teh application development courses.

Martin


----- Original Message ----- 
From: "Jim Hewson" <JHewson at karta.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, February 09, 2004 4:10 PM
Subject: RE: [AccessD] Teaching Access Course


>
> All users.
> Jim
> -----Original Message-----
> From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
> Sent: Monday, February 09, 2004 10:05 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>