Create an Access 2007 table

Objective

Once you have finished designing the Access2007 table, you can begin creating the Access2007 table, which is to construct the fields in each table, define the data types for each field, and set the properties of the fields.

Access2007 Creating a table is divided into creating a new database and creating a table in an existing database. When you create a new database, a new table is created automatically. Creating a table in an existing database can be done in the following five ways:

(1) Create an empty table directly.

(2) Create a table using a template.

(3) Create a table using Design view.

(4) Import or link to a table from another data source, such as a Excel2007 workbook, a Word2007 document, a text file, or another database.

(5) Create a table from a SharePoint list.

First, create a new table in the new database

Example 1, create a "teaching management" database, and establish a "tie" table, which is structured as shown in table 1. Action steps are as follows:

(1) On the File menu, click the New command.

(2) In the right pane, in the File name text box, type the filename "Teaching management" and choose the saved path as "E/example".

(3) Click the Create button.

The new database opens, creating a new table named "Table 1" and opening it in Datasheet view.

(4) In Datasheet view, double-click the Add New Field column heading and enter the new field name "Name" in the table, as shown in Figure 1. A Add new field column is added to the right.

(5) Select the ID field column. On the Datasheet tab, in the Fields and Columns group, click the Rename button, and then enter the column heading, "ID."

Figure 1 Adding the "Fasten name" column heading

(6) In the Quick Access Toolbar, click the Save button.

(7) in the Open Save As dialog box, enter the name of the table "fasten", and then click the OK button, as shown in Figure 2.

Figure 2 Input Table name

Table 1 Department

When you have finished modifying the field headings, you can enter the field values directly. After you enter a field value, Access2007 automatically sets the data type and properties for the field. This approach is simple and quick, but there are drawbacks. Sometimes the field data type is not appropriate and the field size may be redundant. To do this you need to modify the data type and field properties of the field in Design view.