This video tutorial contains detailed instructions on how to setup the new Database, and Create the Tables, Fields, Primary Keys and Relationships required for the Passy's Bargain Barn Business Solution.
Even if you are not doing our full Access Learning Course, this video will show you how to define and populate Tables in MS Access.
The Tutorial Support Materials mentioned in the video can be found on our website at the link below:
[ Ссылка ]
Video Timeline Links - Click the blue timing number to go to that section.
0:00 Lesson Overview and Contents
0:52 Database Tables Design
2:20 Creating a New Blank Database
4:20 Creating the Fields for the Stock Items Table in Design View
7:15 Entering the Data for the Stock Items in Datasheet View
9:58 Sorting the Data in the Table in Datasheet View
10:21 Saving the finished Table
10:40 Creating the Sellers Table
11:27 Setting the Primary Key for a Table
12:07 Defining Phone Number Fields - Not as Number but as Text
13:19 Entering Data into the Seller's Table
13:33 Fixing a Database Design Problem in our Tables
15:35 Deleting Fields from a Table in Design View
19:38 Checking the Primary Keys in the Tables
20:26 Setting up the Database Relationships
23:42 Database Settings - Overlapping Windows and Tabbed Documents
25:04 Saving the Database
26:33 Tables Practice Assignment - Creating the Buyers Table
27:04 Lesson Wrap Up
Subscribe and check out the rest of our YouTube channel for more great tutorials.
Enjoy, Passy
![](https://i.ytimg.com/vi/nGYTT_uilG0/maxresdefault.jpg)