From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create the tables in Access

Create the tables in Access

From the course: Learning Relational Databases

Start my 1-month free trial

Create the tables in Access

- With all of our pre-planning work done, we're ready to get started implementing our database's design, here inside of Microsoft Access. To get started I'm going to create a new blank desktop database. I'll just click on the Blank database icon. Then I'll bring up a window where I can browse out, using the folder icon, to choose where I want to save my database. I'll just go ahead and place mine here on the desktop. Then we're going to give the database a filename. I'll call my TwoTrees. And press the Create button to start up the new database. That gets us started here with a new table called Table1. I'm going to switch into design view, in order to start putting in my fields. We can switch our view either from the Fields tab, over on the far left; we'll see this View button, just click on this icon here; or you can find that same icon over on the Home tab and in the same position on the far left. Let's go ahead and click on the upper portion with the View button and then I'll…

Contents