Jamie is a lifesaver. I like how he takes his time almost in all the videos really patient and the fact that I'm also a patient its comes as a bonus. I have learnt so much from him, in my books he's a hero.
I touched on Access a small amount in college, but it's been a few years now. At my job I'm using it now and completely forgot most of it. It's difficult to find tutorials on it so I appreciate this video it helped a lot. Thanks
A teacher walked up to me for help in teaching her how to tackle questions in an external exam with MS Access. Without any knowledge, a look at this video makes me a beginner guru. Thanks a lot. I am leaving excel for a while to explore this powerful programme
I just got a new job as a senior accountant and this company uses access 😩😩. I have not used it in years since college and wasn’t aware company’s still use this software. Anyways, I am here to learn to get better at my new role 😊
Hello Melissa. I am just a bit curious about the use of Access in finance. I work in finance too and I started to get to now access more, however I am kind of lost in terms of when should I use it instead of excel. We do use excel a lot but never access. So, I am not really sure a what point I can say "well now is a good time to use access". Thank you
Thank you so much, I now have Access to Access! I’ve been using Word & Excel for years and using Excel where I know I really should have been using Access. I could never find a tutorial that was easy to understand, mainly because the tutors didn’t convey in Layman’s Terms. So easy to digest and implement what you teach, and you deliver in such a simple & fresh way. You get 10/10 from me. I will use Access a lot now to manage a plant database and it will open new doors of creativity for me I’m sure. Brilliant.
My first time trying out MS Access and it was well worth my time to start learning the basics. I'll be looking out for other videos on Access to learn more. Thanks heaps! You got a new subscriber
Thank you, this was a really good tutorial. There were a couple of times I had to replay how you reverted back to 'Views' and which one you chose but it was easy. This gives me hope that I can learn Access. Will definitely be watching more of your vids. You have a new sub!
Thank you for the information, I recommend Teacher's Teach Channel To anyone who wants to learn more, This Channel has helped me a lot, Thank you Sir for your hard work 👏👏
Greatly helpful. I am in the process of creating and Ancestry and was using Excel but this makes much more sense due to being able compare one person to another. Will be back for more learning.
This video is the first decent into to Access I have found. I need more information on creating queries and reports to extract data, so I will check out some of your other videos. Thank you.
Jamie, At 12:06, did you ever figure out what was wrong? I have the same problem. I thought I could solve it by holding the control key scrolling the wheel on my mouse, but that didn't work.
I have a Access file that I’m making changes to but saving as a different file name so that changes only reflect on new file but when you open both files it overwrites on original document as well any suggestions?
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
I'm trying to create a New Blank Record in a Form but when I do the info does not automatically show as a new line in my Table. The only way I have found to get the new line to show up is to switch my Table from Datasheet View, to Design View, back to Datasheet View and the line appears. Any idea why this may be happening and how to avoid it? Thank you
Hi love your video, however it seems I’m unable to import an excel that contains macro. It says “the wizard is unable to access information in the file xxxxxx. Please check that the file exists and is in the correct format” not sure if you have come across this error before?
Hello. Please tell me how the data was populated in the Form View on Count: 18:21. On my version, the information did not populate and unless I missed something, is the information supposed to populate itself or am I to enter it? thanks
Quick question. If I pulled from ans excel sheet and later go and update the excel sheet. Next time I open Access, would it also pull from the excel sheet or if I update the access sheet with the excel sheet, would it only pull the new additions?
I have two tables with two separate forms. The first table based on the first table has a calculated text box. I want to show the textbox data to a field to another form. How to do it. Thanx and regards.
Question...?... I keep a journal with lots of notes and data. I use it for work as I order parts for service technicians. I need lots of data to process warranties on many of these parts. I have been using Excel by copying some data over to it... This is too much redundancy! Can I use Access with links to my OneNote journal entries?
Hi Jamie, Sir, I am working in a construction company, which has 33 subcontractors, each subcontractor has 20 welders, and welders different qualifications, so how many tables I have to prepare. I have made 1st table as "company" which contains 33 company's personal information's, and I made one table for all 33 companies names. If so how should I make a relationship. 1. I made a relationship between Company ID's to company I'd of all the 33 tables each other 2. Then I made an individual relationship from COMPANY Table (company I'd to company I'd) to individual table's
Hi sir! This video was really helpful,I had my computer practical exam and couldn't practice at home. After watching your video i scored full marks. Thank you so much sir :)
Thank you Sir for the opportunity you have been giving us to learn from you, I have learned a lot and still learning, I'm very grateful and short of words to describe how thankful I'm.
I'm living next to an air force base and want to make an overview of all types of aircraft and units that have been there from 1940 till 1996. Sometimes there's an overlap from squadrons and aircraft types but that is not always the cause. A query should show when a particular type of aircraft (or flying unit) was in use at any moment in time.
Jamie is a lifesaver. I like how he takes his time almost in all the videos really patient and the fact that I'm also a patient its comes as a bonus. I have learnt so much from him, in my books he's a hero.
I touched on Access a small amount in college, but it's been a few years now. At my job I'm using it now and completely forgot most of it. It's difficult to find tutorials on it so I appreciate this video it helped a lot. Thanks
A teacher walked up to me for help in teaching her how to tackle questions in an external exam with MS Access. Without any knowledge, a look at this video makes me a beginner guru.
Thanks a lot. I am leaving excel for a while to explore this powerful programme
had to use this for a college course and it was probably the simplest assignment ive done because of how you explained it. thank you!
I just got a new job as a senior accountant and this company uses access 😩😩. I have not used it in years since college and wasn’t aware company’s still use this software. Anyways, I am here to learn to get better at my new role 😊
Feedback?
Good work
Hello Melissa. I am just a bit curious about the use of Access in finance. I work in finance too and I started to get to now access more, however I am kind of lost in terms of when should I use it instead of excel. We do use excel a lot but never access. So, I am not really sure a what point I can say "well now is a good time to use access". Thank you
U can make it girl ge patient 😊
😊
Thank you so much, I now have Access to Access! I’ve been using Word & Excel for years and using Excel where I know I really should have been using Access.
I could never find a tutorial that was easy to understand, mainly because the tutors didn’t convey in Layman’s Terms. So easy to digest and implement what you teach, and you deliver in such a simple & fresh way. You get 10/10 from me. I will use Access a lot now to manage a plant database and it will open new doors of creativity for me I’m sure.
Brilliant.
I used microsoft access a bit at work this year and it was great
Definitely a powerful program!
i have a ICT CT in 4 days, this *will* help me far better than my teacher
Loud and clear 👏💯💖. I also love that everything is so vividly displayed on the screen.
My first time trying out MS Access and it was well worth my time to start learning the basics. I'll be looking out for other videos on Access to learn more.
Thanks heaps! You got a new subscriber
I love it... This was so simple and easy to understand. Thank u so much... You taught it better than my teacher...
this is great...learned access when I was young... but don't really have a good view of what it does... this videos now clears everything...
my goodness thank you so much sir
Thank you, this was a really good tutorial. There were a couple of times I had to replay how you reverted back to 'Views' and which one you chose but it was easy. This gives me hope that I can learn Access. Will definitely be watching more of your vids. You have a new sub!
Thank you so much...I can't stop watching your videos..am are student in Kenya 🇰🇪
Waiting for an Access Tutorial for a long time.
There are a very few tutorials on Access and this is one of them.
Glad I had subscribed...
Glad I could help! I'll be creating a series of videos on this topic.
Thank you for the information, I recommend Teacher's Teach Channel To anyone who wants to learn more, This Channel has helped me a lot, Thank you Sir for your hard work 👏👏
You are very welcome! I’m glad the videos help people out.
@@TeachersTech Yes you are helping us a lot. I even learned video editing from you.
Thanks a lot
Greatly helpful. I am in the process of creating and Ancestry and was using Excel but this makes much more sense due to being able compare one person to another. Will be back for more learning.
Wow. Quality teaching for a biginner. I am. Loving acess
I watched the level1 access tutorial video and it was very helpful to me and it increased my knowledge.
Thanks
Amazing tutorial! I like how you kept it simple. You are a great teacher!
Thanks so much!
Love your video, great presentation to explain how to use access, your are really a good teacher that knows how to teach!
I appreciate that!
wowwww!!!
Am in love with this tutorial ❤️💕
excelente tutorial, me ha ayudado bastante. Gracias
Thank you for being clear in all your explanations.
Best fast understand tutorial on access.
This video is the first decent into to Access I have found. I need more information on creating queries and reports to extract data, so I will check out some of your other videos. Thank you.
Thanks for sharing this video. It's straightforward to follow and easy to understand the basics. Thanks!
WELL DONE techer 🥰🥰
Well done. This was very helpful. I followed along, creating the database as the teacher performed the task.
Jamie,
At 12:06, did you ever figure out what was wrong? I have the same problem. I thought I could solve it by holding the control key scrolling the wheel on my mouse, but that didn't work.
I also have a problem in copying your practice file to Access.
I have a Access file that I’m making changes to but saving as a different file name so that changes only reflect on new file but when you open both files it overwrites on original document as well any suggestions?
Incredibly helpful for a beginner. Thank you! Your teaching style is terrific with your pace and instructional content.
Thanks, Jamie. Great beginners' Lesson!
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
I'm trying to create a New Blank Record in a Form but when I do the info does not automatically show as a new line in my Table. The only way I have found to get the new line to show up is to switch my Table from Datasheet View, to Design View, back to Datasheet View and the line appears. Any idea why this may be happening and how to avoid it?
Thank you
Hi, if the linked excel has new rows, will those new rows be reflected in the imported access table?
Thanks
Hello how do I set up a crowfoot diagram chart for my ERD in my MS Access?
thanks to you , you have made me understand right from scratch.
Hi love your video, however it seems I’m unable to import an excel that contains macro. It says “the wizard is unable to access information in the file xxxxxx. Please check that the file exists and is in the correct format” not sure if you have come across this error before?
The video was very understanding to me.. even my school teacher cannot explain as much as you Sir .. Thanks once again for the tutorial😍
THIS IS AWESOME TUTORIAL. ON TO PART 2.
Hello friends. Great MS Access!
Hi, how do you stream your screen and the outline of yourself on top of the screen without the background?
I use Camtasia, check out my home page, I have a video on how I use it there.
Nice one it really has been simplified...
Thank you so much for the explanation. I really needed this looking Forward to the next course
Perfect timing because just started database management class and we are going to use access.Thanks for the info.
Glad it was helpful!
@@TeachersTech bro what are you’re timings,I just got out of that class…are you a wizard :0 and yes it did help
I've looking for a video like this on RUclips for e long time! Thank you so much for sharing with us! God bless you!
You are so welcome!
Thanks for the tutorial. Really helped a lot. Hope you'd create a tutorial about relationships
Love it. Thank you so very much! You are the best!
Hello. Please tell me how the data was populated in the Form View on Count: 18:21. On my version, the information did not populate and unless I missed something, is the information supposed to populate itself or am I to enter it? thanks
Thank you! Great introducing video.
Thank you for sharing your knowledge! This is truly helpful 🙏😊
He is a wonderful teacher!
Thank you! This was really helpful👍👍
Amazing!!! Your videos have been a life saver for me.....I'll be watching more this weekend. Now if you could only do a beginners SQL ❤❤❤
Quick question. If I pulled from ans excel sheet and later go and update the excel sheet. Next time I open Access, would it also pull from the excel sheet or if I update the access sheet with the excel sheet, would it only pull the new additions?
I can say it has been wonderful, a step by step session and at the end of it I have been able to produce the same results💗
Very helpful
How can I make the form open new record by default when I open it
your video is helpful, thanks sir
Well understood, sir
Thank you for the good job
Thus video came at the perfect time because my twins are creating an elections database using access. Absolutely 💯 love your channel and tutorials
Teacher 🅝🅘🅒🅔 I'm v liked so if you're new information level 1/4 sends wait
I have two tables with two separate forms. The first table based on the
first table has a calculated text box. I want to show the textbox data
to a field to another form. How to do it. Thanx and regards.
Thank you I was having trouble using it!
You’re welcome!
Question...?... I keep a journal with lots of notes and data. I use it for work as I order parts for service technicians. I need lots of data to process warranties on many of these parts. I have been using Excel by copying some data over to it... This is too much redundancy! Can I use Access with links to my OneNote journal entries?
This is super helpful! I had no idea at all and now it is making sense!
keep up the good work my friend this is a blessing to have the breakdown of so much and to learn so much is wonderful.
You're great teacher
Very good and helpful tutorial. Thank you.
After a long time I'm finally learning it again
Thank You! You made this simple and it no longer looks like a daunting program.
Me gustó mucho, Gracias.
Great Tutorial, you are excellent James at explaining things in simple terms. I look forward to part 2.
Thank you, glad you liked it.
hello, i'm trying to dsum my total sales using the cirteria of dealership name and i also want to include a date range in this. can you help me out.
Amazing 👍
it is really helpful for beginners.😃
Thank you for this tutorial. Just wondering, can this be used as database for patient records? like an EMR? ....cheers!
you’re amazing man
That was so clear... thank you
TQ..very helpfull for my first time learner
Thank you sir for sharing your knowledge.
Great,easy to understand.
you are the best
nice and easy u ahve asaple worksheet to practice
Hi Jamie, Sir, I am working in a construction company, which has 33 subcontractors, each subcontractor has 20 welders, and welders different qualifications, so how many tables I have to prepare. I have made 1st table as "company" which contains 33 company's personal information's, and I made one table for all 33 companies names. If so how should I make a relationship. 1. I made a relationship between Company ID's to company I'd of all the 33 tables each other 2. Then I made an individual relationship from COMPANY Table (company I'd to company I'd) to individual table's
You did an excellent job. ? Phone numbers ...how did you get the dash appear
very helpful for a beginner, thank you .
Hi sir!
This video was really helpful,I had my computer practical exam and couldn't practice at home. After watching your video i scored full marks. Thank you so much sir :)
This is very helpful, thank you
Thank you Sir for the opportunity you have been giving us to learn from you, I have learned a lot and still learning, I'm very grateful and short of words to describe how thankful I'm.
Thanks really helpful
So helpful!! Been meaning to get started on access and kept putting it off but feeling able to make a start now!
Thanks sir - fantastic job
I start a new job on Monday. Told them I had access experience. Thanks for this!
thank you again well explained
Glad I could help, your welcome!
thx for this vid. im new to acess. and writing a test about it.
Thank you very much!
I'm living next to an air force base and want to make an overview of all types of aircraft and units that have been there from 1940 till 1996. Sometimes there's an overlap from squadrons and aircraft types but that is not always the cause.
A query should show when a particular type of aircraft (or flying unit) was in use at any moment in time.
This is amazing ❤