[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