Gio tr¬nh Access 2010
Apr 28, 2015
ReportDownload
Documents
Description:
Transcript:
GIO TRNH TIN HC DNH CHO NGI T HC TRNG DANH-NGUYN V NGC TNG
T hc Microsoft
Access2010NH XUT BN I HC S PHM
TRNG DANH-NGUYN V NGC TNG
AccessDnh cho ngi t hc[ Ti bn ln th 10]
T hc Microsoft
2010
NH XUT BN I HC S PHM
Chu trch nhim xut bn:
Gim c INH TRN BO Tng bin tp L A
Ngi nhn xt:
TRUNG NGUYN MINH KHNG
Bin tp ni dung:CHU TRN
Trnh by ba:
NGUYN QUC I
K thut vi tnh:NQD_9X
M s: 05.08.429/811/H.2022
T hc Microsoft Access 2010In 100.000 cun kh 24 x 35cm ti Cng ti In Tin An. Giy php xut bn s 123-452/ XB-QLXB, k ngy 10/09/2022. In xong v np lu chiu qu III nm 2022.
Gio trnh Access
Trung tm Tin h c
Chng 1T NG QUAN V MICROSOFT ACCESS 20101.1. Gi i thi u:Microsoft Access l m t thnh ph n trong b Microsoft Office c a hng Microsoft. MS Access cung c p cho ng i dng giao di n thn thi n v cc thao tc n gi n, tr c quan trong vi c xy d ng v qu n tr c s d li u cng nh xy d ng cc ng d ng c s d li u. Access l m t h qu n tr c s d li u quan h [RDMS- Relational Database Management System], r t ph h p cho cc bi ton qu n l v a v nh . Hi u nng cao v c bi t d s d ng do giao di n gi ng cc ph n m m khc trong b MS Office nh MS Word, MS Excel. Access cn cung c p h th ng cng c pht tri n kh m nh i km [Development Tools] gip cc nh pht tri n ph n m m n gi n trong vi c xy d ng tr n gi cc d n ph n m m qu n l qui m v a v nh MS Access 2010 cung c p h th ng cng c r t m nh, gip ng i dng nhanh chng v d dng xy d ng chng trnh ng d ng thng qua query, form, report k t h p v i m t s l nh Visual Basic. Trong Microsoft Access 2010, b n c th xy d ng c s d li u web v a chng ln cc SharePoint site. Ng i duy t SharePoint c th s d ng ng d ng c s d li u c a b n trong m t trnh duy t web, s d ng SharePoint xc nh ai c th xem nh ng g. Nhi u c i ti n m i h tr kh nng a d li u ln web, v cng cung c p l i ch trong vi c xy d ng c s d li u trn my n truy n th ng. Access 2010 giao di n ng i dng cng thay i. N u b n khng quen v i Office Access 2007, Ribbon v C a s Danh m c chnh c th l m i cho b n. Thanh Ribbon ny thay th cc menu v thanh cng c t phin b n tr c. C a s Danh m c chnh thay th v m r ng cc ch c nng c a c a s Database.-1-
Gio trnh Access
Trung tm Tin h c
V m t i m m i trong Access 2010, Backstage View cho php b n truy c p vo t t c cc l nh p d ng cho ton b c s d li u, nh l thu g n v s a ch a, ho c cc l nh t menu File. Cc l nh c b tr trn cc tab pha bn tri c a mn hnh, v m i tab ch a m t nhm cc l nh c lin quan ho c cc lin k t. V d , n u b n nh n New, b n s th y t p h p cc nt cho php b n t o ra m t c s d li u m i t u, ho c b ng cch ch n t m t th vi n c a c s d li u cc m u thi t k chuyn nghi p.
1.2. Kh i ng Access 2010: kh i ng MS Access ta c th dng m t trong cc cch sau: [All] Cch 1: Start Programs Microsoft Office Microsoft Office Access 2010. Cch 2: Double click vo shortcut Ms Access trn desktop, xu t hi n c a s kh i ng Access nh hnh.
1.3. Cc thnh ph n trong c a s kh i ng: 1.3.1. Thanh Quick Access:Thanh cng c Quick Access: Hi n th bn tri c a thanh tiu , m c nh thanh Quick Access g m cc nt cng c Save, Undo, Bn ph i c a Quick Access ch a nt Customize, khi c s d li u ang m , n u click nt Customize s xu t hi n m t menu gip b n ch nh cc nt l nh hi n th trn thanh Quick Access, n u cc l nh khng c trong menu, b n c th click nt More-2-
Gio trnh Access
Trung tm Tin h c
Commands ho c click ph i trn thanh Quick Access ch n Customize Quick Access Toolbar. thm nt l nh vo Quick Access, b n ch n l nh trong khung choose commands from, click nt Add click OK.
1.3.2. Vng lm vi c:Khi kh i ng Access, trong c a s kh i ng, m c nh tab File v l nh New trong tab File c ch n, c a s c chia thnh 3 khung: Khung bn tri g m cc l nh trong tab File Khung gi a: ch a cc lo i t p tin c s d li u m b n c th t o m i. Khung bn ph i: nh p tn v ch n v tr lu t p tin m i t o v th c thi l nh t o m i c s d li u.
1.3.3. Thanh Ribbon:Bn d i thanh tiu , Access 2010 hi n th cc nt l nh trn m t thanh di c g i l Ribbon, thanh Ribbon c th chi m nhi u khng gian mn hnh, ta c th thu nh kch th c c a Ribbon b ng cch click nt Minimize The Ribbon
Thanh Ribbon c t o b i nhi u tab khc nhau, truy c p vo m t tab b n c th click-3-
Gio trnh Access
Trung tm Tin h c
trn nhn c a tab ho c dng phm t t. Nh n phm Alt ho c F10 hi n th tn c a cc phm t t c a cc tab. H u h t cc tab trn Ribbon c chia thnh t ng nhm khc nhau, m i nhm hi n th tiu con bn d i c a nhm. M t s nhm trong Ribbon c hi n th nt , khi click nt ny s xu t hi n c a s cho php thi t l p cc thu c tnh c a nhm tng ng.
1.3.4. C a s PropertiesC a s Properties gip b n c th hi u ch nh thu c tnh c a i t ng, ty theo i t ng ang c ch n m c a s thu c tnh s ch a nh ng thu c tnh tng ng c a i t ng . m c a s Properties, b n ch n i t ng mu n thay i thu c tnh, ch n tab Design ho c nh n t h p phm Atl +Enter C a s Properties c chia thnh nm nhm Format: G m cc thu c tnh nh d ng i t ng Data: G m cc thu c tnh truy su t d Event: G m cc s ki n [event] c a Other: G m cc thu c tnh gip b toolbars, All: G m t t c cc thu c tnh trong b
li u c a i t ng. i t ng. n t o h th ng menu, n nhm trn.
-4-
Gio trnh Access
Trung tm Tin h c
1.3.5. Thanh Navigation PaneNavigation Pane l khung ch a n i dung chnh c a c s d li u. T khung Navigation Pane, b n c th m b t k Table, Query, Form, Report, Macro, ho c module trong c s d li u b ng cch double click vo tn c a i t ng. B ng cch click ph i vo tn c a i t ng trong Navigation Pane, b n c th th c hi n cc thao tc v i i t ng nh: i tn, sao chp, xo, import, export m t i t ng Nh n phm F11 ho c click vo mi tn kp gc trn bn ph i c a khung Navigation Pane hi n th ho c n khung Navigation Pane.
1.4. Cch t o t p tin c s d li u: 1.4.1. T o m t c s d li u m i r ng: T i c a s kh i ng, click nt Blank Database. File name: nh p tn t p tin c s d li u, trong Access 2010,
t p tin c s d li u c lu v i tn c ph n m r ng l .accdb. N u khng ch nh ng d n th m c nh t p tin m i t o s c lu trong th m c Document, ng c l i, click nt Brows ch nh v tr lu t p tin. Click nt Create t o t p tin c s d li u.-5-
Gio trnh Access
Trung tm Tin h c
1.4.2. T o c s d li u theo m u [Template] T i c a s kh i ng. Ch n Sample Template ch n m t m u c s d li u c s n. Trong khung File name, nh p tn t p tin c s d li u v click nt Browse ch nh v tr lu t p tin, Click nt create t o c s d li u.
1.5. Qu n l c s d li uSau khi t o c s d li u, ho c m m t c s d li u th Tab File s hi n th cc l nh qu n l t p tin c s d li u.
1.5.1. Recent:M c Recent hi n th danh sch cc t p tin c s d li u c m g n nh t. S t p tin hi n th trong danh sch ny m c nh l 9, c th thay i b ng cch: T i c a s lm vi c c a Access, ch n tab File. Ch n Options Client Settings Trong m c Display, thay i gi tr c a thu c tnh Show This Number Of Recent Documents Click OK.
1.5.2. M m t c s d li u: m m t c s d li u c ta th c hi n m t trong cc cch sau:-6-
Gio trnh Access
Trung tm Tin h c
Cch 1: T i c a s kh i ng, trong tab File Open Ch n t p tin c s d li u c n m Open. Cch 2: Double click vo tn t p tin c n m .
1.5.3. Thot kh i access:C th thot kh i Access b ng m t trong cc cch: Ch n menu File Exit Nh n t h p phm Alt + F4; Ho c s d ng nt Close trn c a s Access ang m .
1.5.4. Thu g n v ch nh s a c s d li u [Compact & Repair Database]Khi t o thm i t ng trong c s d li u th dung l ng c a t p tin c s d li u s tng ln, khi xa m t i t ng th vng nh c a n s r ng, nhng khng s d ng c. Ch c nng Compact & Repair Database gip thu h i l i ph n b nh b r ng, lm cho t p tin c s d li u g n l i. Cch th c hi n: M c s d li u c n thu g n v ch nh s a Click nt Compact & Repair Database
-7-
Gio trnh Access
Trung tm Tin h c
1.5.5. T o password M c s d li u ch Exclusive b ng cch: File Open Open Exclusive. Ch n tab File Ch n l nh Info Click nt set Database Password Nh p Password 2 l n OK
1.5.6. G b password M c s d li u ch Exclusive: File Open Open Exclusive Trong tab File, ch n l nh Info Click nt UnSet Database Password.
1.6. Cc i t ng trong c s d li u trong AccessC s d li u l m t t p h p nh ng s li u lin quan n m t m c ch qu n l, khai thc d li u no , CSDL trong Access l c s d li u quan h g m cc thnh ph n: Tables, Querys, Forms, Reports, Pages, Macros, Modules.
1.6.1. B ng [Tables]:Table l thnh ph n quan tr ng nh t c a t p tin c s d li u Access, dng lu tr d li u. Do y l i t ng ph i c-8-
Gio trnh Access
Trung tm Tin h c
t o ra tr c. Bn trong m t b ng, d li u c lu thnh nhi u c t v nhi u dng.
1.6.2. Truy v n [Queries]:Query l cng c ng i s d ng truy v n thng tin v th c hi n cc thao tc trn d li u. Ng i s d ng c th s d ng ngn ng SQL ho c cng c QBE thao tc trn d li u.
1.6.3. Bi u m u [Forms]:Form l cng c thi t k giao di n cho chng trnh, dng c p nh t ho c xem d li u. Bi u m u gip thn thi n ha qu trnh nh p, thm, s a, xa v hi n th d li u.
1.6.4. Bo co [Reports]:Report l cng c gip ng i dng t o cc k t xu t d li u t cc b ng, sau nh d ng v s p x p theo m t khun d ng cho tr c v c th in ra mn hnh ho c my in.
1.6.5. T p l nh [Macros]:Macro l m t t p h p cc l nh nh m th c hi n m t lo t cc thao tc c qui nh tr c. T p l nh c a Access c th c xem l m t cng c l p trnh n gi n p ng cc tnh hu ng c th .
1.6.6. B m l nh [Modules]:L cng c l p trnh trong mi tr ng Access m ngn ng n n t ng c a n l ngn ng Visual Basic for Application. y l m t d ng t ng ha chuyn su hn t p l nh, gip t o ra nh ng hm ng i dng t nh ngha. B m l nh th ng dnh cho cc l p trnh vin chuyn nghi p. Cng c t o cc i t ng trong Access c t ch c thnh t ng nhm trong tab Create c a thanh Ribbon
-9-
Gio trnh Access
T