Geographical Data - Nyika, Maguta uye Mapurumende
Iyi Microsoft Access sample database inopa matafura ane mashoko munyika, maguta, uye mapuro enyika. Iyo inoshandiswa kuenzanisira mienzaniso yezvikamu zvakawanda pamusoro peZves Databases site uye inopawo muenzaniso wakanaka wevadzidzi, vashandi uye vamwe vari kudzidza Microsoft Access.
Dhiyabhorosi Tables
Dhiyabhorosi ine mafura matatu. Itafura yenyika ine minda inotevera:
- Zita renyika: zita renyika
- Komiti: pfupi pfupa refabheti rinoshandiswa kureva nyika. Iyi munda inoshumira seyiyo yekutanga yeTable tafura.
- Guta guru: zita remakurukota enyika
- Purovhinzi: ruwa rweguta guru renyika
- Nzvimbo: iyo nzvimbo yose yenyika
- Nhamba yevanhu: yehuwandu hwehuwandu hwenyika
Guta tafura rine minda inotevera:
- ID: a numeric identifier inoshandiswa seyiyo yekutanga yekona
- Zita reMuguta: zita reguta racho
- Nyika: yenyika yekodhi yeguta racho. Iyi munda iri kiyi yekunze kune Code Code munyika yetafura.
- Vagari: vanhu veguta racho
- Sirivha: iyo nzvimbo yeguta
- Latitude: rutivi rweguta
Dunhu rePurovhinzi rine minda inotevera:
- ID: a numeric identifier inoshandiswa seyiyo yekutanga yekona
- ProvinceName: zita renyika iyi
- Nyika: yenhamba yenyika yepurovhinzi. Iyi munda iri kiyi yekunze kune Code Code munyika yetafura.
- Nhamba yevanhu: vagari vepurovhinzi
- Nharaunda: iyo yose yenharaunda yacho
- Guta guru: guta guru renyika yacho
- CapProv: zita reruwa rwenharaunda umo kune guta guru. Pamusana pemamiriro akasiyana-siyana mune dzimwe nzvimbo, munda uyu unogona kusiyana kubva kuNyika yeName, kunyange zvazvo ichiwanzofanana.
Table Relationships
Itafura yehutano hwakarondedzerwa pamusoro apa inoratidzwa mumufananidzo wehukama unoratidzwa peji ino.
Kushandisa Database
Dhiyabhorosi iyi inowanikwa sekusunungura kwepachena pane iyi link: MONDIAL.accdb. Iyo faira inowanikwa mu Microsoft Access 2007 ACCDB mafomu .
Kutenda
Nhoroondo iri mune databasi ino inotorwa kubva muZVANDI, pamwe nemvumo.