Microsoft Access 2019 Tutorial For Beginners (Covers Access 365 and Access 2016 too!)

No video

Microsoft Access 2019 Tutorial For Beginners (Covers Access 365 and Access 2016 too!)

Рет қаралды 87,949

Computer Learning Zone

Күн бұрын

Пікірлер: 77

@casgeneralmembershipmeetin3872 3 жыл бұрын

Thank you! Finally, someone that can explain things in plain english and speaks at a normal pace. I'm so relieved to have found you.

@599CD 3 жыл бұрын

Glad you liked it!

@rbuswell 3 жыл бұрын

One of the most pleasant tutorials I've ever watched. Excellent voice and pace and very easy to follow.

@599CD 3 жыл бұрын

Glad you enjoyed it!

@raymondspornhauer5397 4 жыл бұрын

I have purchased many of the Access courses from PC Learning Zone and would highly recommend them to anyone interested in learning Access. Some of the advantages I've observed from these courses include: 1. They are all taught by the same instructor. 2. The lessons are clearly laid out and reinforce good habits and techniques. 3. You are always building off the material you already learned, as opposed to jumping from concept to concept. 4. It's easy to go back and re-watch the courses as a refresher. 5. You can just watch the videos and learn so much before working in Access. 6. You can go at your own pace. This program is much better than any college course I have taken on any software. In my opinion... this is a better investment for learning. The only disadvantage I can really think of... is that my work will reimburse for "accredited" college courses, but not programs like this even though they are much better.

@599CD 4 жыл бұрын

Thanks, Raymond. I appreciate the kind words and the review. Yeah, I've thought about getting "accredited" but there's a LOT of red tape. I'd have to have a college degree myself but, alas, I'm a college dropout. I have a couple semesters under my belt, but I left school to start a business back in 1994, and I haven't looked back. I'm all self-taught from books and trial-n-error.

@captainkeyboard1007 3 жыл бұрын

This lesson about beginning to use Access 2019 encourages me to take more advantage of the program. I do have Microsoft Office 2019 Professional, including Access 2019. I have used Access 2016. I have been using Microsoft Access since 2002 when I bought my first computer that I call my keyboard. This tutorial enhances my desire to take more advantage of techniques with which I have discovered by myself, and new ones I never knew before.

@599CD 3 жыл бұрын

Glad to help

@captainkeyboard1007 3 жыл бұрын

@@599CD I thank you.

@johnpatrick4185 3 жыл бұрын

Access is still going!.... Used it 20 years ago! .. Nostalgia !! :-)

@599CD 3 жыл бұрын

Yeah, I've been using it since 1994. Damn. :)

@michaeldoyle9904 3 жыл бұрын

What an incredibly well presented tutorial, it really does simplify the process of creating tables, queries, forms and reports, with a no nonsense approach that combines clarity of speech and clear visual descriptions of the tasks involved, my only issue is that I have a database that was created in Access 2007 and I am now considering taking a subscription to Microsoft 365 and am unsure whether I will be able to open and use my old database or will I have to build a new one in 365, and if so is this tutorial relevent to the access database within Microsoft 365. Thank you for an excellent tutorial.

@599CD 3 жыл бұрын

Thank you very much for the compliments. You shouldn't have any problems upgrading from 2007 to 2019 (365). And yes, 99% of the material in my lessons hasn't changed. Aside from a few naming changes (Memo to Long Text, for example), Access is almost identical from 2007 to 2019.

@elibello5306 2 жыл бұрын

Thank you Richard. I'm a semi beginner, and you have been extremely helpful.

@599CD 2 жыл бұрын

Welcome

@AllThingsRomez 3 жыл бұрын

Best Beginner's Video... By far.

@599CD 3 жыл бұрын

Glad you think so!

@VineyardFX 3 жыл бұрын

This was a really terrific video presentation of getting started with Access. Thanks very much.

@599CD 3 жыл бұрын

Glad you enjoyed it!

