Question

1. Create a table in MS Access to store information about weather observation Stations: -- No duplicate ID fields allowed

CREATE TABLE Station ( ID INTEGER PRIMARY KEY, CITY CHAR(20), STATE CHAR(2), LAT_N REAL, LONG_W REAL );

Populate the TABLE Station with a few rows (this can be done manually)

(13, 'Phoenix', 'AZ', 33, 112); (44, 'Denver', 'CO', 40, 105); (66, 'Caribou', 'ME', 47, 68);

ID	CITY	STATE	LAT_N	LONG_W
13	Phoenix	AZ	33	112
44	Denver	CO	40	105
66	Caribou	ME	47	68

Answer 1

Insert Queries to populate table station:

INSERT INTO Station(ID,CITY,STATE,LAT_N,LONG_W) VALUES (13, 'Phoenix', 'AZ', 33, 112)

INSERT INTO Station(ID,CITY,STATE,LAT_N,LONG_W) VALUES (44, 'Denver', 'CO', 40, 105)

INSERT INTO Station(ID,CITY,STATE,LAT_N,LONG_W) VALUES (66, 'Caribou', 'ME', 47, 68)