Database Implementation Platforms

MS Access

IIS Topics: SQL- PHP - Access - ORM - AI

Related Resources - Links to other people's pages covering related content - suggestions welcome.

Introducing MS Access - Orientation, The Database Window and objects that are contained within it

Data Definition - creating tables, defining relationships between tables and populations

Queries - retreiving data from an Access database using Query by Example (QBE) and raw SQL

Data Display- The Form - On-screen display of data from table objects within the database, includes general intro to Reports and Macros

A Case Study - The MUSIC Database

Music Database Definition
Creating the database and populating it
Simple Music Database Queries - retrieving data from the database
Simple forms - displaying data from a table on the screen
A Form with a Sub-form - Displaying data from two or more related tables the same screen
A Form With Graphics - using graphics to enhance the screen display
Simple Reporting - data display for the printer
An Introduction to Macros - a simple scripting language