Shulou(Shulou.com)05/31 Report--

In order to solve the problem of how to create a table by inputting data in Access database, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

1. Open the database

First open the database you have created, such as the jwglMis database, or create a new database.

2. Open Datasheet view

In the jwglMis database window shown in the following figure, click the Table object. Then double-click the create Table by entering data option, and the Datasheet view pops up.

3. Named field

Double-click Field 1 in the Datasheet view, enter the desired field name: course number, and then modify the names of the following fields as course name, course opening semester, course opening Department, and credits. Delete redundant fields

4. Input data

Enter data sequentially in each field, or you can drag the separator of the table to change the width of the table.

5. Save the table

Click the Save button in the toolbar, and enter the table name course Information in the pop-up Save as dialog box, as shown in figure 4.43. Then click the OK button to save the data table.

6. Define the primary key

When you save the data table, the system automatically pops up the "whether to create a primary key" prompt dialog box. Click the Yes button, and the system automatically creates a primary key for the datasheet and displays the Datasheet view of the table. In this way, the course Information table is created successfully by entering data.

7. Modify the structure of the data table

When you create a data table by entering data, the structure of the data table does not necessarily meet the specified requirements, and you can open the "Design View" of the data table to make the necessary changes. Press to modify the structure of the course Information table, delete a field "number", reset the "course number" as the primary key, and modify the data type and field size of some fields.

The answer to the question about how to create a table by inputting data in the Access database is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.