Index to Articles

Downloads

Tutorials

Quizzes

Course Listing

Free Catalog

Request Information

What's New

View related PowerPoint slides on Slideshare

Glossary of Database Terms

Microsoft Access | SQL | Database Design | About

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.


Receive course announcements and news. Sign Up Today!





Email Marketing by VerticalResponse

Learn more about our courses..

View online course catalog.

 


Please send comments and suggestions to WebMaster at dhdurso.org

Copyright 2018 D.H.D'Urso & Associates
Laguna Niguel, Orange County, California

Index | Close Window | Back | Top