While spreadsheets are great for listing data in columns and rows, and they're easy to search if you want to find a single record, they're less useful when you need to identify patterns or sets. If you used one to log your DVDs, for example, how long would it take you to extract a list of only those films lasting 100 minutes or less, already sorted with your favourites coming first? To run a query like that, you really need a database. Here, we'll show you how to do that with LibreOffice Base. We'll explain how to catalogue and search DVDs, but you can apply these instructions for anything you collect or gather information on, such as books, cars, recipes, TV shows or aeroplanes.
展开▼
机译:虽然电子表格非常适合在列和行中列出数据,并且如果您想查找单个记录,它们很容易搜索,但当您需要识别模式或集时,它们就不太有用了。例如,如果您使用一个来记录您的 DVD,您需要多长时间才能提取仅包含那些持续时间为 100 分钟或更短的电影的列表,并且已经按照您最喜欢的电影排在第一位?要运行这样的查询,您确实需要一个数据库。在这里,我们将向您展示如何使用 LibreOffice Base 做到这一点。我们将解释如何对 DVD 进行编目和搜索,但您可以将这些说明应用于您收集或收集的任何信息,例如书籍、汽车、食谱、电视节目或飞机。
展开▼