excel如何创建数据库_在Excel中创建电影收藏数据库

excel如何创建数据库

For a simple database, Excel can do a pretty good job of organizing and reporting your data. This example shows a movie collection database in Excel, but you could set up something similar to keep track of books, sales orders, or almost anything else.

对于简单的数据库，Excel可以很好地组织和报告数据。 此示例显示了Excel中的电影收藏数据库，但您可以设置类似内容来跟踪书籍，销售订单或几乎所有其他内容。

In this database you can store movie data, then create a list of movies for a specific category or actor.

在此数据库中，您可以存储电影数据，然后为特定类别或演员创建电影列表。

数据输入表 (The Data Entry Sheet)

On the data entry sheet, named Movies List, there's a table with seven columns.

在名为Movies List的数据输入表上，有一个包含七列的表。

A unique ID number is entered for each movie, then the title, and other information about the movie.

为每个电影输入唯一的ID号，然后输入标题和有关该电影的其他信息。