[AccessD] Teaching Access Course

Martin Reid mwp.reid at qub.ac.uk
Mon Feb 9 10:40:42 CST 2004


Jim

A good starting point is the Microsoft Office User Specialist Course Access

Not sure of the URL but a full spec is on the MS web site.

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:23 PM
Subject: RE: [AccessD] Teaching Access Course


>
> In this context, my definition of users refers to those people who will
> "develop" databases on their computer, not for the use of others.
> These databases will be for personal use only.
>
>
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> Sent: Monday, February 09, 2004 10:21 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Teaching Access Course
>
>
> Jim, why would users ever need to know anything about field types,
> reserved words, and nested queries ????
>
> >
> > 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
>
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> 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
>



More information about the AccessD mailing list