Access???????????

1

• Access???????????

???? ?????Excel????,???Access??????????????

2
??1??Access??????
Access??????????(DBMS)
??Access??? ??Access??
??Access ?????
??Access,????? ?????????????
??Access ???????
3
??2???????
??????

• ???????(??????????)
• ???
• ??????????????????
• ??????(???????????)

?????????????

• ?????????????
• ????????????
• ?????????????
• ??????????

• Access???????
• ?????????
• ???????
• ???????

???????????
???????

• ????????
• ????????????

?????
4
??3????

• Field Size??
• Format??
• Caption??
• Default Value??

??????

• ?????????????
• ?????????????
• ?????????????
• ???????
• ??????

????????
5
??4???????
????????

• ????????????
• ????????????

??????????

• ??????(???????????!?-?)
• ???????(??Betweenand????)
• ??????
• ????
• ???????

6
??4???????

• ?????
• ????
• ????
• ????

??????
7
??4???????

• ??????
• ??????
• ??????
• ?????
• ??IIF??

??????
8
??5????
9
??6??????
???Excel
??dBase??
???Access???
??????
??????
?????????
??Access??
???????
??????????
10
??8??????
??????
????? (?????? ????)
?????? ????????
?????? ?????
??????
????? ????
?????? ???????
11
??8????
?????????? ?????????? ???????? ??????
???????? ?????? ??????? ????????

12
??8????
???? ?????? ??????
????? ????,???? ?????????

13
??9 ???
????
?Access????????(????????????????????????????????)
???
???
????
14
??9 ???
???
??????????,??????????????,?????????????,???????
???????
?????? ???
?????????
15
??10Access VBA????
??Access VBA??Access??
5
??????
1
?????? ??????
4
??????
2
??VBA??
3
?????????
16
??11Access SQL????(SELECT??)
??WHERE??
??SELECT ????
SELECT?? ????
?????????????? ??IN?????BETWEEN?? ??LIKE?????IS
NULL??
??SELECT??????? ??SELECT??????? ??SELECT?????????
SELECT??
17
??11Access SQL????(SELECT????)

• WHERE ??????
• IN???
• Between...And???
• LIKE???
• ???????

18
??11Access SQL????( ?????? )
????
??????
?????? ??? ???
??GROUP BY?? ??HAVING??
19
??11Access SQL????(??????)

• GROUP BY??
• HAVING ??
• INNER JOIN??
• LEFT JOIN?RIGHT JOIN??
• Union????
• Distinct??

20
??12Access SQL????(????)
????
????????? ???????? ??TOP???
INSERT VALUES INSERTSELECT ??SELECT INTO?????
??DELETE?? ??????????
????
????
????
??????
21
??12Access SQL????(????)

• INSERT INTO????
• UPDATE????
• DELETE????

22
Access???????????