|
Learn about our courses
This page indexes the articles we have written to date.
Related databases and SQL scripts are available at
Box.com.
Microsoft Access Articles
Converting an ERD to a
Database - Top down approach to converting an ERD
(Entity Relationship Diagram) to a physical database. The focus is on
Microsoft Access.
Factory
2000 Sample Database Tables - Very simple
cost accounting student starter database used in many of our
Microsoft Access classes.
Hospital
Admissions Student Database Tables - Very simple
hospital admissions student starter database used in some of our
Microsoft Access classes.
How to
Create a Microsoft Access Relationship Design - See how
to create a relationship design or ERD for the Factory2000
sample database.
Implementing
Roles in a Microsoft Access Database - Shows how a
single doctors table can play two roles: admitting physician
and referring physician.
Microsoft
Access Forms - Article on designing forms with effects of data
source (query) choices.
Microsoft
Access Object Naming Conventions - Some conventions for naming
objects in an Access database.
Creating a Self Join in
Microsoft Access - Short article that shows how to
create a join of a table to itself as used for recursive
relationships.
Putting a Microsoft Access Database on the Web - Explains the overall architecture involved in deploying a Microsoft Access database on the web.
Setting
up Microsoft Access Security - Using the wizard to set up user
security in your Microsoft Access database.
Smart Access -
Articles written for the Smart Access magazine. Quite a few
interesting articles.
SQL Articles
Simple talk SQL articles by Joe Celko - Some interesting
articles by a well known SQL guru.
Database Design Articles
Converting an ERD to a
Database - Top down approach to converting an ERD
(Entity Relationship Diagram) to a physical database. The focus is on
Microsoft Access.
Database Normalization - Simple example that converts an un-normalized dataset into 3rd normal form.
Using the
Crows-foot Data Modeling convention in Visio
- Shows how to set the options in Visio.
Learn more about our courses..
|
