How to Create a Database in Excel

Поділитися
Вставка
  • Опубліковано 27 сер 2024

КОМЕНТАРІ • 6

  • @saifmahmoodpersonel
    @saifmahmoodpersonel 18 днів тому +1

    hello mam ,
    can you please tell me, how you create this video for youtube
    or which softwear you use to create or edit videos for youtube.
    and thanks for your valuable videos.

    • @exceldemy2006
      @exceldemy2006  16 днів тому

      Hello @saifmahmoodpersonel,
      Thank you so much for your kind words and support! I'm thrilled to hear that you find our videos valuable. It's great to hear that you have an interest in making videos for UA-cam.
      creating and editing videos involves a few different steps, including screen recording, editing, and adding enhancements. There are various tools available that can help with these tasks. Thanks again for watching, and feel free to ask more questions! Happy learning!
      Regards
      ExcelDemy

  • @kotso28
    @kotso28 3 місяці тому +1

    Links to create both SEARCHABLE and RELATIONAL databases?

    • @exceldemy2006
      @exceldemy2006  3 місяці тому

      Hello @kotso28,
      Here are the links to create a searchable and relational database.
      To create a searchable database follow this article:
      www.exceldemy.com/how-to-create-a-database-in-excel/#searchable
      To create a relational database follow the article given below:
      www.exceldemy.com/how-to-create-a-database-in-excel/#relational
      You also can watch this video:
      ua-cam.com/video/Ztg2671daCg/v-deo.htmlsi=NCMYMU6sTU7hX2YS
      Regards
      ExcelDemy

  • @edimathomas-cr4km
    @edimathomas-cr4km Рік тому +2

    This is not the same as an actual database you would create in SQL or Microsoft Access. This is just regular Excel tables turned to Pivot Tables. Not the same thing.

    • @exceldemy2006
      @exceldemy2006  Рік тому +2

      Hi there! Thanks for sharing your thoughts. You're right; Excel Pivot Tables are great for ad-hoc data analysis and quick visualizations. In contrast, SQL databases and Microsoft Access are better suited for scalable, long-term data management.
      Both have their strengths and weaknesses. Ultimately, it's essential to choose the right tool based on the task at hand.
      Regards,
      Exceldemy Team!