Question: The diagram was created without specifying data types for the attributes Before we can create the tables in Access , we need to specify both

 The diagram was created without specifying data types for the attributes

Before we can create the tables in Access , we need to

The diagram was created without specifying data types for the attributes Before we can create the tables in Access , we need to specify both the data type for each attribute and the field length for each that should be set in the Access tables , First set the data type and field size properties for the Supplie able . Because you will create the tables in an Access database , you will use he data types most consistent with Access . You will also be adjusting the field length found in parenthesis immediately after the data type . Click to select he suppliers entity , and in the Columns category set the Data Type properties for each attribute as follows 1 . SUPID TEXTTION SupCompany Name TEXT / 25 ) SupContactName TEXT/ 25 ) SupContact Title TEXTIZE SupAddress TEXT/20 ) Supcity TEXTIZO SupRegion TEXTIION Suppostalcode TEXTIIO ) SupCountry TEXT/ 20 ) 10 . Supphone TEXT IO ) SUPFOX TEXTIIO ) 12 . SupHomePage TEXT/ 25 ) ( See the illustration on the next page . PUDD y ME

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Law Questions!