How Do You Create A Table Using SQL In Microsoft Access?
Although, it may be simpler to create a table using design view in Microsoft Access, it’s useful to know how to create one using SQL, too. Here’s how. Open the SQL view window. Type “CREATE TABLE” and the name you want to give your new table. For example: CREATE TABLE customersTable. Press Enter. Next, type an opening parenthesis and press Enter. Type the name of a new column in your table and name of the type of data to be entered in that column. For example: firstName CHAR(20). “CHAR(20)” indicates that only 20 text characters or less can be entered in this column. Type a comma and press Enter. Add additional columns using the same format. Make sure you separate information for each column with a comma. However, the last column defined in your table shouldn’t have a comma after the data type. For example: ( salary Number, age Number, address Char(50) Type a closing parenthesis. The complete statement should look like this: CREATE TABLE customersTable ( salary Number, age Number, addr
