×
英文
很抱歉,此文章目前沒有您所使用語言的版本。

Course summary: Design and build tables for a database (Access basics, part 1)

Concepts & terms

A relational database divides data into tables, each with one subject—just customer names in one table, just phone numbers in another.

Each table captures all the data needed for each subject, and each field (column) hold the smallest possible unit of data.

Each table has a primary key, a value that makes each record (row) unique.

Data usually has a parent-child relationship; a single name can be related to multiple orders. Parent tables have primary keys, child tables have foreign keys—values from the primary key shared as needed to link records in the child table to records in the parent table. Keys are linked by a relationship.

Create a new database

Start Access, select the type of database you want (desktop or App, blank or a template), enter a name, browse for a location, select Create.

Build tables

  1. Select Create > Table or Create > Table Design.

  2. Set data type, enter field names, set a primary key, and save the table.

Lookup list

When adding a field to a table, select Lookup & Relationship> I will type the values I want, and follow the wizard.

Calculated field

When adding a field to a table, select Calculated Field, then an option such as Text. Use the Expression Builder to create your expression.

See also

增進您的 Office 技巧
探索訓練
優先取得新功能
加入 Office 測試人員

這項資訊有幫助嗎?

感謝您的意見反應!

感謝您的意見反應! 我們將協助您與我們的其中一個 Office 支援專員連絡以深入了解您的意見。

×