SMS221 Chapter Notes - Chapter 2: Foreign Key, Unique Key

89 views4 pages
30 Sep 2020
Department
Course

Document Summary

Creating a table by importing an existing table or table structure. State/province and zip/postal fields: fields can be renamed in datasheet view or design view. Modifying the structure of an imported table: renaming fields in design view, to match the design for the owner table, you need to rename the. State/province and zip/postal fields: fields can be renamed in datasheet view or design view, changing the data type for a field in design view, all of the fields in the patient table, except birth date, should be. Short text fields: the table structure you imported specifies the number data type for the phone field it should be short text, the data type can be changed in datasheet view or design view. Setting the default value property for a field: the default value property for a field specifies what value will appear, by default, for the field in each new record you add to a table.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions