Jim Hewson
JHewson at karta.com
Mon Feb 9 11:09:28 CST 2004
That was my thought also. Give them the principles of development. And go from there. Thanks -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Monday, February 09, 2004 11:03 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Teaching Access Course I always give clients a brief explanation of relational theory and normalization so they can understand the principles of what I'm doing, and you can sometimes see the light go on for them. At that point they also stop arguing about the way the data structures should be designed and get back to what they want the application to do. Unfortunately, unless they use the theory on a daily basis, it doesn't stick. Charlotte Foust -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Monday, February 09, 2004 8:50 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Teaching Access Course I really wanted to teach the basic stuff. I guess, what I consider basic is way over the top for most neophytes. Thanks Jim -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Monday, February 09, 2004 10:44 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Teaching Access Course Teaching them to use an Access application is one thing. Teaching them to use Access itself is something else entirely. Unless these people are going to be developers, you don't need to do any of those things. If they *are* going to be developers, 2 days are not nearly enough. Charlotte Foust -----Original Message----- From: Jim Hewson [mailto:JHewson at karta.com] Sent: Monday, February 09, 2004 7:56 AM To: 'AccessD' 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