Access Expert Tutorial

Access Expert 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

Start 0:00
Introduction 0:03
Turning Your Database Folder Into a Trusted Location 1:25
Filtering by Form 17:51
Columnar Form Views - Part 1 30:30
Columnar Form Views - Part 2 39:52
Tabular Forms 44:59
Split Forms 57:30
Justified Forms - Part 1 1:06:19
Justified Forms - Part 2 1:15:07
Form Sections 1:19:20
Adding Graphic Elements 1:37:42
Hand-Built Forms 1:46:37
Creating Forms from the Query 2:05:03
Building Forms from the Query 2:26:30
Tracing Dependencies from Form to Query to Table 2:39:55
Multi-Page Tabbed Forms 2:49:25
Parent and Child Forms - Method 1 3:08:47
Parent and Child Forms - Method 2 3:28:53
Parent and Child Forms - Method 3 3:33:07
Form Wizard's Datasheet Layout 3:38:44
Wrapping Up 3:44:26
Introduction 3:45:26
Viewing Reports - Part 1 3:46:39
Viewing Reports - Part 2 3:58:12
Views Available for Reports 4:02:56
Modifying Your First Report 4:13:48
The Form Wizard 4:35:27
Sorting in Your Report 4:51:17
Grouping in Your Report - Part 1 5:03:22
Grouping in Your Report - Part 2 5:20:38
Creating Summary Reports via the Wizard 5:22:03
Modifying Summary Reports 5:38:06
Special Case of CAN GROW 6:00:41
Adding a ROLODEX Effect 6:06:48
Mailing Labels 6:18:32

#Access

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[letmeexcel]

Can't believe that you guys are offering this free of cost. Thank you!

[shockhopful]

Really awesome training!! Quick note for other viewers. The trainings are a bit out of order. What's written:

Parent and Child Forms - Method 1 3:08:47
Parent and Child Forms - Method 2 3:28:53
Parent and Child Forms - Method 3 3:33:07
Form Wizard's Datasheet Layout 3:38:44

Actual:

Parent and Child Forms - Method 1 3:08:47
Parent and Child Forms - Method 3 3:28:53
Form Wizard's Datasheet Layout 3:33:07

Parent and Child Forms - Method 2 3:38:44

[cairovian]

Just Finished the Beginner, Advanced and Expert models and I can definitely say this is the best Access training I have seen anywhere. Thank you and well done!

[origbeecee]

I've used several learning channels and will say without hesitation that because this channel has some editing snafus and aren't honed to perfection it is one of my absolute favorites because it's obvious knowledgeable and caring people made the effort to make these videos relatable to us human users. Thank you!

[surangavithanage]

Yes it is very much of helpful to me. You are a real instructor who wants to give your knowledge with out hiding any. I really respect you.

[iAuslaender]

As a non native-english speaking person I am able to understand you even with 1.5x speed. And I like your humor 😂. Thanks for uploading the Access-Videos 💪🏽👍🏽

Greetings from Germany

[westcoast]

Dan is the best teacher I ever encountered.

[shashisinha]

Thanks Dan for this wonderful tutorial. I had learnt Access 20 years ago but after that never used it. After 20 years I just followed your tutorial and it is so exiting to know that I am now confident of putting this into real projects. Thanks for all your efforts in putting this into such a simple manner.

[hjopjic]

As a fellow baby boomer, your sense of humour was not lost on myself - especially the Cheech and Chong bit - also I live in London ON just a bit farther than Windsor - thanks for your wonderful teaching voice and sense of timing! Tutorials were easy to follow! cb

[AndrewSmith-vvvh]

Thank you once again Dan. I thoroughly enjoyed working through this tutorial with you. Even though the 6hrs 33mins took me two weeks to work through! For me, I've learnt so much and would like to congratulate and thank you for your time, your knowledge and your patience in putting together these tutorials for us mere mortals. Now on to the next. . . . . .

[saqibiqbal]

Today I have finished tutorial 3 of 4. "Learnt a lot" from "Learnit".

[peepoo]

Damn dan (Fernando) you did not have to remind me of alan rickman's death, i was learning access now i am crying.

Incredible job, incredible tutorials by an incredible guy

[vramanap]

Very well explained with detailed instructions and made things easy as we are skilled enough to be competent. Thanks for your time and patience!!

[trentcvendiola]

Absolutely the best Access instructions I've listened to and I've listened to a LOT! Clear, concise and really helps reinforce the info and make it usable! I've been struggling with Access for months and I finally am seeing the light at the end of the tunnel. I'm still in the tunnel but Dan is guiding me out to the light! I'm mostly having trouble getting the data populated into a plant database and having it link into all the tables with the Binomial Name and Common Names.

[jloo]

Best Access Class Ever
Thank you . I watch your channel every day.

[thespiritualcentre]

Excellent quality tutorials, informative and structured so that learning is progressive. Thank You Dan, I have enjoyed the course to date and am looking forward to completing the course once I have gained some experience. Practice, Practice, Practice. Bless You

[umbertofreitas]

Great tutorial, thanks a lot! Wondering here if there's gonna be an Access VBA tutorial as extensive and precise like this one here. Count me in!

[marceljunioregondi]

Then the other to know what view you are on is from the status bar at the bottom. Either on the left side or right. Right gives the icon and left actually spells it out.
Captain McAllister thank you for the lessons, started as a novice but after the first to tutorial collections beginner and advanced am sure I can do my own database. Going through expert collection. Hope it has aspects of form design to allow for end-user data entry without having to get into the design room.

[Esclarecidos]

No need to fill the caption field on 01:18:50. Just delete the text and the form name will show on tab.

[tmellberg]

I'm a big fan of your teaching style. Very considerate. Thank you.