MS Access. MS Access database. MS Access 2007

MS Access - abokin ciniki-uwar garke da zumunci database management system (RDBMS) daga Microsoft. Da zumunci yana nufin cewa yana dogara ne a kan allunan. Mun yi la'akari da wannan tsarin a more daki-daki.

Mene ne wani zumunci database?

A da zumunci database kunshi wani sa na Tables, tsakanin wanda ya gina dangantakar ko sadarwa. Database - wani harsashi cewa ba ka damar ƙirƙirar da amfani da databases MS Access.

Ka yi la'akari da amfani ko rashin amfani da DBMS.

Abũbuwan amfãni daga DBMS Microsorf Access

• Simple kuma da ilhama ke dubawa. Samun aiki tare da wannan database iya zama, ba tare da wani musamman da dabarun. Bugu da kari, da novice taimakon yawa reference books, online da kuma offline darussa.
• MS Access database ne da aka sani, kuma Popular a tebur PC. Wannan yana nufin cewa za ka iya ko da yaushe nemi taimako daga wani aboki, an amfani da wannan database ga shawara, kazalika da yin aiki tare da daya database a kan wani cibiyar sadarwa.
• Kusan marasa iyaka yiwuwa don fitarwa data: data daga allunan da dannawa daya daga cikin linzamin kwamfuta za a iya canjawa wuri zuwa Excel, Word, fitarwa zuwa XML, buga wa PDF, ba a ma maganar gaskiya cewa babu matsaloli don motsawa zaba abubuwa zuwa wani database.
• Low farashin. Idan ka saya MS Access a matsayin wani ɓangare na da cikakken Microsoft Office kunshin, kamar yadda idan aka kwatanta da sauran biya databases, farashin zai kasance mai tsananin kyau.
• A fadi da zaɓi na zanen domin gina siffofin, rahotanni da queries, za ka iya amfani da su domin tace bayanai da kuma nuna su a wani m hanya.
• Dama zuwa shigo data, idan kana da tabular bayanai ta amfani da wata kalma processor MS Word, ko MS Excel processor, ka yi amfani da maye zai canja wurin su a cikin database sauƙi. Shigo da, a cikin Bugu da kari, za a iya yi daga wani sauki rubutu daftarin aiki daga wani XML daftarin aiki, kazalika da database fayiloli halitta a cikin wasu bayanai (kamar dBASE, PARADOX).
• Ability don ƙirƙirar wata kalmar sirri don database.
• Gina-a high-matakin harshen VBA.
• Da ikon zuwa rikodin macros.
• SQL edita.

Domin shirye-shirye iya zaɓar wani gagarumin amfani: core Access jet 4 saka a cikin Microsoft Tsarukan aiki, da suka fara da Windows-tushen 98. Wannan yana nufin cewa aikace-aikace amfani da database halitta a cikin Access, zaka iya kawo a kowace kwamfuta a kan Windows. Yana zai yi aiki ba tare da shigar da DBMS kanta. A wani matsanancin hali, kawai bukatar ka shigar Runtime - version, wanda zai iya zama gaba daya free download daga Microsoft website.

Kamar yadda ka gani, da mutuncinsu, da DBMS MS Access ne akwai. Amma duk da abũbuwan amfãni iya outweigh quite gagarumin disadvantages. Bari mu auna su.

Disadvantages na DBMS Microsoft Access

• MS Access nufin da fayil-uwar garke database. Wannan yana nufin cewa duk data aka sarrafa kai tsaye a kan abokin ciniki kwamfuta mai amfani. The uwar garke wani ɓangare na wani retrieves da bayanai da kuma watsa su a kan bukatar. Wannan take kaiwa zuwa gaskiyar cewa a kan wani gida cibiyar sadarwa ply manyan data gudana, da kuma tare da babban yawan masu amfani da aiki tare da database, shi yana iya zama cibiyar sadarwa cunkoso. The classic fayil-uwar garke gine ne ko da yaushe entails low yawan aiki a lokacin da wani babban yawan masu amfani. A MS Access 2010 version wannan batu ne partially warware.
• Saboda rashin isassar data kariya kayan aikin. A gaskiya, kawai wata kalmar sirri da aka yi amfani da a kan tushen da bayanai da kuma mai amfani da kalmar sirri. Domin da gogaggen gwani ba matsayi wani ƙunci a cire wannan kariya.
• Multiplayer yanayin mai yiwuwa ne kawai a wani wucin gadi cibiyar sadarwa ko a cikin wani cibiyar sadarwa fayil uwar garke.
• Don samar da al'ada ke dubawa ake bukata don jawo hankalin masu shirye-shirye.
• Edita SQL queries ne m, shi ne m don amfani.
• Wannan database ba free.
• MS Access kurkuku karkashin Windows tsarukan. Don kokarin amfani da data halitta a cikin database zuwa wasu tsarukan (misali, Linux), da kyawawan tricky. Kawai canja wurin bayanai zuwa wani database.

