ImmersiveAmbientModecolor: #040404 (color 2)
Video Format : 22 (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: Opus - Normalized audio
PokeTubeEncryptID: 5675b1666ad990dd8bb6700894b773f7b818fb07070979aa0f4ecb2c3c73eca97e9c05c226a72daa9a2aae594b71ee36
Proxy : eu-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1715916862191 - unknown on Apple WebKit
Mystery text : MVhUWHYxVjMtYWcgaSAgbG92ICB1IGV1LXByb3h5LnBva2V0dWJlLmZ1bg==
143 : true
1,208,614 Views ⢠Premiered Jan 31, 2020 ⢠Click to toggle off description
Get Ad-Free Training by becoming a member today!
youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise Files: www.learnitanytime.com/p/exercise-files-access-begâŚ
Who it's For: Access is designed for people who are comfortable with spreadsheet programs like Excel. These users need more power and analyzation, as well as a stronger forward-facing interface.
What it is: Access is a database creation and management program. It helps you design, build, and interface with a robust database to help your organization run smoothly. Many small to medium-sized businesses use Access for this exact purpose.
What You'll Learn: This course starts with database basics, terms, and information youâll need to confidently build your database later on. Then, youâll learn how to build tables, determine relationships, query data, and create simple-to-use interfaces that other people at your company can use to interact with your data.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com/
For Private Group Trainings please visit:
www.learnit.com/private-group-classes-workshops
Manuals: 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.
Views : 1,208,614
Genre: Education
Date of upload: Premiered Jan 31, 2020 ^^
Rating : 4.879 (264/8,488 LTDR)
RYD date created : 2022-04-08T10:13:57.02254Z
See in json
YouTube Comments - 520 Comments
Top Comments of this video!! :3
Dear Sir
I would just like to say that whilst browsing the internet looking for information on how to create a personal database using Access 2019, I stumbled onto your video âAccess Beginner Tutorialâ.
I learnt more in half an hour of watching the video that I had in days.
Dan McAllister is such a good teacher. Takes you through each section and gives you time to try every little thing. He has such a wonderful calming voice, unlike presenters of other videoâs. He does you credit.
Iâll be sticking with your video and hoping that the information sinks into this 68 year old brain sufficiently for me to produce the database I need.
Thank you
75 |
This tutorial is extremely professional and should be the go-to guide for anyone looking to learn. It's fantastic and truly top-notch. I was very impressed and it left me wanting to learn even more. Keep up the great work!
1 |
Excellent teacher. Thank you!
7 |
So impressive. Wish I could like a video twice.
4 |
Oh man, it has been at least 15 years since I've done the Northwind thing. Amazing how much you can forget!
5 |
I like that the humor, anecdotes, and personality come forward slowly throughout the video. Like, I've lured you in with my professional acumen but keeping you here for Steven Wright and Billy Crystal references.
20 |
Thank you very much , Good work - you are an excellent professional.
4 |
you are such an amazing teacher.i love to have private classes whenever possible,,,100 percent undertood.
7 |
this is great tutorial! need help, why is copy so problematic ? Most the time it fail to copy field value. any help is greatly appreciated
12 |
A silky voice, excellent sense of humour and superb quality course. Dan McAllistar, thank you! I really enjoyed following along.
5 |
Thank you so much.
I have now watched this 3 times. Made a complex database (at least by my standard). Made tons of mistakes. Came back here to get the basics right. You covered it all. But for a newbie making mistakes was important learning.
What an amazing course.
Onwards and upwards.
18 |
This is brilliant. I have done a lot off access but not for ages and had forgotten some of the steps. Of course as soon as I see you do the step I am thinking how did I forget that. What I really like is how you don't miss out any detail especially the simple details that some trainers skip right over forgetting that not everybody already knows the actions to take. Doe example the different ways to open, close and not change a record.
2 |
Enjoyed the course. Only recommendation would be to correct whatever happened at 2:33:33.
8 |
I have gone through whole Beginner Access video. I really appreciate and happy for the video and Learnit team for doing this great job. It was long pending dream of learning Microsoft Access. Atlast, i found the perfect video to learn. Thanks a lot.
7 |
The best explanation! Itâs very easy to understand with this wonderful sense of humor! Great đ job! Thanks đ!
4 |
Took one look at the display pic for this guy and I knew this was the guy I needed to teach me this stuff
2 |
Your good work is visible, even to the one who doesnât want to see. Job well done and May you be rewarded handsomely!
5 |
I was so scared when I first got to do with access but with your video I started to understand better the things in it. Thank you
1 |
Success in life comes from great teachers
3 |
@LearnwithCSDTech
1 year ago
This is the best course for MS Access that I found on YouTube. I appreciate you for creating that much valuable content freely available to all. Thank you very much!
26 |