中文Access2000速成教程--1.2 使用“数据库向导”创建表
中文Access2000速成教程--1.2 使用“数据库向导”创建表
中文Access 2000提供了两种创建表的方法:创建用于输入数据的“空表”;使用其他数据源中已有的数据来创建表。使用“数据库向导”即可在建立数据库的操作中创建该数据库所需的全部表、窗体及报表。也许您会想到这与使用中文Visual FoxPro 6中的“项目管理器”相类似,其实它们的功能差别还是很明显的,这里的“数据库向导”能创建新的数据库,但不能将新表、窗体或报表添加到已有的数据库中。那么,上一节操作结束后就应该建立好了数据库中的各种表,只是各表中没有任何记录,如单击“主切换面板”中的“输入/查看客户”按钮(参见图7),屏幕上就将显示“客户”表,以及表中的记录,而且图8表明此时该表中没有任何数据记录。
图7单击这个按钮
在“客户”表中,中文Access 2000的“数据库向导”已经建立好了所需要的字段,并且允许您此后为这些字段输入记录,如果需要的话还能增加新的字段,删除多余的字段。
其实,图8所示的“客户”窗口是一个中文Access 2000专用于输入与浏览数据记录的窗口,本章下面将讲述专用于输入数据记录的操作与窗口,请按下列步骤进行操作:
图8输入数据记录
步骤一、将“员工工时与工资”数据库窗口置为当前窗体(单击它,或者按下键盘上的F11功能键即可),然后打开列表中的“对象”组,参见图9。
图9单击并打开这个组
注:“员工工时与工资”数据库窗口提供了一个工具栏,从中可以选择使用“设计”视图(参阅后面的内容),以及列表的方式。各列表方式与其它的Windows应用程序相同,它们是:“图标”与“列表”等。
步骤二、在分组列表中选定“表”后,连击右旁表列表框中的“客户”项,如图10所示。
图10连击“客户”表
步骤三、在“客户表”中输入数据记录。
由于在前面的输入/浏览窗口中已经输入了一行记录,所以进入“客户表”后将会看到一行已经存在的记录,此时可从“公司名称”列开始输入第二行记录,参见图11,“客户ID”字段表示的是编号,中文Access 2000能自动给出,您就不用管它了,但如果需要的话也可以输入一个特定的编号。
图11从此处开始输入新的记录行
注:若想修改表中的字段结构,去掉一些多余的字段,加入一些需要的字段后,再输入数据记录,可参阅后面的内容

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



InnoDB's full-text search capabilities are very powerful, which can significantly improve database query efficiency and ability to process large amounts of text data. 1) InnoDB implements full-text search through inverted indexing, supporting basic and advanced search queries. 2) Use MATCH and AGAINST keywords to search, support Boolean mode and phrase search. 3) Optimization methods include using word segmentation technology, periodic rebuilding of indexes and adjusting cache size to improve performance and accuracy.

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Full table scanning may be faster in MySQL than using indexes. Specific cases include: 1) the data volume is small; 2) when the query returns a large amount of data; 3) when the index column is not highly selective; 4) when the complex query. By analyzing query plans, optimizing indexes, avoiding over-index and regularly maintaining tables, you can make the best choices in practical applications.

Yes, MySQL can be installed on Windows 7, and although Microsoft has stopped supporting Windows 7, MySQL is still compatible with it. However, the following points should be noted during the installation process: Download the MySQL installer for Windows. Select the appropriate version of MySQL (community or enterprise). Select the appropriate installation directory and character set during the installation process. Set the root user password and keep it properly. Connect to the database for testing. Note the compatibility and security issues on Windows 7, and it is recommended to upgrade to a supported operating system.

The difference between clustered index and non-clustered index is: 1. Clustered index stores data rows in the index structure, which is suitable for querying by primary key and range. 2. The non-clustered index stores index key values and pointers to data rows, and is suitable for non-primary key column queries.

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.
