Access Learning Diary (II. Create Table)

xiaoxiao2021-03-05  23

a) The concept of the table:

i. Attributes of the table; the record of the table; the component of the table

II. Operation of records: projections and selection;

III. You can establish a connection between the table;

b) design principle

i. The function of the table should be single; (in line with paradigm)

Ii. Field unique;

Iii. Record uniqueness (there is no exactly the same record)

IV. Functional Correlation (does not contain unrelated properties)

v. Field irrepretelation: For a certain field of modification should not affect the data of other fields (solution is usually split)

c) Create a database (through template; create a table using the wizard; create a table with the table designer;)

转载请注明原文地址:https://www.9cbs.com/read-35356.html

New Post(0)