Learn what database design elements to consider, as well as how to create an Access database, in this free lesson.
The first step in creating a database is to think about why you need it—what is its purpose? Once you know the answer, you can begin designing your own database. Ask yourself questions like What kinds of information will it store? How will I have to break down this information 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.