[AccessD] Teaching Access Course

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Mon Feb 9 10:20:41 CST 2004


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




More information about the AccessD mailing list