Access là gì? TẤT TẦN TẬT thông tin cơ bản về Access

Access l g? Cc chc nng chnh ca Access? Nhng lu v hng dn s dng Access? Hay Access l g trong tin hc 12? Trong thi i cng ngh 4.0 th y l nhng cu hi thng gp ca rt nhiu ngi. Bi vit di y ca Baiviethay.com s gip bn tm hiu r v cc chc nng chnh ca cng nh hng dn s dng ca Access, cng tm hiu nh!

nh ngha Access l g?

Access l g? Access chnh l t vit tt ca Microsoft Office Access (MS Access). Thc cht y chnh l phn mm qun l c s d liu do hng Microsoft nm gi bn quyn. Phn mm Access ny nm trong b Microsoft Office c ng dng nhiu trong cc my tnh ci h iu hnh Windows.

Access gip ngi dng lm c nhng phn mm qun l t n gin n nng cao. Hin nay Access tr thnh cng c hu ch gip cho cc nhn vin vn phng, cc k ton c th d dng hn trong vic qun l c s d liu. Ngoi ra Access cn cung cp cc cng c c th lp trnh x l giao din, to cc bo co v cc m lnh.

Nhn chung, Access rt d s dng, t nhng bn cha c kin thc v lp trnh. Nu cc bn mun tm hiu su hn ti u c nhng tnh nng bn trong th Access cng cung cp nhng cng c ty chnh theo ngi s dng.

Hng dn s dng Access

Phn mm Access c ng dng rng ri v cc c s d liu gip cho ngi dng lu tr v chnh sa d dng hn. Bn cnh vic nm c khi nim Access l g th bn cng cn tham kho cc bc lm quen vi phn mm Access nh sau:

To c s d liu

• Bc 1: Bn nhp chut vo tp tin (File) ri chn Mi (New). y cc c s d liu c cha trong cc dng thc khc nhau. Bi vy bn c th chn m mt c s d liu trng, chn mu c sn hoc c s d liu web trng.
• Bc 2: Tin hnh t tn cho d liu. Tn c t tng ng vi ni dung ca c s d liu . iu ny gip bn qun l v tm hiu d dng hn cc d liu khc nhau trong phn mm ny. Sau g tn tp tin vo hp thoi Tn Tp tin (File Name). Chn To (Create) to mt tp tin c s d liu mi.

Nhp d liu

• Bc 1: Bn phi xc nh cc cu trc ca d liu: Nu bn to d mi th cn to c s d liu trng th sp xp hp l. C cc loi nh dng d liu nh: kiu bng, kiu biu mu, kiu bo co, kiu truy vn.
• Bc 2: To bng u tin: Nu bn bt u dng d liu trng, n s t ng to ra bng trng. Theo cc bn nn bt u nhp vo bng theo cch nhp th cng hoc sao chp v dn ni dung. Cc d liu c in thnh tng ct ring bit, mi mt h s l mt hng ring bit.
• Bc 3: Nhp d liu khc: Nu bn mun nhp d liu t mt tp tin hay mt v tr c th, bn c th thit lp cho Access nhn cc thng tin v t nhp vo c s d liu. N gip bn c th chia s v ly thng tin t mt ti liu khc. Bn ch cn chn thc hin nh sau:
  • Chn tab D liu Ngoi (External Data).
  • Chn tp tin mun nhp
  • Chuyn ti v tr cha d liu
  • Xc nh v tr lu mi
• Bc 4: Thm mt ct khc: Nu bn mun lu cc h s khc nhau trn nhng c s d liu khc nhau. To cho d liu c mt hn.

Thit lp mi quan h gia cc bng

• Bc 1: Cn hiu c cc hot ng ca cc kha: Theo mi mt bng s c c mt mc ring. Trong bng c s mc nh, Access to ct ID tng s lng mi mc. Ct ny chnh l kha chnh. Bng cng c nhng kha ngoi. Bi vy n c th lin kt vi mt bng khc trong c s d liu, trong lin kt cha d liu ging nhau.
• Bc 2: Bn nhn chut chn tab Cng c C s d liu (Database Tools). Sau chn nt Lin h (Relationships) trong mc Lin h.
• Bc 3: Bn ko trng mun t lm kha ngoi. Th trng vo trong ci va to . Sau bn nhn chut vo To (Create) trn ca s xut hin to mi lin h gia cc trng. Khi s xut hin kt ni cc trng vi nhau. Tip bn chn mc Buc Tham chiu Ton vn (Enforce Referential Integrity) khi to lin h.

