Access 2007

Introduction

The first step in creating a database is to think about why you need it—what is its purpose? Once you know that, you can begin designing your own database. Ask yourself questions like: What kinds of information will it store? How will I have to break that information down so it can be stored in my database? How will I use the data once it's in there?

In this lesson, we'll walk you through the steps of database design using a bookstore scenario. You will determine the purpose of the database and plan the tables and fields you will need for a simple bookstore database.