From the course: Learning Relational Databases
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Create the tables in Access
From the course: Learning Relational Databases
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Move from planning to construction3m
-
(Locked)
Solution: Create the tables with CoderPad4m 19s
-
(Locked)
Solution: Establish relationships with CoderPad3m 16s
-
(Locked)
Solution: Write queries in CoderPad4m 6s
-
(Locked)
Create the tables in Access8m 24s
-
(Locked)
Establish relationships in Access4m 41s
-
(Locked)
Write queries in Access3m 59s
-
(Locked)
Create the tables in SQL Server9m 22s
-
(Locked)
Establish relationships in SQL Server5m 48s
-
(Locked)
Create views in SQL Server4m 43s
-
(Locked)
-