How to Create a Database in Excel

Поделиться
HTML-код
  • Опубликовано: 20 авг 2024

Комментарии • 6

  • @saifmahmoodpersonel
    @saifmahmoodpersonel 12 дней назад +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  9 дней назад

      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 RUclips.
      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:
      ruclips.net/video/Ztg2671daCg/видео.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!