WEBVTT Kind: captions Language: en 00:00:06.509 --> 00:00:11.710 Now that we know what a database is and how it's used in everyday life, it's time to think 00:00:11.710 --> 00:00:13.780 about creating our own. 00:00:13.780 --> 00:00:16.200 Let's pretend that we work for a bookstore. 00:00:16.200 --> 00:00:20.740 The Ready to Read bookstore! 00:00:20.740 --> 00:00:25.430 We have customers and we sell books in the store and online. 00:00:25.430 --> 00:00:30.490 The store needs a way to keep track of customers, books, and orders. 00:00:30.490 --> 00:00:35.340 We'd also like to be able to send books to customers who order online, and perhaps send 00:00:35.340 --> 00:00:41.449 out some coupons, track our sales, and determine what books are popular so we can establish 00:00:41.449 --> 00:00:44.120 a best sellers list at the store. 00:00:44.120 --> 00:00:48.300 We can do all of this by creating a database. 00:00:48.300 --> 00:00:53.129 The first thing to think about when creating a database is the purpose for the database 00:00:53.129 --> 00:00:59.929 which in this case is to keep track of customers, orders, and books. 00:00:59.929 --> 00:01:03.239 The next step is to do a little brainstorming. 00:01:03.239 --> 00:01:05.940 Think about what you need to create a database. 00:01:05.940 --> 00:01:14.160 I'm a visual person so I like to take out a sheet of paper and write all of this down. 00:01:14.160 --> 00:01:20.230 What do I want to know about my customers, their orders, and the books in my inventory? 00:01:20.230 --> 00:01:22.170 Let's start with customers. 00:01:22.170 --> 00:01:28.260 Since I plan to mail coupons and books out I want to know my customer's name. 00:01:28.260 --> 00:01:30.520 Their address is important too. 00:01:30.520 --> 00:01:35.390 Later on this information may help me determine which states order most of my books and in 00:01:35.390 --> 00:01:38.610 turn I'll want to thank them by mailing out coupons! 00:01:38.610 --> 00:01:45.710 Oh, and just in case I need to contact them it would be nice to have an email address. 00:01:45.710 --> 00:01:47.880 What about our books? 00:01:47.880 --> 00:01:50.320 What information do we need to know about our books? 00:01:50.320 --> 00:01:55.120 Well we know that each book has a Title, author, and price. 00:01:55.120 --> 00:02:00.320 Books also fit into different categories such as fiction, romance, and computers. 00:02:00.320 --> 00:02:05.690 Knowing the category will help us pin-point which types of books sell the best and we 00:02:05.690 --> 00:02:09.369 can keep that type of book in stock at all times. 00:02:09.369 --> 00:02:12.040 What's left? 00:02:12.040 --> 00:02:14.719 Ahh...their orders. 00:02:14.719 --> 00:02:18.530 This is the stage where the customer actually buys the book. 00:02:18.530 --> 00:02:26.540 I want the orders part of my database to tell me who ordered what and when. 00:02:26.540 --> 00:02:31.189 Now I want to show you how these three things are related. 00:02:31.189 --> 00:02:36.450 A customer finds a book and places an order or makes a purchase. 00:02:36.450 --> 00:02:44.629 Our database will tell us who they are, what they bought and when they bought it. 00:02:44.629 --> 00:02:49.150 We know what we want now let's figure out what all of this has to do with a database. 00:02:49.150 --> 00:02:57.239 You see, each of these three things represents a table in the database. 00:02:57.239 --> 00:03:02.829 A table is one logical unit of information, broken up in rows and columns just like a 00:03:02.829 --> 00:03:06.689 table you may have seen in Excel or even Word. 00:03:06.689 --> 00:03:12.790 The specific information in each table will be the fields you set up. 00:03:12.790 --> 00:03:16.340 Fields are the smaller chunks of info in each table. 00:03:16.340 --> 00:03:19.760 So we have our tables. 00:03:19.760 --> 00:03:24.720 We said that the customer table will include the name, address, and email. 00:03:24.720 --> 00:03:29.010 In a database it's easier to break down a few of these fields. 00:03:29.010 --> 00:03:39.219 So we'll say first name, last name; and for the address we'll put street, city, state, 00:03:39.219 --> 00:03:41.069 and zip. 00:03:41.069 --> 00:03:44.530 Email will remain the same. 00:03:44.530 --> 00:03:50.870 For my orders table everything will remain the same for now with customer, book, and 00:03:50.870 --> 00:03:52.370 date. 00:03:52.370 --> 00:03:56.779 My books table includes title, author, price, and category. 00:03:56.779 --> 00:04:01.049 Title will remain the same but I'll break author into two. 00:04:01.049 --> 00:04:12.409 I'll have author first name, author last name, and leave price and category the same. 00:04:12.409 --> 00:04:15.849 Don't worry about the details of tables and fields right now. 00:04:15.849 --> 00:04:19.019 We'll go over that in our next lesson. 00:04:19.019 --> 00:04:23.170 Now that we've planned everything let's start creating our database in Access!