Question: Create a database. Using Table Design, name the first Field as Name of State or Territory. Set this as the primary key and set the
Create a database.
Using Table Design, name the first Field as Name of State or Territory. Set this as the primary key and set the data type to short text. Name the second Field State Abbreviation. Set the data type to short text.
Switch to datasheet view. In column 1, type 50 state names, one per row. Add District of Columbia in this column. In column 2, type the state abbreviation for each state. District of Columbia has the abbreviation of D.C.
Check your spelling in the table.
Save the table with the name State Abbreviations.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