To mt Truy vn la chn tiu chun

• Bc 1: M cng c Thit k Truy vn (Query Design). Tip n chn tab To (Create) ri chn Thit k Truy vn.
• Bc 2: Chn bng: Tip n bn s thy xut hin Hin th Bng (The Show Table) s xut hin. Bn nhn chut vo bng cn chy truy vn n sau n s nhp chn ng (Close).
• Bc 3: Thm trng c to ra. Bn nhn chut vo ct truy vn. Sau cc trng s c thm vo bng thit k (Design).
• Bc 4: Thm tiu chun: Bn cng c th dng cc kiu tiu chun khc nhau.
• Bc 5: Nhn chn chy chng trnh (Run) xem kt qu. Nt Chy nm trong tab Thit k (Design). Kt qu Truy vn s c hin th trong ca s. Bn c th nhn phm Ctrl + S lu truy vn.

To v Dng Biu mu

• Bc 1: Chn bng cn to biu mu. Thng thng mi ngi s dng biu mu d dng s dng v quan st hn.
• Bc 2: Bn nhn chn nt Biu mu (Form) trong tab To (Create). Khi bn s to c mt biu mu t ng cc trng trong bng.
• Bc 3: iu hng biu mu mi. Bn nhn thy nt mi tn pha di cng s dng di chuyn gia cc h s. Cc trng s p dng bng cch ghi li d liu khi chuyn i gia chng. Bn cng c th dng nt ny trn cc cnh di chuyn t h s u tin ti h s cui cng.

To mt bo co

• Chn bng hoc truy vn.
• Nhp chn tab To (Create).
• Thit lp ngun cho bo co trng.
• Thm trng vo bo co.
• Thm nhm vo bo co.
• Lu v chia s bo co.

Cc chc nng chnh ca Access

Access l g? Chc hn bn hiu r qua phn gii thiu trn. Theo , Access c rt nhiu chc nng thun tin cho vic qun tr d liu. Rt ph hp vi cc vn phng. Cc chc nng chnh ca Access l:

• Chc nng thit k bng.
• Chc nng lu tr.
• Chc nng cp nht thng tin.
• Chc nng a kt qu v xut thng tin.
• Chc nng thit lp cc mi quan h gia cc bng vi nhau.

Mt s cu hi lin quan n Access

i tng nn s dng Access l ai?

Ai nn s dng Access? Vi nhng tnh nng c cp bn trn th Access c a vo s dng trong cc trng ph thng nhm gip cc em hc sinh c lm quen vi cng ngh thng tin. C th trong chnh l xy dng phn mm c th theo con ng cng ngh thng tin.Bn cnh , mt s cng ty cng s dng Access xy dng phn mm qun l ni b.

Access cng c la chn l chng trnh chnh thi chng ch tin hc nng cao ca b gio dc o to. Do vy m Access l chng trnh ph cp dnh cho tt c mi ngi lm vic hiu qu hn. Mt s trng i hc cng s dng Access lm mt trong nhng mn chnh cho cc khi ngnh kinh t, k ton

Access c kh khng?

Access l g trong tin hc 12? Vi chng trnh Tin hc Trung hc ph thng, Access c chia thnh 2 phn nh sau:

• Phn c bn: Nhn chung phn ny tng i cho ngi mi s dng v ch dng thao tc ko th nn tng i n gin v d lm. y l nhng truy vn n gin vi thng k, cch to form v lm bng bo co.
• Phn nng cao: y l phn phc tp hn, do vy cng kh nhn hn vi nhiu mt s bn. Phn nng cao xy dng vi nhng chc nng x l kh hn v nhng truy vn phc tp ly ra d liu. Bn cnh , nu mun xy dng mt chng trnh theo mun th bn cn phi bit v lp trnh. Trong Access th ngn ng lp trnh l VBA y l mt ngn ng c dng trong b office ca Microsoft.

Nh vy, bi vit trn y ca Baiviethay.com gip bn gii p c thc mc Access l g cng nh nhng ni dung lin quan. Hy vng vi nhng thng tin m chng ti cung cp gip bn trong qu trnh tm hiu ca bn thn. Mong rng cc bn nm r v Access l g v ng dng n thnh tho trong cng vic cng nh hc tp. Chc cc bn thnh cng!

Tu khoa: Access basic l g, Access switch l g, Access c bn, Access l g trc nghim, tm hiu Access l g

Theo Baiviethay.com