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
|