image.png

创建空白数据库

image.png

导出表

image.png

导入Excel表-追加方式

image.pngimage.png

导入Excel表-新表方式

image.pngimage.png

链接表

  1. <br />**链接表的作用,就像PowerQuery,当外部数据源变化时,Access中的表也会随之改变 **<br />![image.png](https://cdn.nlark.com/yuque/0/2021/png/720175/1640053426021-6eb979c6-7532-4947-9e78-a06f15db9619.png#clientId=u97cb9ae4-1f7f-4&crop=0&crop=0&crop=1&crop=1&from=paste&height=508&id=u03a32f6c&margin=%5Bobject%20Object%5D&name=image.png&originHeight=1016&originWidth=1468&originalType=binary&ratio=1&rotation=0&showTitle=false&size=589463&status=done&style=none&taskId=ua5dd44a3-1039-460f-bbe8-451bdc768a3&title=&width=734)<br />![image.png](https://cdn.nlark.com/yuque/0/2021/png/720175/1639797983438-37bcda82-303e-4b4c-b5b7-c53243dffbaf.png#clientId=u7403c961-9bbb-4&crop=0&crop=0&crop=1&crop=1&from=paste&height=451&id=u1b39ed8c&margin=%5Bobject%20Object%5D&name=image.png&originHeight=902&originWidth=938&originalType=binary&ratio=1&rotation=0&showTitle=false&size=373163&status=done&style=none&taskId=ufdf8f3b5-9544-48d7-baad-cc16afa948d&title=&width=469)<br />*带➡️的就是链接表,无法在链接表上更新,只能在原表更新<br />![image.png](https://cdn.nlark.com/yuque/0/2021/png/720175/1639797925940-a845e3b1-6c13-46aa-8c13-183920be0921.png#clientId=u7403c961-9bbb-4&crop=0&crop=0&crop=1&crop=1&from=paste&height=131&id=uce6ea5e9&margin=%5Bobject%20Object%5D&name=image.png&originHeight=262&originWidth=514&originalType=binary&ratio=1&rotation=0&showTitle=false&size=75455&status=done&style=none&taskId=u50718e58-fc41-44ec-a377-9ca9f24e813&title=&width=257)

复制表

image.png

表示图的基本操作

image.pngimage.png
和EXCEL一样的通配符,* ? #

表设计

image.png
image.png