Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Access 2010's Table Design View is the most powerful place to create your tables. Click on the Create button and then on Table Design. This Design View has the most detail for table construction. In addition to all the features on the Table Tools Field's Ribbons, it has many more customizable field properties. So we'll build a table from scratch here. And in the next lesson, we'll look at the tables we built to add in our field properties, down here. So our next table is our Products table. Two Trees Olive Oil sells olive oil, both to retail stores and wholesale to restaurants.
The fields we'll need to create are the item SKU, the name, the size, our cost, the retail price and our profit margin. So this view is a list view. I think of it like building your house. Here's where we lay the foundation, build the structure and hang the drywall. So the first thing we need is our ID field. Because this is a Product, let's type in SKU. The SKU will be a combination of type of oil and the bottle size. So it will be text. We can enter that in the Description field, too. Now this Description is optional.
It doesn't show up anywhere but here. But if you'll be working with others on the database, or handing it off to someone else in the future, the more information you can give them, the better. Hit the Tab key to go to the next row. Type in "Product." It will be Text. So tab across. Next is Size, and Size is going to be a Number. Because we may want to calculate total volume, type Ounces in the Description line. Next is Price, and we'll change the Data Type to Currency, then Cost, also Currency, and then our Profit margin.
Now notice that I don't have to pulldown the dropdown menu. I can start typing the Data Type, and it will autofill automatically. And all I have to do is press Tab to accept it. If you want to change the order of the fields, for instance, you decide that you'd like Cost to be before Price, click on the gray box to the left of the Field and then drag it up or down. We'll drag it up above Price and let go. Last, let's save the table. Click on the Save button, and we'll call the table "Products" and click OK.
Now you'll get an error message asking you to set a primary key. Now we're going to do that in our next lesson, but if this was your real database, this would be a good time to do it. So for us, we're going to say No. So now you've used Design View to create a table quickly. Later, we'll use it to set our Field Properties, allowing us to control the data that's entered in.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.