Microsoft Access 2013 Tutorial Level 1 Part 05 of 12 - Customer Table, Part 2

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ต.ค. 2024

ความคิดเห็น • 295

  • @academicsinc.909
    @academicsinc.909 9 ปีที่แล้ว +2

    I'm an educator not a business person, and I found it a great instrument for tracking my students, parents, teachers and the students grades. Maybe it isn't for every educator but with a simple set up with this wonderful instructor it is possible, GO EDUCATORS!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @anncarlson6311
    @anncarlson6311 9 ปีที่แล้ว

    Haven't played in Access for awhile and am going from 2007 to 2016. I'm going through your series from the beginning to blow the dust off the brain cells. I appreciate the detail and I'm not getting bored - even though it is a refresher.

    • @599CD
      @599CD  2 ปีที่แล้ว

      My pleasure

  • @elkhanhamet2561
    @elkhanhamet2561 9 ปีที่แล้ว

    sir, I absolutely love the way you teach Access, the way you talk and explain just makes it so easy and accessible for anyone to understand and gain Access skills. Out of all tutorials I've seen this one is THE BEST!!! Thank you very much and I will stick to your advanced videos all the way till the end.Thanks again!!!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome again

  • @nakuru1956
    @nakuru1956 9 ปีที่แล้ว

    I have survived tutorials 1 to 5. They are excellent. Easy to understand and follow. I am enjoying the tutorials and will finish them all. Thank you.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @yvonnescott4828
    @yvonnescott4828 8 ปีที่แล้ว

    I have been watching the tutorials and have learned a lot. I enjoy your easy to follow, uncluttered, teaching style. You make it fun to learn. You don't speak over our heads. The design of the screens makes it easy to understand what you are presenting. Thank you very much for your lessons.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Welcome. Thanks for the kind words.

  • @SEEpath-kt7jm
    @SEEpath-kt7jm 8 ปีที่แล้ว

    Bro, you are God send. Each one of your lessons is amazingly tailored to guide and educate your audience. I'm truly grateful for your time and willingness to share with us your knowledge about Access. It makes me sad and angry, I'm spending $20,000 each year and wasting 2 hours of my day to get a paper rather than learn from an amazing instructor such as yourself. As far as using titles to identify one's self go, you my friend need a title that FAR EXCEEDS the parameters for the title of a teacher. You are THE ENLIGHTENED ONE.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Ha ha. Awww... thank you. Your kind words made my day. Sorry it took me 4 years to see this and reply. How did getting that paper go?

  • @karirudh7605
    @karirudh7605 9 ปีที่แล้ว +14

    Appreciate your basic down to earth language in your explanations and your level of detail addressing confusions that may arise at each step. Thank you.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @rtee4780
    @rtee4780 10 ปีที่แล้ว +1

    I'm enjoying the course so far and I appreciate all effort you have put into these lessons.
    It's a great refresher from my Access 97 & 2000 days.
    I want to make a couple points about what you said though:
    1 - Do NOT mistake the AutoNumber field for a true primary key. The AutoNumber type only creates unique numbers for each record. It does NOT prevent or eliminate duplicate information in your table. Meaning you could have the same customer info in multiple records but with a unique CustomerID number. In this case, you will not have data integrity and any query results and reporting for that customer will be inaccurate.
    2 - Also, you would likely never delete records from the customer table once the database was actually in use. You would simply set the IsActive field value to No (uncheck the check box). Deleting records from this table would create orphaned records in other tables that held data for these customers.
    I realize it's early in the series and you may address these points later on, but they are important to know and for people to think about up front when creating tables.
    Thanks again, I'm looking forward to the rest of the series.

    • @599CD
      @599CD  10 ปีที่แล้ว

      R Tee The AutoNumber field is a TRUE primary key. It is a unique identifier for each record. I understand what you're referring to, but that's more of a training issue than a database issue. Users should be instructed to see if the customer is in the database FIRST before adding a new customer, and you could set some of the fields that should be unique to "INDEXED, NO DUPLICATES" if you want to make sure you don't have two customers with the same address, phone number, or email address, but this is something you'd build into your database yourself. The AutoNumber, however, is a true primary key in every sense of the word. I do agree with your about deleting records. I personally prefer to NEVER delete records from my databases (especially customer records). Yes, it's much better to mark them inactive. You can prevent "orphan" records by using referential integrity and cascade deletes, however this would then delete things you may not want deleted, such as order information, which would mess up your accounting. Thanks for the feedback! Very helpful.

  • @tenacoutlaw
    @tenacoutlaw 8 ปีที่แล้ว

    These videos are great, simple clear directions. Going over and explaining how/why as he moves through each step. Makes it all very clear, only hope my teacher IRL is as good as he is. I'll be starting a class in 2 days and wanted a primer, might have saved a bunch money had I found this sooner. Thanks for making them , I'll be sending my wife to the windows tutorial.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks. How'd the class go?

  • @darnb100
    @darnb100 10 ปีที่แล้ว

    dude you have the most awesome and easy to understand tutorials ive ever seen. I would totally pay for the expert course if i had a credit card.

  • @edalvi441
    @edalvi441 10 ปีที่แล้ว

    Evolution of Access had me lost, since the days of Access 2003. It is refreshing to observe Access 2013 explained in such a passionate way. Great Job!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @maqsoodkhan7451
    @maqsoodkhan7451 9 ปีที่แล้ว

    This is the best Access tutorial I have ever seen. Thumbs up for you.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @luwei1120
    @luwei1120 10 ปีที่แล้ว

    This is actually so far the best tutorial on TH-cam about Microsoft Access... Doesn't make me sleepy at all!!!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @mskstudio_net
    @mskstudio_net 9 ปีที่แล้ว +3

    Easy to understand tutorials. Appreciate your hard work and simple to follow way of teaching.

    • @599CD
      @599CD  2 ปีที่แล้ว

      My pleasure

  • @northernlitegirl
    @northernlitegirl 8 ปีที่แล้ว

    Thank you for these tutorials. Having never studied Access before I find your method of teaching very logical and helpful. It makes the effort to increase computer skills less intimidating when the instruction is well ordered.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks

  • @annekirkpatrick5911
    @annekirkpatrick5911 10 ปีที่แล้ว +1

    I am learning more than I expected from this series. Thank You

  • @sanogobakaramoko9531
    @sanogobakaramoko9531 4 ปีที่แล้ว +1

    You are the best teacher I never met before

    • @599CD
      @599CD  4 ปีที่แล้ว

      Haha. Thanks! Nice to not have met you. :)

  • @artisticpiscean
    @artisticpiscean 10 ปีที่แล้ว

    Thank you so much for ALL of your videos! You made me able to build my own database for our home improvements company with about 2000 customers! Greatly appreciated!!!

    • @599CD
      @599CD  ปีที่แล้ว

      welcome

  • @advocatus360
    @advocatus360 7 ปีที่แล้ว

    Very good tutorial. I find that watching the video at 1.25x speed keeps me actively engaged (in my busy cubical workspace). Thank you for creating these videos.

    • @599CD
      @599CD  3 ปีที่แล้ว

      You're very welcome.

  • @cheryllynn5671
    @cheryllynn5671 9 ปีที่แล้ว

    These videos are so very helpful for me as a new Access user and a novice database designer. Thank you for doing these videos.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @JulieKenk
    @JulieKenk 10 ปีที่แล้ว

    Thank you following my comments from previous lessons. Now it's make sense. I was able to right client on my previous entry from my client list and I was able to see the table view. Now it's make sense and I understand more the way we put the entry. Thank you

    • @599CD
      @599CD  ปีที่แล้ว

      Welcome

  • @salihubabamusa4038
    @salihubabamusa4038 3 ปีที่แล้ว

    Great! Not a single important point missed. Very clear and concise. Good for all.

    • @599CD
      @599CD  3 ปีที่แล้ว +1

      Thanks!

  • @markgutman3217
    @markgutman3217 10 ปีที่แล้ว

    These lessons are fantastic! I took a course in Access (I forget if it was undergraduate or graduate level) in 1995 and got an A in it. But I've learned more, or have a better understanding, from watching these few videos than I learned in that class. (The other two classmates got most of the work done on our project, and I know how to take tests.) Of course, these videos can be stopped and backed up over and over, which is very helpful to me. I'm amazed at how simple the learning seems so far. And excited about all the ways I'll be able to use a database, both at work and at home.

    • @599CD
      @599CD  ปีที่แล้ว

      Thanks

  • @jamesneece3131
    @jamesneece3131 9 ปีที่แล้ว +2

    *High-Five* Had to pause and give you props for the Space Balls plug. Good series!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Nice!!! :)

  • @lauramhina8151
    @lauramhina8151 4 ปีที่แล้ว +1

    I am loving the learning through u. Thank you for making it easy to follow up.

    • @599CD
      @599CD  3 ปีที่แล้ว

      You're Welcome!

  • @kegenrodrigues
    @kegenrodrigues 6 ปีที่แล้ว +3

    Watch it at 1.5 speed.
    People this guy deserves more likes..just in case you have forgotten

    • @599CD
      @599CD  3 ปีที่แล้ว

      Yeah!

  • @Badger214
    @Badger214 6 ปีที่แล้ว

    Wow. Just wow. I learn much more than Access. I am learning how to teach. Excellent job. Excellent Job. Pat your self on the back.

    • @599CD
      @599CD  3 ปีที่แล้ว

      My pleasure

  • @mountainman5900
    @mountainman5900 10 ปีที่แล้ว +1

    Thank you for these videos. I was looking for a refresher and this is perfect!

  • @senjeanman
    @senjeanman 11 ปีที่แล้ว

    So clear, so fluid, so easy to follow. Excellent work!

  • @alanhanley214
    @alanhanley214 8 ปีที่แล้ว

    Ive been following these tutorials to get a real taste for Access, and I have found the teaching style and instruction to be fantastic, however as part of the course I am doing my knowledge of Access is a little all over the place so what would be really good is if you could create a link where you could download the entire video collection covering all the tutorials so you can have them on a portable device if you're in a location where you don't have internet. For someone like me this would be a very valuable asset to have in my tutorials collection

    • @599CD
      @599CD  2 ปีที่แล้ว

      Sure... go here: 599cd.com/ACB1

  • @enosimon1464
    @enosimon1464 8 ปีที่แล้ว +1

    Thanks for sharing this rich knowledge about Access! I can't wait to get started!

    • @599CD
      @599CD  3 ปีที่แล้ว

      Welcome

  • @stephensullivan4888
    @stephensullivan4888 9 ปีที่แล้ว

    Thanks for these tutorials I used Access in the years well gone=by I am following your course as Access 2013 as is it is so very different from the version I have used before keep up the good work !

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @annmannion7832
    @annmannion7832 8 ปีที่แล้ว

    I have been doing your lessons, I find them very helpful, very well explained

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks

  • @drfroglegs
    @drfroglegs 8 ปีที่แล้ว

    You are a really good teacher. Thanks for taking the time to make these videos. They are very informative.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Welcome

  • @nqobile203
    @nqobile203 8 ปีที่แล้ว

    Thank you it was really easy to understand and was struggling with database design but now I see that basics are important..Thanks again!!

    • @599CD
      @599CD  2 ปีที่แล้ว

      welcome

  • @mikesimpson8558
    @mikesimpson8558 8 ปีที่แล้ว

    Thanks. Extremely helpful for basic user. I look forward to future lessons!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome!

  • @kgomotsopupuma9142
    @kgomotsopupuma9142 9 ปีที่แล้ว

    I meant to say "grateful for you posting the tutorials".

    • @599CD
      @599CD  2 ปีที่แล้ว

      My pleasure

  • @sharonhemphill8398
    @sharonhemphill8398 9 ปีที่แล้ว

    This is the best series ever!!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @omaridaniels8427
    @omaridaniels8427 9 ปีที่แล้ว

    Actually learning Access right now for my job, so this tutorial has come in handy so far.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @zeitgeistry
    @zeitgeistry 9 ปีที่แล้ว +4

    I've been following your lessons - great instructional videos and I've really enjoyed your teaching style. So far, one question regarding to "AutoNumber" for "CustomerID" - I noticed that you let this field be "Indexed: Yes (Duplicates OK)" Can you explain why you let this field be "Duplicates OK"?

    • @599CD
      @599CD  9 ปีที่แล้ว +1

      Zeitgeist TTD Where in the video did you see this? Autonumbers should always be Indexed No Duplicates. They have to be in order to be a primary key field. You CAN change the setting, but it doesn't matter because you can't change any of the automatically assigned values.

    • @michaelsmits8677
      @michaelsmits8677 8 ปีที่แล้ว

      +PC Learning Zone - Computer Training
      pause the video at 12:42 and there it is, I work on a Dutch version of Access and I got another yes option like

    • @jvkenshin416
      @jvkenshin416 8 ปีที่แล้ว +1

      +Michael Smits Yes, you're right. But that was BEFORE the CustomerID field was set as a Primary Key. You can check to see that, AFTER setting it up as a Primary Key, it was automatically changed to - Indexed: Yes (NO Duplicates). Hoped this helps and clarifies things.
      Great lesson by the way PC Learning Zone (Sorry, I don't know your first name).

  • @SaigoRyu
    @SaigoRyu 10 ปีที่แล้ว +1

    You are an amazing teacher. Thank you very much for putting this together.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @harshalshinde227
    @harshalshinde227 8 ปีที่แล้ว

    This lectures are gold!

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks

  • @Rowdyrecords55
    @Rowdyrecords55 9 ปีที่แล้ว +7

    Thanks for these great lessons!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @ellie1595
    @ellie1595 8 ปีที่แล้ว

    You are a really great teacher. I am completely enjoying learning from you. One question? In older versions I remember that I would add new names at the bottom of my database or table and when I closed it the name would automatically be alphabetized. Now it seems to go in order of the ID. Am I wrong about this?

    • @599CD
      @599CD  3 ปีที่แล้ว

      You can sort by whatever field you want.

  • @Numilex
    @Numilex 11 ปีที่แล้ว

    Thanks so much for these tutorials, you got me an A for my database at school!

  • @bobbyebadi3111
    @bobbyebadi3111 9 ปีที่แล้ว

    Thank you! I learned and enjoyed your teaching style.

    • @599CD
      @599CD  2 ปีที่แล้ว

      My pleasure

  • @damienro0
    @damienro0 10 ปีที่แล้ว +2

    These really are amazing tutorials, thank you for putting your time and effort into it! One question, What if I create one database and 3 different people are entering data each in their own computer, is it possible to later on merge the data coming from these 3 people so we have only one data base in the end? And if this is possible, how would that work with Customer ID Autonumber?

    • @599CD
      @599CD  10 ปีที่แล้ว +2

      damienro0 Your best bet would be to use a shared database on a LAN. I show how to do this in Access Expert 21: 599CD.com/XDPJRM
      If you are in different locations and you don't have Internet access, you could export and import the data into a master database, which I show in my Expert 23 class: 599CD.com/XLNQAX
      If those people are in different locations, but have Internet access, your best bet is to put the back-end tables on a web-based server, which I show in my Access Expert 24 class: 599CD.com/X1EDR8

  • @mrbohra
    @mrbohra 11 ปีที่แล้ว

    I got what i was looking for last one week. thanks

  • @tamaratalib2521
    @tamaratalib2521 5 ปีที่แล้ว

    Thnx for your useful videos. you have a great way for explaining Access Program

    • @599CD
      @599CD  3 ปีที่แล้ว

      My pleasure.

  • @potaewhero
    @potaewhero 5 ปีที่แล้ว

    wow I have learnt things I have wondered about before so it has kept me watching on to the next video

    • @599CD
      @599CD  3 ปีที่แล้ว

      My pleasure.

  • @madmacjr8503
    @madmacjr8503 8 ปีที่แล้ว

    These videos are fantastic and I'm learning so much from them, but I think my favorite part so far is the 100% straight-faced Space Balls reference just casually dropped while talking about the different considerations for number vs. text fields. I may have had to pause the video for a minute to finish laughing...

    • @599CD
      @599CD  3 ปีที่แล้ว

      What!? You went over my HELMET!? :)

  • @malharagu
    @malharagu 8 ปีที่แล้ว

    Simply, you are better than my professor.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Don't tell him that. :)

  • @mr-fu3zu
    @mr-fu3zu 3 ปีที่แล้ว +1

    Very informative and helpful .

    • @599CD
      @599CD  3 ปีที่แล้ว

      Glad you liked it

  • @guledsm
    @guledsm 7 ปีที่แล้ว

    Thanks. Very simple and very comprehensive.

    • @599CD
      @599CD  3 ปีที่แล้ว

      You are very welcome. Glad you enjoyed!

  • @AlastorTheNPDemon
    @AlastorTheNPDemon 9 ปีที่แล้ว +5

    I appreciate how this is taught, but my school lessons use a completely different lesson priority and pace; probably the reason I'm struggling. I wish my textbook and class were this thorough and methodical.

    • @599CD
      @599CD  2 ปีที่แล้ว

      My pleasure

  • @shuaibuabdulrahman9103
    @shuaibuabdulrahman9103 10 ปีที่แล้ว +2

    Awesome turtorial really thanks you so much for data base class may GOD Rewarded you aboundantly

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @dstimpy73
    @dstimpy73 10 ปีที่แล้ว

    Very helpful for my database class! Thanks!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @TubeSurferToo
    @TubeSurferToo 11 ปีที่แล้ว

    Excellent standards and conventions!

  • @barbaraparker760
    @barbaraparker760 8 ปีที่แล้ว

    This is an awesome "Tutorial"...Although, I have been using Access for years, there are some tips that I have never used.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks

  • @lxrdbxnz6678
    @lxrdbxnz6678 8 ปีที่แล้ว

    YOUR AN AWESOME TH-camR YET YOUR SORT OF UNDERATED, BUT IN FUTURE I CAN TELL YOUR GONNA GO WORLDWIDE BUDDY!

    • @599CD
      @599CD  3 ปีที่แล้ว +1

      THANKS!

  • @eliseperezalford2178
    @eliseperezalford2178 6 ปีที่แล้ว

    Very helpful. Wow - I'm following along while I create a database...

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks

  • @parislarose5775
    @parislarose5775 7 ปีที่แล้ว

    great point about text vs. number! I never considered that using excel.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Yeah, Excel doesn't force you to type your data.

  • @balagotrd
    @balagotrd 9 ปีที่แล้ว

    Awesome video tutorial. Thank you for sharing.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @DoubtAndWhy
    @DoubtAndWhy 9 ปีที่แล้ว

    Thanks for such a very good tutorial!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @caseyanderson752
    @caseyanderson752 7 ปีที่แล้ว

    great lessons so far and nice Spaceballs reference with 1-800-DRUIDIA

    • @599CD
      @599CD  3 ปีที่แล้ว

      What? You went over my HELMET?

  • @maimster4256
    @maimster4256 8 ปีที่แล้ว

    I just started, and finished level 1. I paid for level 2 and let's see how I go. So far I lovin it.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Glad you enjoy

  • @tomsaefke2901
    @tomsaefke2901 7 ปีที่แล้ว

    Very instructive. Thank you.

    • @599CD
      @599CD  3 ปีที่แล้ว

      You are very welcome. Glad you enjoyed!

  • @isoboyedan-obu2323
    @isoboyedan-obu2323 9 ปีที่แล้ว

    Thank you so much. This is a great help to me.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @thepongking
    @thepongking 7 ปีที่แล้ว

    Thank you so much for these videos!

    • @599CD
      @599CD  3 ปีที่แล้ว

      You're very welcome.

  • @prasadbm1978
    @prasadbm1978 8 ปีที่แล้ว

    Thanks for making it super easy ! ☺

    • @599CD
      @599CD  3 ปีที่แล้ว

      Welcome

  • @2001BornAgain
    @2001BornAgain 7 ปีที่แล้ว

    If I were running a non profit organization, would you recommend placing a "giving" value in the customer's information as it is a fluid number? Say for instance I have a member of a church that tithes but offers extra money for a food pantry. Would you create a field for tithing and a field for food pantry in this member's table or would they go into another table completely separate from the member info table?

    • @599CD
      @599CD  3 ปีที่แล้ว +1

      I'd use a separate table.

  • @AlanStewartMusic
    @AlanStewartMusic 7 ปีที่แล้ว +1

    Very helpful tutorials. thank you

    • @599CD
      @599CD  3 ปีที่แล้ว

      You are very welcome. Glad you enjoyed!

  • @chandlerczy
    @chandlerczy 11 ปีที่แล้ว

    Great video. Love it. Thank

  • @danielleludwigsen4753
    @danielleludwigsen4753 9 ปีที่แล้ว

    Do you talk about Access documents that are linked to Excel in one of your tutorials? It is not allowing me to make changes to my design view because it is a linked document. I'm just learning Access but I did a linked document so I could utilize all of the data I have already entered into excel. Thank you so much.

    • @599CD
      @599CD  9 ปีที่แล้ว +1

      +Danielle Ludwigsen I do cover this, however I strongly recommend IMPORTING the data into Access from Excel if it's something you're going to work with on a regular basis.

  • @pkpotate
    @pkpotate 9 ปีที่แล้ว +18

    1-800-druidia... dat spaceballs reference

    • @599CD
      @599CD  2 ปีที่แล้ว

      What!? You went over my HELMET!?

  • @Holabella
    @Holabella 10 ปีที่แล้ว

    Hi question for you --> You mentioned using a calculation requirement to determine the use of text vs. numbers on an integer input. Is it possible to then change the data type later (3 months after building your db) from text to number if you need to? Thx.

    • @599CD
      @599CD  10 ปีที่แล้ว

      Sure, you can change data types later. If you have any non-numeric values in that text field, they'll be lost when you change it to a number type. Also, you can convert text to number on the fly using functions like CINT() but that will slow things down.

  • @musarratzaidi685
    @musarratzaidi685 6 ปีที่แล้ว

    Good methodology to explaining the text

    • @599CD
      @599CD  3 ปีที่แล้ว

      My pleasure

  • @varunshetty7361
    @varunshetty7361 5 ปีที่แล้ว

    great video this helped me a lot thankyou !!!!

    • @599CD
      @599CD  3 ปีที่แล้ว

      You're welcome

  • @ferntiger5586
    @ferntiger5586 7 ปีที่แล้ว

    Thanks! It is easy to understand.

    • @599CD
      @599CD  3 ปีที่แล้ว

      Welcome

  • @beandavid3651
    @beandavid3651 8 ปีที่แล้ว +1

    I am trying to do this to teach English and I need to record my voice as I read words and sentences....how do I record voice and how would someone be able to hear it??? btw these are excellent videos...thank you!!!!

    • @599CD
      @599CD  2 ปีที่แล้ว

      You can record sound clips using whatever audio program you have. Then, don't save the clips in Access, just the file locations. 599cd.com/Images uses the same technique. Then you can use FollowHyperlink to play them. 599cd.com/FollowHyperlink

  • @stephenmcgettigan4053
    @stephenmcgettigan4053 6 ปีที่แล้ว

    Thanks for everything this is very helpful

    • @599CD
      @599CD  3 ปีที่แล้ว

      You're very welcome.

  • @RalphNgOfficial
    @RalphNgOfficial 10 ปีที่แล้ว +1

    great video, thanks for sharing

  • @DreamWorkDrive
    @DreamWorkDrive 9 ปีที่แล้ว

    thank you! Excellent tutorial.

    • @599CD
      @599CD  2 ปีที่แล้ว

      599cd.com/TimeSpent

  • @MM-fk2js
    @MM-fk2js 8 ปีที่แล้ว

    Thank you, great video!

    • @599CD
      @599CD  3 ปีที่แล้ว

      Welcome

  • @MrFriedgreentomatos
    @MrFriedgreentomatos 9 ปีที่แล้ว

    Great Tutorials, how do you spellcheck the fields (or entire table) please?

    • @599CD
      @599CD  2 ปีที่แล้ว

      F7 just like Word

  • @paulschneider6164
    @paulschneider6164 10 ปีที่แล้ว

    Excellent tutorial.

    • @599CD
      @599CD  ปีที่แล้ว

      thanks

  • @hussainali5047
    @hussainali5047 2 ปีที่แล้ว

    Loving it, Sir.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @shahidpervaiz6647
    @shahidpervaiz6647 7 ปีที่แล้ว

    Excellent training package

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thanks

  • @MostafaRaouf
    @MostafaRaouf 8 ปีที่แล้ว +1

    Thanks for your excellent lessons,
    i have big excel sheet contains like 120 columns ... its too much to do it ine by one ... how to copy or to export it to the table?

    • @MostafaRaouf
      @MostafaRaouf 8 ปีที่แล้ว

      i mean the head of columns ofcours...

    • @ipranjali
      @ipranjali 5 ปีที่แล้ว +1

      I know this is 3 years later but there's a way to import excel sheets, or just column headers. I won't go into details hoping you've already found the answer, but if you haven't, respond and I'll elaborate :)

    • @599CD
      @599CD  2 ปีที่แล้ว +1

      599cd.com/ImportData

  • @christiancudiamat581
    @christiancudiamat581 10 ปีที่แล้ว

    great tutorial for a beginner like me.

  • @sarahmiracle6508
    @sarahmiracle6508 10 ปีที่แล้ว

    Question -- I am creating a database to store a LOT of information about clients. More than just contact information, each client has a profile with household member information and living preferences. Would I create one table with the client contact information AND all the fields for their profile (would be around 40+ fields), OR would it be best to create a separate table for their extra profile information?

    • @599CD
      @599CD  10 ปีที่แล้ว +1

      Sarah Vowels There's no reason why you couldn't have one table with 40 fields in it. If you're talking about hundreds-of-thousands of records, however, you might want to make one table with the info you'll have on EVERYONE (name, address, phone, etc.) and then a second table for the details you only have one SOME of the clients (demographics, etc.). This will save space in your database, BUT I wouldn't worry about it unless you've got LOTS of data. I cover this concept when I talk about "extended customer info" in my Access Expert Level 4 class: 599cd.com/XLRZML

  • @Invincible544
    @Invincible544 10 ปีที่แล้ว

    Great job

  • @trwesthora
    @trwesthora 8 ปีที่แล้ว

    What lesson shows me how to add a drop down menu with pre-populated options to pick from? For example, "CustomerType" might have two options to choose from: "RE" or "Homeowner" and secondly, what lesson will show me how to have a table field populated by pointing to another table? For example, "field "ReferredBy" can be populated by choosing a person listed in the "ReferringPartner" table. Does that make sense?

    • @599CD
      @599CD  3 ปีที่แล้ว

      599cd.com/Combo

  • @shekuikallon7002
    @shekuikallon7002 4 ปีที่แล้ว +1

    Thanks very much

    • @599CD
      @599CD  4 ปีที่แล้ว

      You are welcome

  • @gprgprgpr
    @gprgprgpr 11 ปีที่แล้ว

    Thanks again!

  • @joysrayil5973
    @joysrayil5973 9 ปีที่แล้ว

    Excellent video

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @atulsuri680
    @atulsuri680 9 ปีที่แล้ว

    VERY NICELY EXPLAINED.KEEP IT UO.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Thanks

  • @babecakes323
    @babecakes323 8 ปีที่แล้ว

    Thanks for this very unique video. However I made a mistake while trying to save the Customer T name. I selected Customer B. So my question to you is; how do I change to Customer B to T??

    • @599CD
      @599CD  3 ปีที่แล้ว

      Rename it

  • @zakadread
    @zakadread 11 ปีที่แล้ว +1

    God bless u man

  • @muznjamal5807
    @muznjamal5807 9 ปีที่แล้ว

    thanks a lot it is very helpful.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome