Microsoft Access A to Z: An overview of what Access can do

This short screencast is the first in a series of a comprehensive overview of the power and benefits of managing data using Microsoft Access.
It introduces you to the key objects of an Access database: tables, queries, forms, and reports, and how they are related together. Furthermore, it shows how Access maintains data integrity and allows multiple people to simultaneously view, enter, and edit the data.
It also introduces you to two textbooks that comprehensively cover the steps needed to create a relational database as well as manage that database using Microsoft Access.
Thanks, Lisa Friedrichsen

[make_the_world_better_place]

This is very comprehensive and helpful. Straightforward and get to the point!! Well done.

[Cracktune]

this was the best intro to Access Ive ever seen. Thank you. My company is doing so dumb shit over and over and after watching this its now very clear that Access is going to be the solution. buying the book. liked;subbed

[zimkhithapeter]

Wow Lisa, u just sold MS Access to me, that was amazing, definitely subscribing, I just checked if u r on Udemy, was goin to enroll straight away via the company's business account. Will definitely look for those books

[yz]

This is the best intro of Access to me!

[chocolatewolf]

You sound like Holly Hunter :)
Thank you for the video, amazing introduction to access!

[rodneylawley]

Excellent introduction and review. Thank you.

[estelao.b.]

Thank you so much for this video. I have been lookt for an overview like this!! 😊😊

[franglinfani]

Loved the content, Accurate and to the point👍

[sydneymav]

Thank you for the motivation at the end

[geraldteigrob]

Now, to find a copy of the Illustrated Microsoft Access 2019 Comprehensive book as the last one I could've ordered is gone. I don't use Amazon, so I will just use the Illustrated Microsoft Access Introductory book and see what I can pick up from the videos. Very informative and thorough, yet easy to understand.

[NeuroPulse]

Thanks Lisa. This kicks ass. Sorry for the not classroom-like language.

[TheHoshmanddeeba]

thanks for your time and efforts, , ✔✔✔

[Holylicious]

Wow, that was a nice overview.. Just wondering if I somehow can restrict some of the fields from being changed?

[MattNicosia]

Hi Lisa I really enjoyed this. Do you know if it is possible to create a macro that would send data from excel to an access form?

[tylermunson]

your voice sounds like clarice from silence of the lambs. cool

[zachbiderman]

Lisa, if I understand this right… if I have multiple tables and forms… and I want to change a hyperlink on our web page that is mapped there from the database, should I change the hyperlink in the table itself or in forms? Do you have other videos that help describe this process? Thank you!

[kaaa]

Thank you so much for the video. I have a question. I use my access database daily, but today when I close my form that has subforms, I get the message "No current record". I don't know what has happened, it was not doing till yesterday.

The first form has 2 subform. I used to get two of the message "No Current Record". when I deleted the first subform, I only got one message but when I deleted the second one, I did not get none.
I have been working with database for 15 years, I never got this message until yesterday. one more thing, I also get it when I hit add new record. did microsoft access change the coding? Will you please, help solve this problem? Thanks in advance

[lancemarchetti]

I like the stereo panning effect in the audio...lol

[stopthink]

Great video! I have more questions. What makes this better than Excel? I can do all of these things with Excel using Power query and building a data model. How is Access intended to be used by stakeholders? Is there a stand alone app or web interface for the forms for data entry that they use? Can you automate reports by email? How does Access compare to MS SQL Server? How well does Access play with BI products like PowerBI, Tableau, etc?

[VoodooDg]

If your selling point for this is that multiple ppl can work with the same file, we have this since years in ms teams and even longer in google sheets....?