Si loo falanqeeyo oo loo maareeyo xogta si hufan, Microsoft Office Access wuxuu u kaydiyaa sidii ururinta miisaska la xidhiidha. Markaa, waxaad u arki kartaa xogta Access sida ururinta shaxanka la xidhiidha. Habka dhismaha miisaska leh Naqshadeeye Miiska^{(Table Designer )} ee Helitaanka^{( Access)} ma aha mid adag.

Sida loo abuuro Shaxan Naqshadeeye Miiska^{(Table Designer)} ee Helitaanka^(Access)

Waxaad u arki kartaa xogta Access sida ururinta miisaska la xidhiidha. Jadwalka Helitaanka^(Access) waa liis mawduucyo ku salaysan oo saf iyo tiirar ah. Saf kasta oo miiska ku jira waxaa loo yaqaan rikoor halka tiir kasta loo yaqaan beer. Ma jiri karaan laba goobood oo magac isku mid ah leh. Qiime kasta oo goobta lagu soo galiyo waxa uu ka dhigan yahay hal qayb oo xog ah.

1. Geli magaca goobta iyo nooca xogta
2. U deji furaha aasaasiga ah ee miiska

Markaad abuurto miis leh Nakhshad Miis^{(Table Design)} , waxaad noqon kartaa mid aad uga baaraandegaya qaabaynta xogtaada.

1] Geli^(Enter) magaca goobta iyo nooca xogta

Si aad u dhisto Shaxda Naqshadeeye Miiska^{(Table Designer)} , dhagsii tab 'Abuur'^(Create’) ee ribbon ka dibna dooro badhanka ' Nashqada Shaxda^{(Table Design)} ' ee hoos timaada kooxda Shaxanka.

Gelida^(Access) waxay ku tusi doontaa daaqad bannaan oo miiska ' ^(Table)Naqshadda^(Design) '.

Jadwalka cusub, goobta kowaad, geli magaca goobta iyo nooca xogta.

Akhri^(Read) : Sida Loo Sameeyo, Looga Tafatiro, Loona Tirtiri karo Xiriirka Shaxda Gudaha Helitaanka Microsoft^{(How to Create, Edit and Delete a Table Relationship in Microsoft Access)} .

2] U deji^(Set) furaha aasaasiga ah ee miiska

Si aad u dejiso furaha aasaasiga ah ee miiska, dooro unugga ' Magaca goobta^{(Field Name)} ' ee goobta ku habboon ka dibna dooro ' Furaha Koowaad^{(Primary Key)} '.

Tusiyaha Furaha Aasaasiga^{(Primary Key)} ah wuxuu u muuqdaa sidii badhan fallaadho dhinaca bidix ee magaca goobta. Waxaad bedeli kartaa furaha aasaasiga ah wakhti kasta si kastaba ha ahaatee, waxaa jira hal fure oo kaliya oo miis kasta ah.

Marka la dhammeeyo, u gudub tab ' File ', dhagsii, dooro ' Save ' option oo magac miiska.

Waxaad u beddeli kartaa mid ka mid ah ' View Design^{(Design View)} 'ama' Viewsheet View^{(Datasheet View)} ' miis kasta oo kaydsan.

Aragtida Naqshadeynta^{(Design View)} ' waxay u ogolaataa isticmaalayaasha inay abuuraan jadwal galitaanka iyagoo ku teebaya^(Access) magacyada goobta safka 'Magaca goobta '. ^(Field)Waa inaad hubisaa in magacyada goobta^(Field) ku dhexyaalla shaxda ay yihiin kuwo gaar ah oo kooban, haddana sharraxaya.

Xigasho^(Source) – Xafiiska Support.com^{(Office Support.com)}

How to create Tables with Table Designer in Access

To analyze and manage data more efficiently, Microsoft Office Access stores it as a collection of related tables. Sо, you cаn view an Access database as a collection of related tables. The process of bυilding tables with Table Designer in Access is not that difficult.

How to create Tables with Table Designer in Access

You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns. Each row in a table is called a record while every column is called a field. There can be no two fields having the same name. Any value entered in a field represents a single category of data.

1. Enter a field name and a data type
2. Set the primary key for the table

When you create a table with Table Design, you can be more deliberate about designing your database.

1] Enter a field name and a data type

To build a Table with Table Designer, click the ‘Create’ tab on the ribbon and then select the ‘Table Design’ button under the Tables group.

Access will display a blank Table window in ‘Design’ view.

In the new table, for the first field, enter a field name and a data type.

Read: How to Create, Edit and Delete a Table Relationship in Microsoft Access.

2] Set the primary key for the table

To set the primary key for the table, select the ‘Field Name’ cell for the appropriate field and then select ‘Primary Key’.

The Primary Key indicator appears as a side-arrow button on the left-side of the field name. You can change the primary key at any time however, there’s only one primary key for each table.

When done, go to the ‘File’ tab, click it, select ‘Save’ option and name the table.

You can switch to either ‘Design View’ or ‘Datasheet View’ for any saved table.

The ‘Design View’ lets users create tables in Access by typing the field names into the ‘Field Name’ column. You should ensure that Field names within a table are unique and brief, yet descriptive.

Source – Office Support.com

Related posts

• Helitaanka Gudigga Kontoroolka NVIDIA waa la diiday - ma dabaqi doono dejinta

• Sida loo tuso Higgaada iyo Qalabka Naxwaha ee Toolbar Helitaanka Degdegga ah ee Word

• Sida looga saaro badhanka fududaynta gelitaanka shaashada Logon

• Daar aqoonsiga PIN-yar ee martigeliyayaasha gelitaanka fog ee Chrome

• Waa maxay Gelitaanka Fog ee Trojan? Kahortagga, Ogaanshaha & Ka saarida

• Sida loo sahlo ama loo joojiyo NTFS Wakhtiga Helitaanka Ugu Dambeeya Cusbooneysiinta Shaabada

• Adeegga Macmiilka ee DHCP waxa uu ku siinayaa cilad Helitaanka la diiday Windows 11/10

• TeamViewer: Gelida Fog ee Bilaashka ah iyo Software ka ilaalinta

• Sida loo sameeyo Warbixin iyadoo la isticmaalayo Microsoft Access

• Fix Error 1005 Gelitaanka Fariinta La Diiday markaad booqanayso mareegaha

• MDB Viewer Plus: Arag oo wax ka beddel galka Xogta Xogta ee Microsoft

• La soco cidda akhriday ama beddeshay faylalka Kormeeraha gelitaanka Faylka

• Gelitaanka waa la diiday, ma haysatid ogolaansho aad ku gasho serfarkan

• OutlookTools: Si sahal ah u gal Settings Outlook & Qalab xalinta dhibaatada

• Soo deji Word, Excel, PowerPoint, Access, Visio Templates oo bilaash ah

• Sida loogu daro Maktabadaha gelitaanka degdega ah gudaha Windows 10

• Daaqadaha ma bilaabi karayn Adeegga, Khaladka 0x80070005, Gelitaanka waa la diiday

• Helitaanka degdega ah ma shaqaynayo ama ma yara in lagu furo Windows 11/10

• Fududeynta gelitaanka Settings Keyboard ee Windows 10

• Ka saar cilada la diiday gelitaanka marka la gelayo faylasha ama faylalka Windows