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.
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.
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.
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.
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.
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!
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.
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!
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
@@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.
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 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.
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.
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.
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.
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.
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 th-cam.com/video/NXgomWH4BqI/w-d-xo.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.
@@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.
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?
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
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
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.
Glad you liked it!
One of the most pleasant tutorials I've ever watched. Excellent voice and pace and very easy to follow.
Glad you enjoyed it!
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.
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.
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.
Glad to help
@@599CD I thank you.
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.
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.
Access is still going!.... Used it 20 years ago! .. Nostalgia !! :-)
Yeah, I've been using it since 1994. Damn. :)
Best Beginner's Video... By far.
Glad you think so!
Thank you Richard. I'm a semi beginner, and you have been extremely helpful.
Welcome
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!
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.
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!
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
Great tutorial. A little fast, but your personal preferences and setups were helpful.
Glad you enjoyed it
This was a really terrific video presentation of getting started with Access. Thanks very much.
Glad you enjoyed it!
Thank you for the tutorial, you made it easier for me.
You're welcome
Thank you Richard, very useful run though and the pace was just right for me.
Glad you liked it.
We currently use an old program called Mymail. Is it possible to import fields/data into Access?
I believe Mymail uses .mml type files.
I've never used MyMail before. Sorry. You'll have to ask them if they have an export.
@@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.
Brilliant crash course. Thanks. A quick burst on relationships would be good but I suppose this is elsewhere in your videos.
You mean like this: 599cd.com/Relationships
Exactly what I was looking for... thanks very much!
You are welcome!
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.
I haven't used FileMaker in... ever. I've been an Access guy since 1994.
@@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.
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.
Good video, it let me have some basic concepts.
Yep!
Can I combine a query and a report?
No. A report is based off of a table or a query. You don't combine one type with another.
I have old access 97 mdbs how can I open / convert then to version 365
I'd suggest creating a new blank ACCDB file in 365 and then import all of your objects from the old database.
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.
I don't understand your question. Please explain.
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.
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.
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 th-cam.com/video/NXgomWH4BqI/w-d-xo.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.
@@599CD Thank you very much SIR ... I will deeply learn it and will try to do my solution .SALUTE to You SIR.
@@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.
good refresher
Thanks
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?
Yep. Use the Month() and Day() functions. th-cam.com/video/6lA7tQDGLHQ/w-d-xo.html
Sir you said there are four basic object can you tell me that basic object
599cd.com/Parts
Hello Sir, is there a way to download MS access or just get a trial version for free?
Please help...
Thanks a Lot
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.
@@599CD Thanks a Lot
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
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
Nice video ,cmi can see the link pls
Thank you, but I have no idea what you're asking.
I agree the Microsoft Access
I'm glad you agree. :)
SIR THANKS , U R TUTOR
You are most welcome
This be a good video
Thanks
came here for uni exercise
Cool.
Good Job, suggest- speak slower. See you soon.
Slow down the video. :)