@eunicekariuki9834 3 жыл бұрын

Thank you for the tutorial, you made it easier for me.

@599CD 3 жыл бұрын

You're welcome

@LavonYoung1 Жыл бұрын

Great tutorial. A little fast, but your personal preferences and setups were helpful.

@599CD Жыл бұрын

Glad you enjoyed it

@aceroyplatadeluna 3 жыл бұрын

Exactly what I was looking for... thanks very much!

@599CD 3 жыл бұрын

You are welcome!

@chrishilder7189 3 жыл бұрын

Thank you Richard, very useful run though and the pace was just right for me.

@599CD 3 жыл бұрын

Glad you liked it.

@geoffphil 3 жыл бұрын

Brilliant crash course. Thanks. A quick burst on relationships would be good but I suppose this is elsewhere in your videos.

@599CD 3 жыл бұрын

You mean like this: 599cd.com/Relationships

@taiwankyh 3 жыл бұрын

Good video, it let me have some basic concepts.

@599CD 3 жыл бұрын

Yep!

@GreenShoots Жыл бұрын

Very clear presentation - head and shoulders above the others I have viewed. Thank you! I want to build a simple customer relational database: customer, contact, and perhaps one other table. I will happily pay for the necessary courses, but there are so many options on your website that I am confused. I have the latest version of Access. Any guidance would be greatly appreciated!

@599CD Жыл бұрын

If that's what you're looking for, I would recommend my normal, regular, Access course. Start with Beginner 1, and then go to level 2, 3, 4, etc. I focus mostly on customers, contacts, and those kinds of things. 599cd.com/ACB1

@rudiratlos34 2 жыл бұрын

Hi Rick! This is really useful. Thanks! Quick question: Can Access forms be sent to customers or colleagues to fill out and automatically feed into the database? I am trying to figure out if MS Access is a good tool to manage and track collaborative project work by collecting inputs from different team members (where several team members need to carry out the same actions in different projects). Would very much appreciate your advice on that. Thanks!

@599CD 2 жыл бұрын

Not really. You can use something like Google Forms and have their responses saved into a Sheet, which you can then import into Access... but no... I wish Access had something like that. They used to have a feature in the past that kinda did something like that... but it didn't work right and they removed it.

@steamfitterx 4 жыл бұрын

good refresher

@599CD 3 жыл бұрын

Thanks

@chitrasabnis6033 Жыл бұрын

Can I combine a query and a report?

@599CD Жыл бұрын

No. A report is based off of a table or a query. You don't combine one type with another.

@abdularif951 3 жыл бұрын

I have old access 97 mdbs how can I open / convert then to version 365

@599CD 3 жыл бұрын

I'd suggest creating a new blank ACCDB file in 365 and then import all of your objects from the old database.

@kjvbible1611 4 жыл бұрын

We currently use an old program called Mymail. Is it possible to import fields/data into Access?

@kjvbible1611 4 жыл бұрын

I believe Mymail uses .mml type files.

@599CD 4 жыл бұрын

I've never used MyMail before. Sorry. You'll have to ask them if they have an export.

@kjvbible1611 4 жыл бұрын

@@599CD They seem to be long gone! We have at least 2000 entries in that database w/ an .mml file extension. When we try to import it into Excel 2013 some of the fields are incorrectly named.

@user-jq3kl3xb6y 3 жыл бұрын

I agree the Microsoft Access

@599CD 3 жыл бұрын

I'm glad you agree. :)

@tarekramadan8905 3 жыл бұрын

Hello, Can someone please help me in explaining how can I add a text box to display column history, I already can access it by right click and show a column of "Comments" history but I'm trying to make it show in another text box names "history". thank you in advance.

@599CD 3 жыл бұрын

I don't understand your question. Please explain.

@captainkeyboard1007 3 жыл бұрын

In order to add column history for every time you update a field, select Design View. Be sure the data type is "Long Text." Then move down to the Field Properties tab and to the bottom where it has Append Only, then change No to Yes. Be sure to save the table before you switch to datasheet view.

