These videos are better than any class I have attended for learning things for work. I am sitting at my job learning how to do all of this for FREE (with supervisor's approval, of course because it is going to educate me to be able to work in our database more). I really appreciate this! Thanks so much for posting all of this great information.
I have been off work for 1 year and a temp service called me today for a job on Monday but i have to know access. This hopefully saved my life. I will keep you updated. I am over 62 now and out of money.
Thanks for these tutorials Richard. A young lady called me asking if I can help her with learning about Access for her exam next Friday. I had not used it for so long but came across your videos. Now I'm able to help her :). Great tutorials and very easy to follow. Thanks again.
Had to learn Access QUICKLY for a skills assessment and stumbled upon your tutorials....Let me just say a job very well done by you!! Really, I have watched about 40 tutorials and yours fit my needs to a T...Excellent job-- easy to follow but not so slow that I had a nap :) Perfectly paced for me and will be telling my friends and my kids about your tutorials..THANK YOU!!
Those duplicate people -if my OCD is demanding that the numbers don't disappear forever, as when deleting an entire row, I can just delete the information in them and enter new info, right? And I'm enjoying your tutorials. You are a very good teacher; you explain every little thing and don't assume that people know what you're talking about.
rcx8666c so what if an instructor has an accent. They're sharing knowledge with you for free. Stop trying to invalidate someone because they're different than you.
I agree with both of you. There are lots of people on TH-cam sharing their knowledge for free, and they should not be disrespected. HOWEVER, I've tried to sit through videos, and even in-person lectures, where I couldn't understand the instructor due to a thick accent, and it makes the learning experience a lot more difficult. Sorry to say, but I'm a little biased in that department myself.
Fantastic! Thank you so much for this tutorial. Even now in 2016 It is coming in handy. I am about to start a course in business administration and I need Microsoft office 2010. I have it all set up on my laptop and I realised i Don't know how to use it. Your videos are helping me a lot. Keep them up forever !
In this case you would either put 2 phone number fields in your customer table OR if you want to be able to store an unlimited number of phone numbers, you would create a second, related table. I teach how to do this in my Access Expert series (relationships between tables).
That's how Autonumbers work. As soon as you start entering the first bit if data into a new record, that Autonumber is committed. If you cancel editing (ESC) or finish and delete the record (row) then that Autonumber is GONE forever. Remember... YOU shouldn't worry about those numbers. They're not for YOU. They're for Access to create relationships later.
These videos are so helpful! I am learning how to run space analysis at work and we have too much data to use excel. I have never used Access and these videos are helping me so much! Thank you for all that you do!
Your a genious and very greatfull guy. Thank you very much for all the info you have shared with us. Let me inform you that I've been waiting and looking for this course. Thousand of thanks.
Hats off to you,Sir..Thanks,Indeed..For enlightening me about MS access.You have uploaded such an amazing videos.This is really a great great work...May God give you more knowledge!!!!!
Autonumbers can ONLY be numbers. You could make your own CUSTOM field to do this, however. You could say something like this in a query: MyCounter: "MF" & ID
YOU should never worry about what the IDs are. They're only used internally for Access to form relationships with other tables. If you want your own counter value that you can make sure has no gaps, then you have to create your own, and it will involve a little programming. See this page on my web site: 599cd(DOT)com/X29049
Excellent tutorial. If I am using a field such as employee seniority and this changes as new people are hired or leave can this filed still be the AutoNumber data type?
Thank you sir .... its a bloody useful tutorials for access. I'm Bassam from Baghdad,Iraq and I'm The HR Executive for Investment Company in Iraq. And now I'm Planing to use Access for My Work database Thanks again And Allah bless you
Dude, beginners don't always grasp new concepts as quickly as you obviously do. These lessons were made for NOVICE users who have little or no experience with Access. Go get yourself an advanced tutorial or a book if these are too slow for you. Sorry, but I can't please everyone. You'll find that my advanced tutorials go at a much quicker pace... but these are made for BEGINNERS.
I am unsure what I am doing wrong here, but when I try to copy and paste the info into my table it comes up with an error message. I highlighted the whole row and still it does not work.
Just spent half an hour trying to figure out this same error. Was certain all my data types were correct but kept getting "value added isn't valid..." message. Eventually I started copying and pasting single fields and found the error was down to my currency units not being in USD$. Maybe the previous poster was having the same issue? I was able to work around and carry on but thought I would post this in case it helps someone else.
I had the same problem with pasting - it's because my default currency is British pounds rather than the dollars you've used. An annotation in the video would be helpful, or you could just remove the dollar signs from the provided text :)
Hi, there is an error appear when I copy and paste, the error is " the value entered isn't valid for this field, please explain why this error, i done all the work exactly like you.
how come when I delete a row and create a new row the customerID still increments? I deleted row two and wanted to remake it and it came out as customerID 3. How do i fix this >.
What if i have 2 same primary key but the other fields is different. For example, having the same customerID but he have 2 telephone numbers . Do i create 2 records ?
These tutorials are great and has helped me immensely! However I have a problem and need your input. I tried to download your Access 2010 database(Customer Database) as instructed by yourself in Tutorial part 7 of 12-Entering Data,part2; but I received an error message saying 'Access-2010-B1-Customer-Data.zip is not a valid Win32 application.' I have tried searching the web for a solution but none of them seems to work. Are you able to provide a solution to my problem?
I have one question related to CustomerID: it stated from: 1, 2, 14, 15,................................................. Could we arrange it from 1, 2, 3, 4, 5, 6,...............14, 15,.........................................................? Because it is not rank.
Hello, is it possible to just enter the year only for the date field? If not, what would be he best alternative field type? (Collecting client data in a developing country where the the clients only know their year of birth, not the day and month). Thanks, the tutorials are great!
That's an interesting scenario. I would say the easiest way to handle that would be to make two fields. One for DateOfBirth (Date) and the other YearOfBirth (Integer). I would allow the user to enter a value into either field. If the enter a full DateOfBirth then you can set YearOfBirth = Year(DateOfBirth) with an AfterUpdate event. That's easy. If instead they just type in a YearOfBirth, then you can set DateOfBirth = DateSerial(YearOfBirth,1,1) and just default them to January 1st. The problem is that you can't type just 4 digits into a standard Access Date field. It won't let you, and there's no EASY way to intercept it before the error message comes up saying the value is invalid. 599cd.com/AfterUpdate 599cd.com/DateSerial 599cd.com/Year
OR...... just have the DateOfBirth field in the table and use an unbound text box on the form. Analyze what the user enters in the text box and save the value accordingly in the (hidden) date field. This would actually make a cool video. I'll add it to my list. :)
It's possible, but not easy. The EASIEST way is to insert 4999 blank records and then delete them. The next item will be 5000. However, YOU shouldn't need to worry about that ID. That's an internal number for Access to worry about.
hi chair man of this Channel , i have a big problem, so i need your help urgently, i'm working as database admin and i'm using Access 2010 -------------- if i want to update blank cells in table using Update query, i try this using update query but i can't , can you help me to solve this problem ? thanks for your efforts Naglaa
I'm having the exact same problem as Abida Ali who said, "Hi, there is an error appear when I copy and paste, the error is " the value entered isn't valid for this field, please explain why this error, i done all the work exactly like you."
because you copy USD (dollars) from the reference. your access settings may have some different currency. i just pasted the whole text into note++ editor and copied every single row without the currency of dollars (i got EUR). i also copied the notes, it works fine. the only thing i didnt get was to insert a new row into a notefield like its done inside the reference. copying the new row solved the problem but its not to my satisfaction.
Hi Teacher, I getting some problem is when i copying u data and paste to my database it pop up error message call ~The value you entered isn't valid for this field. For Example ,you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits i have no idea about this error since i just follow tutorial only
If you are having problems copying and pasting the data it is probably down to the credit limit currency being the wrong value. In design view Try typing in $#,##0.00;($#,##0.00) in the general format tab. Either that just download his version of the database.
Can't copy the database. I followed all instructions. Finally, I had to copy the whole thing as a separate new database, and it STILL won't copy and paste to the one I'm trying to build.
I also could not find the text either from this youtube video, however, I watched a similar tutorial on Richards website where there is a link provided to copy/paste the data to avoid the typing.... 599cd.com/access/misc/ac-2010-b1/customer-data.asp?key=AC2010B1_IN_VIDEO A bit late after your post, but hope it helps anyone else looking :)
These videos are better than any class I have attended for learning things for work. I am sitting at my job learning how to do all of this for FREE (with supervisor's approval, of course because it is going to educate me to be able to work in our database more). I really appreciate this! Thanks so much for posting all of this great information.
+Lisa O'Grady You're very welcome. Thank you for the kind words.
I have been off work for 1 year and a temp service called me today for a job on Monday but i have to know access. This hopefully saved my life. I will keep you updated. I am over 62 now and out of money.
I was going to pay over $500 to take a level 1 Access course, but I am learning so much from your videos! Thanks! You rock!
Thanks for these tutorials Richard. A young lady called me asking if I can help her with learning about Access for her exam next Friday. I had not used it for so long but came across your videos. Now I'm able to help her :). Great tutorials and very easy to follow. Thanks again.
Had to learn Access QUICKLY for a skills assessment and stumbled upon your tutorials....Let me just say a job very well done by you!! Really, I have watched about 40 tutorials and yours fit my needs to a T...Excellent job-- easy to follow but not so slow that I had a nap :) Perfectly paced for me and will be telling my friends and my kids about your tutorials..THANK YOU!!
Awesome training videos. Very clear, detailed, thorough, professional. The audio is excellent. I am learning alot.
Those duplicate people -if my OCD is demanding that the numbers don't disappear forever, as when deleting an entire row, I can just delete the information in them and enter new info, right? And I'm enjoying your tutorials. You are a very good teacher; you explain every little thing and don't assume that people know what you're talking about.
You COULD, but why? 599cd.com/AutoNumbersAreNotForYou
That's WAY beyond the scope of this beginner tutorial. Perhaps I'll post a lesson about this in the future.
Thank you so much! Can't explain in words how grateful I am for your videos :)
This tutorial is so amazing! Thank you so much for these videos. They're easy to follow and understand!
You're welcome
THIS IS A VERY GOOD INSTRUCTOR.
HE DOES NOT HAVE AN ACCENT LIKE OTHERS.
rcx8666c so what if an instructor has an accent. They're sharing knowledge with you for free. Stop trying to invalidate someone because they're different than you.
I agree with both of you. There are lots of people on TH-cam sharing their knowledge for free, and they should not be disrespected. HOWEVER, I've tried to sit through videos, and even in-person lectures, where I couldn't understand the instructor due to a thick accent, and it makes the learning experience a lot more difficult. Sorry to say, but I'm a little biased in that department myself.
OMG... you are sooo good, I'm learning the basic of Access in no time! Thank you so much!!!
Yes. You can have multi-field keys. That's beyond the scope of my beginner lessons, however.
Fantastic! Thank you so much for this tutorial. Even now in 2016 It is coming in handy. I am about to start a course in business administration and I need Microsoft office 2010. I have it all set up on my laptop and I realised i Don't know how to use it. Your videos are helping me a lot. Keep them up forever !
How'd that business course go? Hope my lessons helped.
I really appreciate your great helpful MS Access tutorial.
In this case you would either put 2 phone number fields in your customer table OR if you want to be able to store an unlimited number of phone numbers, you would create a second, related table. I teach how to do this in my Access Expert series (relationships between tables).
Thank you so much..I am updating computer classes and these mini-lesson are great before I go to official on campus classes to apply application.
That's how Autonumbers work. As soon as you start entering the first bit if data into a new record, that Autonumber is committed. If you cancel editing (ESC) or finish and delete the record (row) then that Autonumber is GONE forever. Remember... YOU shouldn't worry about those numbers. They're not for YOU. They're for Access to create relationships later.
These videos are so helpful! I am learning how to run space analysis at work and we have too much data to use excel. I have never used Access and these videos are helping me so much! Thank you for all that you do!
You're very welcome.
Glad I was able to help.
Your a genious and very greatfull guy. Thank you very much for all the info you have shared with us. Let me inform you that I've been waiting and looking for this course. Thousand of thanks.
thank you so much for making these videos, you're truly a swell guy
This is how tutorials should be made
Thanks
I'm loving these classes!
My pleasure
Hats off to you,Sir..Thanks,Indeed..For enlightening me about MS access.You have uploaded such an amazing videos.This is really a great great work...May God give you more knowledge!!!!!
Welcome
Thanks so much for your tutorials Richard. Great Job
Thank you so much for your lessons. Very clear and easy.
Welcome
Excellent videoclip!! Very informative and well organized! Thx
No. You would not want to use an Autonumber for this type of data, and Autonumbers cannot change once they're assigned (by Access).
Thank you.
Thanks!
Excellent videoclip!! Very informative and well organized! Thx~
Brilliant tutorials - thank you!
U r a very good trainer ..Love ur tutorials
Thanks
Autonumbers can ONLY be numbers. You could make your own CUSTOM field to do this, however. You could say something like this in a query: MyCounter: "MF" & ID
Of course. Access can do just about anything. :)
very detailed and through videos!! thanks a lot!
awesome tutorial well done job and really appreciated
YOU should never worry about what the IDs are. They're only used internally for Access to form relationships with other tables. If you want your own counter value that you can make sure has no gaps, then you have to create your own, and it will involve a little programming. See this page on my web site: 599cd(DOT)com/X29049
Excellent tutorial. If I am using a field such as employee seniority and this changes as new people are hired or leave can this filed still be the AutoNumber data type?
Thank you sir .... its a bloody useful tutorials for access.
I'm Bassam from Baghdad,Iraq and I'm The HR Executive for Investment Company in Iraq.
And now I'm Planing to use Access for My Work database
Thanks again
And Allah bless you
Welcome
Sounds like you're trying to enter a text value into a numeric field, or something along those lines. Check your data types.
Thanks for your great tutorial,, they have helped me a LOT :-)
Welcome
i'm learning database from your tutorial for my final examination. and it's easy to understand. tq ~~ wish me luck !
Good luck
Excellent tutoring.
Many thanks!
Right-click on the table and select RENAME.
Deborah, I hope this helped! Let me know how you did.
Sure. Just set the fields Indexed property to YES, NO DUPLICATES.
How do I get rid of my old database files that I was trying to set up before discovering your wonderful lessons?
Hi! Would you happen to have a sample tutorial or template for inventory of goods/supplies?
Great videos, Richard! Thank you!
Welcome
I'm glad to help. Now you can take that $500 and buy some of my more advanced lessons. 8-)
Well, if you're sure you don't want them anymore, just delete the ACCDB files.
To which text are you referring?
You're welcome. Tell your professors to use my lessons in class. :)
Great help, thanks man!
keep up the good work
Thank you , very clear and usefull videos..
Welcome
Dude, beginners don't always grasp new concepts as quickly as you obviously do. These lessons were made for NOVICE users who have little or no experience with Access. Go get yourself an advanced tutorial or a book if these are too slow for you. Sorry, but I can't please everyone. You'll find that my advanced tutorials go at a much quicker pace... but these are made for BEGINNERS.
is there a way to designate the primary key as a combination of two fields?
thx! excellent videos
Many Thanks from Egypt.
Welcome
Excellent!
Is there a way to check/uncheck multiple rows at once?
I am unsure what I am doing wrong here, but when I try to copy and paste the info into my table it comes up with an error message. I highlighted the whole row and still it does not work.
Thank you so much, you are doing a good job
Welcome
Aw golly gee... thanks. :)
your training is very clear and precise. Is your webpage working? I tried and it went to a white page. thank you again this is great training.
Should be working, although 6 years ago I was still with GoDaddy and they are a giant bag of pig vomit. :)
can you tell me more about a star schema.. I am having some trouble with this
can we create our own set of unique id and declare it so that we cannot duplicate that number by mistake like the ssn
can access be used to maintain church register and calculate monthly dues?
Just spent half an hour trying to figure out this same error. Was certain all my data types were correct but kept getting "value added isn't valid..." message. Eventually I started copying and pasting single fields and found the error was down to my currency units not being in USD$. Maybe the previous poster was having the same issue? I was able to work around and carry on but thought I would post this in case it helps someone else.
is there any video on how to add tax to the data
I had the same problem with pasting - it's because my default currency is British pounds rather than the dollars you've used. An annotation in the video would be helpful, or you could just remove the dollar signs from the provided text :)
When I enter the e-mail addresses it does turn to blue and I can not double click it. What do I need to change?
Hi, there is an error appear when I copy and paste, the error is " the value entered isn't valid for this field, please explain why this error, i done all the work exactly like you.
how come when I delete a row and create a new row the customerID still increments? I deleted row two and wanted to remake it and it came out as customerID 3. How do i fix this >.
What if i have 2 same primary key but the other fields is different. For example, having the same customerID but he have 2 telephone numbers . Do i create 2 records ?
These tutorials are great and has helped me immensely! However I have a problem and need your input. I tried to download your Access 2010 database(Customer Database) as instructed by yourself in Tutorial part 7 of 12-Entering Data,part2; but I received an error message saying 'Access-2010-B1-Customer-Data.zip is not a valid Win32 application.' I have tried searching the web for a solution but none of them seems to work. Are you able to provide a solution to my problem?
599cd.com/ask
I cant find the data on the website.
very good
Very Nice Thanks
You're welcome
I have one question related to CustomerID: it stated from: 1, 2, 14, 15,.................................................
Could we arrange it from 1, 2, 3, 4, 5, 6,...............14, 15,.........................................................? Because it is not rank.
AutoNumbers are not for YOU. They're for Access. Their values don't matter. See 599cd.com/AutoNumbers 599cd.com/Counter
Hello, is it possible to just enter the year only for the date field? If not, what would be he best alternative field type? (Collecting client data in a developing country where the the clients only know their year of birth, not the day and month). Thanks, the tutorials are great!
That's an interesting scenario. I would say the easiest way to handle that would be to make two fields. One for DateOfBirth (Date) and the other YearOfBirth (Integer). I would allow the user to enter a value into either field. If the enter a full DateOfBirth then you can set YearOfBirth = Year(DateOfBirth) with an AfterUpdate event. That's easy. If instead they just type in a YearOfBirth, then you can set DateOfBirth = DateSerial(YearOfBirth,1,1) and just default them to January 1st. The problem is that you can't type just 4 digits into a standard Access Date field. It won't let you, and there's no EASY way to intercept it before the error message comes up saying the value is invalid. 599cd.com/AfterUpdate 599cd.com/DateSerial 599cd.com/Year
OR...... just have the DateOfBirth field in the table and use an unbound text box on the form. Analyze what the user enters in the text box and save the value accordingly in the (hidden) date field. This would actually make a cool video. I'll add it to my list. :)
I have 100's of items of data to use. Is there a faster way of doing this rather than 1 by 1?
do you have them in excel form or word ? you can import them to access!
599cd.com/ask
very useful tips
Special web page ''downloading for copy of data isn't working now. :( How can I download those sample data?
Huh?
If you want to id number from 5000 insted of 1 is that easy?
It's possible, but not easy. The EASIEST way is to insert 4999 blank records and then delete them. The next item will be 5000. However, YOU shouldn't need to worry about that ID. That's an internal number for Access to worry about.
i have a question, how can I copy Excel field to Access?
Copy and Paste? Import? Lots of ways. 599cd.com/AC13X20
hi chair man of this Channel ,
i have a big problem, so i need your help urgently,
i'm working as database admin and i'm using Access 2010
--------------
if i want to update blank cells in table using Update query, i try this using update query but i can't , can you help me to solve this problem ?
thanks for your efforts
Naglaa
I'm having the exact same problem as Abida Ali who said, "Hi, there is an error appear when I copy and paste, the error is " the value entered isn't valid for this field, please explain why this error, i done all the work exactly like you."
because you copy USD (dollars) from the reference. your access settings may have some different currency. i just pasted the whole text into note++ editor and copied every single row without the currency of dollars (i got EUR). i also copied the notes, it works fine. the only thing i didnt get was to insert a new row into a notefield like its done inside the reference. copying the new row solved the problem but its not to my satisfaction.
How Can I Change the Table Name??
hi can anyone tell me how to use the compleat the whole page in microsoft word
Hi Teacher, I getting some problem is when i copying u data and paste to my database it pop up error message call
~The value you entered isn't valid for this field. For Example ,you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits
i have no idea about this error since i just follow tutorial only
The error message says it all. You've tried to paste data of the wrong type into a field, like pasting "Squirrel Lover" into a date field.
@@599CD Thanks Teacher Love u So Much
If you are having problems copying and pasting the data it is probably down to the credit limit currency being the wrong value. In design view Try typing in $#,##0.00;($#,##0.00) in the general format tab. Either that just download his version of the database.
Thanks
Can't copy the database. I followed all instructions. Finally, I had to copy the whole thing as a separate new database, and it STILL won't copy and paste to the one I'm trying to build.
Sorry to hear that
How do I subscribe
click the subscribe button
I also could not find the text either from this youtube video, however, I watched a similar tutorial on Richards website where there is a link provided to copy/paste the data to avoid the typing....
599cd.com/access/misc/ac-2010-b1/customer-data.asp?key=AC2010B1_IN_VIDEO
A bit late after your post, but hope it helps anyone else looking :)
Hi I want to add another email ID for Richard Roast ( Entry no 1). Access do not permit me doing that. Can anyone help me on this
Add a second field or a second related table.
you can trust Ricky