create database table

Provided you have the authority to do so, you can use the Create Table command.

Create Table XY
(CustomerId Int Not Null Primary Key,
CustomerName Char(50) Not Null,
CustomerContact Char(50),
CustomerAddress1 Char(50) Not Null,
CustomerAddress2 Char(50) Not Null,
CustomerAddress3 Char(50) Not Null,
CustomerAddress4 Char(50),
CustomerAddress5 Char(50))

Heres one that I create (using VB, so just remove all the quotes and &_ to get the line), which creates a primary key and a foreign key.

20 sqlStmt = "Create Table " & tblName2 & " (" & _
"PrjId Char(20) Not Null, " & _
"PrjDesc Char(100) Not Null, " & _
"PayRate Real Not Null, " & _
"CustomerId Int Not Null, " & _
"Constraint " & _
tblName2 & "PK Primary Key (PrjId), " & _
"Constraint " & _
tblName2 & "FK1 Foreign Key (CustomerId) References " & tblName1 & " (CustomerId))"

HTH