RDBMS Application Development and Multiuser Databases Access Dev

1
RDBMS - Application Development and Multi-user
Databases (Access Dev)

• Meyer Tanuan, BCS, M.Math (CS), MBA
• Course Number 90466700
• Winter Term 2003

2
All About Me

• 15 years of IT experience as a Programmer,
  Analysts, Consultant and Systems/Dev/QA Manager
• Business Applications (ERP, MRP)
• Software Development (Database Apps, Handhelds,
  AppServer, etc.)
• www.conestogac.on.ca/mtanuan

3
Course Outline

• Access as a Development Tool
• Table Structures/Relationships
• Building Database Applications
• Queries, Forms, Reports,
• Macros, Modules
• Visual Basic for Applications (VBA)
• ActiveX Data Objects (ADO)

4
Course Outline (2)

• Debugging, Error Handling
• Documenting Your Application
• Developing Multi-user and Enterprise Applications

5
Evaluation Methods

• Tests (60)
• Mid-term (20)
• Finals (20)
• Quizzes (20)
• Assignments (40)
• Total of 4 to 6 assignments
• Standards Refer to Assignments page

6
Resources

• Textbook
• Mastering Access 2002 Desktop Environment
  (Balter)
• Reference (Optional)
• Access 2002 Programming By Example (Villareal)
• Hand-outs/ Exercises

7
How you can succeed

• Attend ALL classes
• Review the Course Requirements
• Submit ALL assignments promptly
• Check the course schedule (updated once a week)
• Read your textbook Try It sections
• If you dont understand, get help right away!

8
How you can help me succeed

• Give me feedback
• Send me email (mtanuan_at_conestogac.on.ca)
• If you have an issue, please be specific and
  provide a proposed solution (if possible)
• Attend ALL classes!