Access Beginner Tutorial For certificates, exams, and badges, join our Patreon community: https://www.patreon.com/learnittraining Join our online community! - https://www.offsitebylearnit.com Exercise Files: https://bit.ly/3jcpg3o Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Part 1 Start: 0:00 Opening a Sample Database 0:03 The Database Objects 8:57 The Interface 14:51 Introducing Tables 20:12 Simple Data Entry 27:48 Introducing Queries 31:01 Practicing Data Entry in Queries 40:01 Introducing Forms 41:06 Data Entry Into Forms 46:49 Introducing Reports 47:35 Sorting to Create Groups 53:33 Finding Data in Tables 1:04:28 Filtering 1:10:30 Adding Total Rows 1:20:15 Starting a New Database 1:24:14 Creating Tables in Design View 1:33:02 Entering Your First Record 1:47:22 Using Quick Starts to Create Tables 1:51:12 Entering Data Into Your Second Table 2:10:25 Summary 2:19:34 Part 2 Introduction 2:22:28 Looking at the First Draft of a Database 2:23:29 Creating Relationships with Lookup Lists 2:29:41 The Relationships Window 2:33:33 Relating by Dragging Field Names 2:36:52 Dragging to Create 1-to-1 Relationships 2:57:30 Changing Dragged Relationships to Lookup Relationships 3:00:30 Limit-To-List Properties 3:09:43 Enforced Referential Integrity 3:15:12 Seeing the Referential Integrity Being Enforced 3:22:41 Cascade Edits and Deletions 3:26:52 More Field Properties 3:33:55 #Access