How do you you create table in M.S. Access?

Answer 1

You can create a table in Microsoft Access in two ways.

Creating a table using the Access interface

In Microsoft Access, go to the Create tab at the top of the screen. You will see the "ribbon" change. ( The ribbon is the horizontal bar with all the buttons at the top of the screen). On the ribbon you now have a Table button. If you press this a new table is created. Your new table will appear in the list on the left of your screen and have a default name of "Table1". You can change this name when you save your new table.

The next step would be to add fields to your table. This is best done in design view. In order to access design view, right click the name of your table in the list on the left and choose Design view from the menu that appears.

In design view, you can add fields and decide what data type (text, number, date, etc) they should have. Also, you can set field properties like input masks and validation rules at the bottom of the screen.

Creating a table using SQL

You can also create a table using the Structured Query Language (SQL)., but it is more complicated. SQL is a language that was developed to interact with databases.

The following example script uses the CREATE statement to create a contacts table.

CREATE TABLE contacts

(

contact_id int,

firestname varchar(255),

lastname varchar(255),

address varchar(255),

city varchar(255),

CONSTRAINT pk_contactid PRIMARY KEY (contact_id)

)

In order to run this query and create the table, once again go to the create tab.

• On the ribbon of the create tab, choose Query Design.
• The window show table will be shown. Close this window.
• Now, on the left most part of the ribbon, click the SQL View button and select SQL View from the options that appear.
• Now the main window changes into a editable area where you can copy your query into. Copy/paste the query I typed above into this area.
• Now, in order to save the query press the key combination CTRL + S. This will bring up the Save as dialog box asking you to name your table. Name your table and press OK in the Save as dialog box.
• Now, your query will appear in the list on the left side of the screen. Select it and press the Run button (the one with the large, red exlamation mark) on the ribbon.
• Now your table will be created and will appear in the list on the left.

Answer 2

1. Click where you want to create a table.
2. Click Insert Table on the Standard toolbar.
3. Drag to select the number of rows and columns you want.

Answer 3

create table table name(id in,name varchar (20),city varchar(20))