ACCESS创建表的五种方法步骤如下:
1、Access数据库中建表的方法共有五种,分别是: 使用设计器创建表 ,通过输入数据创建表 ,使用向导创建表 ,导入表 ,链接表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd5fbdcac5e5fda81cb38db3d88?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、先定义表的结构,表的结构需要我们自己定义,如图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1c7098349592c11dfa8ecceaf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、Access数据库设置字段属性,设置每个字段的数据类型,字段名称等,如图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cf7b23eea7f6dcd100bba12bba?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、新建的Access数据的主键,Oracle数据库和MySQL数据一样,Access数据也有自己的主键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533faad9ad484a6d3fd1f41345b6f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、设置Access数据库的表达式生成器,给数据库中所有的表或查询中字段、名称、窗体、报表中的各种控件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/08f790529822720eb3c2a55075cb0a46f21fab08?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、点击保存按钮,保存我们刚刚新建的Access数据库,点击确认即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fae19e540d57ee3d6d54fbdafa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)