Data Base Applications with Access

Course Objectives: This course provides the students with the ability to develop Web-based data base applications by linking Access data base with Web pages.

Course Outlines:

  1. Using Microsoft Access
    Overview & Example Project
    Database design concept
    Launching Microsoft Access
    A short tours on a existing case
    Creating database from template
    Designing Access Database
    Data Base concept and terms
    Creating database tables
    Inserting/Modifying/Deleting records
    Understanding Relational Database
    Key and relational database
    Three types of relations
    Creating a relational database
    What is database normalization
  2. Advanced Microsoft Access
    Creating Simple Query
    Creating Simple Query
    Creating a simple queries
    Criteria in queries
    Using OR and AND criteria
    Multi-table queries
    Designing Forms for Data Manipulation
    Making a simple form
    Manipulating data with a form
    How to use form control
    Linking Form and Query
    Creating professional form with sub-forms
    Queries and SQL
    Review of Microsoft Access
  3. Integrating Microsoft Access with the Web
    Client/Server Internet database
    Creating Static HTML Pages
    Client/Server Model
    What are ODBC,OLEDB,ADO,HTX/IDC?
    Using IDC/HTX to implement Web system
    Using IDC/HTX to implement Web system
    Exporting database using HTX/IDC
    Employee Phone query System
    Exporting Active Server Pages
    Exporting Active Server Page
    Database Security