Da zarar mu dubi ribobi da fursunoni na MS Access, da misali daga 2007 version zai bayar da wasu sauri umarnin a kan yiwuwa na wannan database.

samar da allunan

Babu wani abu sauki fiye don ƙirƙirar sabuwar tebur ta amfani da MS Access 2007:

1. "Creation," je shafin bayan bude wani database.
2. Click a kan icon "Table", shi ne na farko a kan hagu.
3. Kafin mu a gani misali na tebur tare da misali sunan "Table 1" da kuma auto-incrementing filin "Code".
4. Za ka iya fara shigar da bayanai zuwa na biyu shafi. Bayan shigar da line, dole ne ka latsa Shigar da key. A shafi ne ta atomatik sake masa suna zuwa "Field 1," "Code" filin zai dauki darajar raka'a zai zama samuwa shigar data a layin gaba.
5. Don sake suna a shafi, kawai danna kan shi tare da linzamin kwamfuta sau biyu. Yana da kyawawa don saka da shafi sunayen da wani sarari!
6. Builder Tables a Access 2007, sosai mai kaifin. Yana da daraja a gare ku a cikin na farko jere daga cikin sabon tebur don shigar da filin darajar da irin "Kwanan", kamar yadda a cikin wadannan line a cikin wannan shafi za ka ta atomatik a gayyace su yi amfani da kalanda.
7. Don kammala halittar tebur shi dole ne a ajiye ta danna kan dace icon ko key hade CTRL + S.

Mutane da yawa masu amfani more dace don zuwa tsarin mulki na "Designer" don ƙarin ilhama aiki a kan filayen da tebur, saboda a wannan yanayin, za ka iya saka da iri filayen, hani a kan dabi'u. A wannan yanayin, za ka iya tafiya a kowane lokaci da aiki tare da tebur, kawai latsa m button a kan panel.

Samar da wata tambaya

Ka yi la'akari da yadda za ka ƙirƙiri queries a MS Access. A shekara ta 2007 za ta haifar da wani sauki tambaya a Design view:

1. A cikin "Menu" ayyuka, danna kan "Create" button "Tambaya Designer" tab.
2. A nan za ka nan da nan ga wata taga selection Tables. Click a kan kowane tebur daga wanda data dole ne a zabi. Ya kamata a tuna da cewa zabi za ka iya gudanar da kawai idan fiye da daya tebur za a iya Azancin nasaba da juna ta wani filin.
3. Idan ka zabi fiye da daya tebur, dole ne ka gina wani bond tsakanin su, mikawa da layin da linzamin kwamfuta daga daya filin a daya tebur zuwa wani filin da ake nasaba da sauran.
4. Yanzu danna sau biyu a filin daga kowane tebur cewa kana so ka gani sakamakon.
5. A cikin menu bar a kan "Design" tab, click a kan babban alamar mamaki. Kafin ka bayyana a tabular samar da sakamakon da selection.

Wannan ne janar dabara domin samar da queries. Don ƙarin hadaddun queries, ga Help for da shirin, ko amfani da musamman AIDS.

Wani lokaci ko da wani novice mai amfani da son su gabatar da bayanan a cikin wani more amfani format fiye da wani sauki tebur. Sa'an nan, ya zo da taimakon MS Access kayan aiki - "Forms".

fom Wizard

A cikin Access 2007 misali, ka yi la'akari da yadda za a yi amfani da tsari Wizard:

1. A cikin "Create" tab, karkashin "Forms" je "Form Wizard" ta cikin "Wasu sigogin".
2. Zabi daga drop-saukar list, a tebur ko tambaya ga wanda ka so su haifar da wani gani form.
3. Yi amfani da ">" da ">>" na wani block canja wuri "Rasu filayen" kwanakin ginshiƙai a cikin block "zaba filayen" by daya ko a lokaci daya, bi da bi. Click a kan "Next" button.
4. Zabi bayyanar da tsari ta amfani da canji.
5. Next, zaɓi form style, kuma za ka iya danna "Gama" button. Ga your tebur ko query bayanai a wani ban sha'awa format.

Don ƙirƙirar mafi hadaddun siffofi dole ne amfani da ya dace constructor.

Bayan dauke da wadannan umarnin, za mu iya cewa MS Access - wannan shi ne mai kyau damar ga wani kananan kudin. Friendly dubawa, da na ruwan dare na saka support injiniyoyi da kuma sana'a - duk wannan ya sa shi ya fi sauƙi tsara wani database da kuma aiki da shi.