@thethinkstudio1200 3 жыл бұрын

Have you tried FileMaker? I’ve been developing in FileMaker for past 6 years. I’m thinking about learning access to sell more products for other potential clients.

@599CD 3 жыл бұрын

I haven't used FileMaker in... ever. I've been an Access guy since 1994.

@thethinkstudio1200 3 жыл бұрын

@@599CD that’s awesome. My parents had a friend Steve Esterling that made them 4 MS access databases in really 2000 , Steve passed away in 2005 and in 2014 my parents brought me into family business. I noticed system seemed old I did research and it looked like FileMaker has more technology for expansion! I’d like to get into access tho to get a different perspective and also more clients for my database i currently sell in FileMaker.

@captainkeyboard1007 3 жыл бұрын

FileMaker is an excellent program for Apple computer users. Microsoft Access is a flexible Windows database program that allows users to modify their databases as needed.

@aakashpatil6784 3 жыл бұрын

Sir you said there are four basic object can you tell me that basic object

@599CD 3 жыл бұрын

599cd.com/Parts

@pvb1905 4 жыл бұрын

Sir I have a question .. it may be my fault of designing my database ...but question is here .. in access I made product table with rate.... in real world there are need to change rates frequently in the same product ... but in access all data are live and if i change rate that effect to past data also.... what is the solution ? past data is record and we can not change it by any means. So please reply and oblige me.

@599CD 4 жыл бұрын

I do this ON PURPOSE in my Expert classes to teach people how NOT to build their databases. Then I show them the fix. It's much easier to understand once you've made the mistake. You don't want to pull that rate from the linked table. You're going to store it TWICE, once in each table. You'll need an event like AfterUpdate and DLOOKUP to pull the value from the table it's listed in and then store it in your second table. See kzfaq.info/get/bejne/hL6XotCIrZqmoX0.html This way if the rate (or product price, or whatever you're looking up) changes in the main table, all the child tables aren't effected. Yes, it's duplicated data, but in this case that's NECESSARY.

@pvb1905 4 жыл бұрын

@@599CD Thank you very much SIR ... I will deeply learn it and will try to do my solution .SALUTE to You SIR.

@pvb1905 4 жыл бұрын

@@599CD sir thank you but i cant do it. My question is frequently changing particular field or fields without effecting past data. means the effect will take place on new data . same product need changes multiple time its value(rate) .. so these is related to time effect data. access is changing live all data. so is there any command to update data that take place on next data.

@samyaksharma7032 3 жыл бұрын

Hello Sir, is there a way to download MS access or just get a trial version for free? Please help... Thanks a Lot

@599CD 3 жыл бұрын

Unfortunately, no. Unlike Word and Excel where there is a free version at Office.com, Access has no such version. You have to buy it.

@samyaksharma7032 3 жыл бұрын

@@599CD Thanks a Lot

@regismaltais8269 4 жыл бұрын

Could you make a full product at price, like I do not know 1000 $ for the full package, it would be much easy to sell to my boss, than buying bits and bytes here and there

@599CD 4 жыл бұрын

I do have several options available. If you buy multiple classes, the shopping cart will give you an automatic discount. Plus I have a membership program available. See 599cd.com/Connection

@RAMRAM-dn9lh 4 жыл бұрын

SIR THANKS , U R TUTOR

@599CD 3 жыл бұрын

You are most welcome

@byLokie 3 жыл бұрын

Very cool. Thank you. I have a Family Tree with 700+ people (in Excel) and I am wanting to querie Those who have the same Birthday. So I guess- in Acess- I will have to make a field that contains DayMonth (e.g 16Aug) and try to work out where to find those born 16th August in what ever year. Is that possible?

@599CD 3 жыл бұрын

Yep. Use the Month() and Day() functions. kzfaq.info/get/bejne/bNJxateCqa2weIU.html