Introduction to Database Design in Microsoft Access

Database modeling is presented from a number of different perspectives which vary depending on what database software is being used and who is presenting the method for designing and creating the database. In this and subsequent posts, I'll attempt to outline a method for modeling and developing databases using Microsoft Access. As I do this, I'll also try to highlight similarities between methods for modeling databases and various other related models for design such as research design, systems design, and programming. 

Database Modeling and Design

Most database modeling and design methodologies consist of a series of five phases. As you can see in the graphic above, the methodology I use here consists of the following five phases:

1. Collect
2. Model
3. Identify
4. Normalize
5. Create

Additionally, the graphic also highlights five objectives associated with this methodology that include the creation of the conceptual design, the logical design, the physical design, testing the design, and collecting feedback after the database has been created. If you're interested in how to design databases in Microsoft Access, join me as I briefly discuss each of the five phases and their associated objectives in subsequent posts.