Access Beginner Tutorial
Exercise Files: https://www.learnitanytime.com/p/exercise-files-access-beginner-tutorial
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops
Join our online community! – https://www.offsitebylearnit.com
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
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
source