Access database create a new table

How to create a data table in Access

1, open your access, and then click on the create option on the menu bar.2, in the create option, click on table design.3, this brings us to the table designer. We enter the name of the field in the field name column on the left, click the following button in the data type column, in the drop-down menu, select the number. 4, the same way we create the name field

1, open your access, and then click on the menu bar to create options.

2. In the create option, click on table design.

3, this brings us to the table designer. We enter the name of the field in this Field Name column on the left, click the following button in the Data Type column, and in the drop-down menu, select Numeric.

4, the same way we create a “name field” and set its data type to text.

5, and so all the fields are added, we click on the upper left corner of the view button.

6, in the drop-down menu, find the data table view, click it.

7, a pop-up prompt whether to save the table, we click Yes.

8, asked to enter the name of this data table, I entered the name as: student list.

9, finally define the primary key, we click Yes, so the system will automatically add a primary key.

access how to create a new table? In access2010 database in the new table method introduced

In access2010, the main methods to create a table? When we use to access, generally have to build a table, then, Access how to create a table? Here in this regard to speak briefly in the access2010 database to create a new table in several ways, I hope to help you!

Method 1:

1, open the access software, files and new are displayed in striking red, the page in the middle of the system default selection of an empty database, click on the right side of the page folder icon to set up a good path to save, and then click on the Create button to create a new database file.

2, in the new interface will appear in Table 1 of the editing interface. Right-click on the cell with a click to add, in the menu that appears, select Text, enter the name in the cell, the same way in the name of the cell to the right of the input age, in the age of the cell after the input class, in the class of the cell after the input gender.

3, in the cell below the name enter Zhang San, in the cell below the age enter 12, in the cell below the class enter 1, in the cell below the gender enter female. Complete the first record.

4, this method, the following cell also enter a series of data, complete the table data operations. If you want to delete a record, you can click on this record ID number in front of the gray box to select this record, and then press the right mouse button, in the menu that appears, select Delete Record. Complete the deletion operation.

5, click on the File tab, in the drop-down menu that appears click on Save, Save As dialog box will appear, in the table name below enter student. and then press the OK button.

Method 2: sql statement such as:

createtabletest

(idint,

namevarchar(10))

Method 3: graphical interface to create:

Step 1: double-click on the desktop Access 2010 icon to enter the

Step 2: Select a blank database in the upper left of the page, click to enter

Step 3: Select Enable Content and click

Step 4: Select Create in the tab, click to enter

Step 5: Select Table Design, click to enter

Step 6: Enter the contents of the table and click to save

Step 7: Select the upper right corner of the button and click Exit

Step 8: A dialog box pops up, select Yes

Step 9: Modify the table name and click OK. The table creation is done

ACCESS how to use CreatTable to create a table, where you can build?

ACCESS also has a place to execute SQL, but in the query window, you have to enter the second left under the “query”, create a new query, the automatic pop-up table all off, manually write SQL statements. You can then use

create

table

.

Recommended to use ASP, PHP and other program development language, in the code inside the use of

create

table

will be more convenient. The fully self-contained query tool is not so convenient, and a window can only execute one statement.