Access Beginner Tutorial

preview_player
Показать описание
Access Beginner Tutorial

Get Ad-Free Training by becoming a member today!

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:

For Private Group Trainings please visit:

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.
Рекомендации по теме
Комментарии
Автор

Hands down, this is the best Microsoft Access 2016 Turorial course i have ever come across. Talk about an expert/professional!!! Amazed! It makes so much sense to start with exploring a database rather than starting to create a database without knowing exactly how cool a database is. This first part is making me so excited and looking forward for the upcoming in lesson i see in this playlist.

aniwenemedia
Автор

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

jamesgrant
Автор

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!

LearnwithCSDTech
Автор

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.

shahinulkhan
Автор

I have taken a dozen or so courses in database management, Filemaker Pro and Access. This instructor is really, really good, I love how he gets right into hands on stuff and keeps your interest. Other courses start with very mundane technocrap. I am definitely going to look into paying for additional courses. Well played Mr. McAllister, well played.

RobertBrunnerBREG
Автор

Dear Dan, I learned Access many years ago, 1995, but have not used it since. Now I wanted to design a database for my work and came to look for a refreshment and what a surprise!. You are a great teacher know exactly how to present a subject and how to lead your student especially on such a remote learning. I enjoyed every moment. Thank you so much. So many thinks we can learn from the way you teach. Well done.

mepshtain
Автор

EXCELLENT teaching techniques! My job for many years was to observe and evaluate the instructional skills and techniques of middle and high school science and math teachers. Later I served as an Instructional Technology Director, during which some of my duties were to design and conduct classes for K-12 teachers on MS Windows, Word, Excel and PowerPoint. I designed a database that tracked the classes and performances of all teachers that attended our classes. I toyed with the idea of teaching MS Access, but never felt that my knowledge was as complete as it should have been to do as good a job as I would have wanted to do. Watching your "Beginner Tutorial" confirms that I have gaps in my knowledge! :-) I guess I never really took the time to fully explore all of the nooks and crannies of MS Access.

Aside from having a firm understanding the content for which you are teaching (which sadly was not always the case for some teachers with whom I worked), you employ essential techniques, such as making few assumptions of the viewers' knowledge. For example, you include expected behaviors of Windows, and not just Access. Other extremely important techniques that you employ are: You FREQUENTLY loop back to review and hopefully reinforce what has been taught; You provide "wait time" so that viewers to follow the pace of your instruction; You raise the possibility of problems occurring, and patiently illustrate how to either avoid or address them; You check for understanding by giving viewers chances to implement procedures that you taught by letting them try out their understanding before you proceed. You use appropriate and reasonable amounts of humor at appropriate times to relieve mental tension. Consequently, your pace is not hurried, which is essential when teaching somewhat difficult content such as this.

Ok, I can "see" and "hear" some techies moaning and rolling their eyes at my comments, and at your instructional methods. I strongly suspect that they have never tried to EFFECTIVELY teach folks for whom technology is not as easy to learn as it is for them. I've attended MANY classes conducted by techies whose apparent goal was to impress their students of how much they knew, rather than effectively teach. And BOY does that turn off many learners!!!


And WOW...the time you and your organization take to make videos with this much detail and length at no cost to viewers. Very rare, and very much appreciated!

Dan, based on your instructional performance in this video, I would have given you my highest marks in my evaluation. I wish I could see you teach in person, it would be a pleasure!

redsanders
Автор

A silky voice, excellent sense of humour and superb quality course. Dan McAllistar, thank you! I really enjoyed following along.

ethansodaro
Автор

I'd bet that between the words 'put your video on pause' and 'welcome back, ' a lecturer sneaks in a couple of sips of good whisky) Very good sense of humor.

shopsurvival
Автор

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.

MaineBassGuy
Автор

⭐⭐⭐⭐⭐ 5 STARS is what I give you for the incredibly didactic trainning !!!! I'M FROM BRASIL, RIO DE JANEIRO and I prefer study by American Professors and teachers... Your training is good because of the 3 points I consider crucial: 1)Your language is clear and to the point 2)Your exemples are exactly what we find in the files (no unpleasant surprises as some other not so didactic teachers from Learnit made me go through while following their classes, rendering me a lot of headaches!!!) 3)You are a very detail-oriented person, which made me like you even more!!!!
....
I wish all the success, health and joy to you!!! You are one in a million... !!!! 🙏🙏🙏

CrisStuart
Автор

DEAR SIR
I THINK THIS ONE IS THE BEST TUTORIALS FOR ACCESS I HAD SEARCHED IN INTERNET.YOU ARE MIND BLOWINGLY GOOD.YOUR CONTENT IS SO EASY TO LEARN FROM BEGINING TO ADVANCE.I LOVE UR TEACHING .I HAVE GONE THROUGH MANY VEDIO ON INTERNET FOR MONTHS.YOU ARE THE BEST.THIS IS NOT GOLD, DIAMOND OR PLATIUM.THI IS LIKE DEVINE I CANT EXPLAIN.
THANK U VERY MUCH SIR.

PAVITHRAP-cjdy
Автор

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!

nfirliy
Автор

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.

koteshwarpanuganti
Автор

Terrific. I'm a former database programmer and it's been years. Going to design a dbase for my work in Access and needed to run through how things work here. Did some fast forwarding but you are a great teacher... You know the material but you know how to teach as well! : )

jeffdeutsch
Автор

Enjoyed the course. Only recommendation would be to correct whatever happened at 2:33:33.

justdifficult
Автор

You're the best instructor ever, and explain everything in detail, thank you very much

mehdi.sajadi
Автор

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

andorelamarra
Автор

I am an an experienced access user, but I found many small things I did not know. Thank you for the tutorial.

kazerog
Автор

Best style of teaching I’ve come across. By far the best, love it.

grahamlamming