Haddii aad leedahay diiwaanka Xafiiska 365^{(Office 365)} , mid ka mid ah abka aad geli karto waa Helitaanka^(Access) . Waa qalab lagu abuurayo noocyo kala duwan oo xog-ururin ah iyo warbixinnada kombayuutarkaaga. Haddii aad raadinayso hab ku saabsan sida loo dhiso database, MS Access waa habka ugu fiican ee lagu sameeyo haddii aad rabto in aad dhisto database fudud ama adag.

Waxaad isticmaali kartaa qalabka si aad u dhisto xog-ururin, aad u abuurto foomamka gelitaanka xogta, shaandhayso xogtaada adigoo isticmaalaya su'aalo caado ah, oo aad ka soo saarto warbixinnada xogtaada. Waxaa jira saaxirayaal tillaabo-tallaabo ah oo kaa caawinaya inaad abuurto shayadan si aanay aad ugu adkaan in la isticmaalo.

Sida Loo Dhiso Database Banaan Iyadoo Helitaanka MS^{(How To Build a Blank Database With MS Access)}

Waxa ugu horreeya ee aad u baahan tahay inaad samayso waa inaad dhisto xog-ururin. Si tan loo sameeyo, ka billow xog-ururin cusub gudaha Access . Jadwalka xogtaada, foomamka, waydiimahaaga iyo warbixinahaaga ayaa lagu kaydin doonaa dhexdeeda. Si aad taas u sameyso, waxaad isticmaali kartaa mid ka mid ah qaabab badan oo Access ay bixiso ama waxaad ka dhisi kartaa mid xoqan.

Halkan waxaan ku dhisi doonaa xog uruurin kaydisa macluumaadka ardayda waxaanan adeegsan doonaa template database maran.

1. Ku billow app -ka Access^{(Launch the Access app)} kombayutarkaaga .
2. Guji Cusub^(New) ee dhinaca bidix ku yaal si aad u abuurto xog cusub.
3. Dooro ikhtiyaarka xogta^{(Blank database)} madhan ee dhinaca midigta si aad u abuurto xog cusub oo maran.

1. Guji^(Click) astaanta galka yar oo dooro waddo aad ku kaydsato xogtaada Kadib, dhagsii badhanka oranaya Abuur^(Create) .

1. Taasi waa sida aad u dhisto xog-ururin leh Access . Xogta xogtaada waa in laga helaa dariiqa la cayimay.

Ku Samee Shax Gudaha Xogtaada^{(Create a Table In Your Database)}

Saldhig kasta oo xog-ururin ah waa jaantusyo. Waa shaxdan halka xogtaadu ku kaydsan tahay tiirar kala duwan, tanina waa waxa aad ku wadi karto su'aalaha oo aad ka soo saari karto warbixinnada.

Marka aad dhisto xog cusub oo gal^(Access) ah , waxa ay furaysaa shaadhka cusub ee abuurista ee aragtida xaashida xogta. Aragtidani maaha midda ugu fudud ee lagu shaqayn karo sidaas darteed waxaad u baahan tahay inaad u beddesho aragtida naqshadaynta ka dibna aad samayso tiirarka miiskaaga.

1. Midig ku dhufo^{(Right-click)} miiska cusub ee la sameeyay oo dooro Muuqaalka Naqshadda^{(Design View)} .

1. Waxay kugu dhiirigelinaysaa inaad marka hore kaydsato miiskaaga. Geli magaca miiska oo guji OK .

1. Shaashadda soo socota ayaa kuu ogolaanaysa inaad ku darto tiirarka iyo noocyadooda xogta miiska. Tiirka kowaad sida uu yahay ha ahaado sababtoo ah waxay soo saartaa aqoonsi gaar ah mid kasta oo ka mid ah alaabtaada.
2. Sida aan u dhiseyno xogta ardayga, geli cursorkaaga goobta labaad oo ku qor Magaca Ardayga^{(Student Name)} . Ka dooro Qoraal Gaaban^{(Short Text)} goobta Nooca Xogta^{(Data Type)} .

1. Geli da'da^(Age) oo ah magaca goobta soo socda oo ka dooro Nambarka^(Number) liiska hoos u dhaca Nooca Xogta^{(Data Type)} .

1. Ku dar tiirka u dambeeya oo leh magaca Dalka^(Country) iyo Qoraalka Gaaban^{(Short Text)} sida xogta nooca ah.

1. Riix Ctrl + S si aad u badbaadiso miiska.

U samee foom loogu talagalay Gelitaanka Xogtaada^{(Create a Form For Data Entry In Your Database)}

Inta aad miiska ku furi karto aragtida xaashida xogta oo aad ku dari karto xogta loo baahan yahay, foom ayaa ku siin doona hab sahlan oo aad xogtaada geliso. Sidoo kale uma baahnid inaad dhexgasho xogta kale ee miiska ku jirta maadaama foom kaliya kuu ogolaanaya inaad wax ka beddesho hal gelid markiiba.

Waxaad isticmaali kartaa saaxir foomka Access' si aad u abuurto foom aad ku geli karto xogta^{(create a form for data entry)} meelaha aad dooratay.

1. Iyadoo Helitaanka^(Access) uu weli ku furan yahay xogtaada, dhagsii tab ku samee^(Create) dhinaca sare oo dooro ikhtiyaarka sheegaya Form Wizard .

1. Waxay ku weydiin doontaa inaad doorato meelaha aad rabto inaad ku isticmaasho foomkaaga. Dooro dhammaan waxa aad u baahan doonto si aad qiimaha u geliso oo guji summada fallaadha midig si aad ugu darto liiska. Kadibna ku dhufo Next oo dhanka hoose ah.

1. Shaashadda soo socota waxay bixisaa afar qaab oo qaabaysan oo laga dooran karo. Guji^(Click) qaab kasta oo muuqaal ah ayaa ka muuqan doona dhinaca bidix. Markaad dooratid, guji Next oo ku yaal xagga hoose.

1. Geli magac foomkaaga oo ku dhufo dhame^(Finish) .

1. Foomku waa inuu furmo si aad xogta ugu darto miiskaaga.

Ku samee su'aal aad ku shaandhayso xogtaada^{(Create a Query To Filter Data In Your Database)}

Weydiinta ayaa kuu ogolaanaysa inaad shaandhayso xogta ku kaydsan jadwalkaaga adoo isticmaalaya shuruudo kala duwan. Tusaale ahaan, haddii aad raadinayso inaad soo ceshato xogta ardayda 20 sano ama ka weyn ee ku nool Maraykanka, waxaad samayn kartaa su'aal oo waxaad soo saari kartaa miis ay ardaydu ku jiraan oo u dhigma shuruudahaaga.

1. Guji tab ka samee dhinaca sare oo dooro ^(Create)Wizard Weydiinta^{(Query Wizard)} .

1. Dooro ikhtiyaarka ugu horreeya ee leh Wizard Weydiinta fudud^{(Simple Query Wizard)} oo ku dhufo OK .

1. Dooro shaxda iyo goobaha aad rabto inaad ku darto su'aalaha oo guji Next .

1. Dooro ikhtiyaarka Faahfaahinta^(Detail) shaashadda soo socota oo guji Next ee hoose.

1. Geli magac weydiintaada oo ku dhufo dhame^(Finish) xagga hoose.

1. Midig ku dhufo su'aalahaaga cusub oo dooro Muuqaalka Naqshadda^{(Design View)} . Waxaad u isticmaali doontaa aragtidan si aad u geliso shuruudaha weydiintaada.

1. Shaashadda soo socota ayaa kuu ogolaanaysa inaad qeexdo filtarrada weydiintaada. Aynu abuurno sharci muujinaya ardayda 20 jir ah ama ka weyn oo ka yimid Maraykanka.
   
   Ku qor >=20 sanduuqa Shuruudaha^(Criteria) ee goobta Da'da^(Age) .
   
   Geli US safka Shuruudaha^(Criteria) ee goobta dalka^(Country) .

1. Riix Ctrl + S si aad u badbaadiso isbedelada.
2. Labo jeer ku dhufo^{(Double-click)} weydiintaada dhanka bidix waxaadna arki doontaa nooca xogtaada oo la sifeeyay.

Sida Loo Dhiso Warbixinta Xogta Xogta ee Helitaanka^{(How To Build a Database Report In Access)}

Warbixinada waxaa badanaa loo isticmaalaa in xogta laga saaro Helitaanka^(Access) iyo in loo arko faylal gooni ah. Gelitaanku^(Access) wuxuu kuu ogolaanayaa inaad abuurto warbixinno miisaska aad dooratay iyo meelaha aad dooratay oo waxay isticmaashaa qaab saaxir ah oo la mid ah foomamka iyo weydiimaha si ay warbixino u samayso.

1. Guji tab ka samee^(Create) dhinaca sare oo dooro Wizard Report^{(Report Wizard)} .

1. Ku dar meelaha aad rabto inaad ku yeelato warbixintaada oo guji Next .

1. Haddii aad rabto inaad sheegto wax dalabaad kooxeed ah, waxaad taas ku samayn kartaa shaashaddan. Kadibna ku dhufo Next .

1. Haddii aad rabto in aad diiwaankaaga ku hagaajiso meel, taas waxaad ku samayn kartaa shaashaddan. Kadibna ku dhufo Next .

1. Dooro qaabka warbixinta oo ku dhufo Next .

1. Geli magaca warbixinta oo guji dhame^(Finish) .

1. Midig ku dhufo^{(Right-click)} warbixinta oo dooro Daabacaadda Horudhac^{(Print Preview)} .

1. Guji PDF ama XPS^{(PDF or XPS )} xagga sare si aad ugu kaydiso qaababkan midkood.

Xogtaada buuxda oo leh jadwal, foomamka, weydiimaha, iyo warbixinada waa diyaar.

Sideed u dhistaa xog ururintaada^{(build your databases)} ? Haddii aad isticmaasho Access , ma isticmaashaa sifooyinka kor ku xusan? Noogu sheeg faallooyinka hoose.

How To Build a Database With Microsoft Access

If yоu have an Office 365 subscription, one of the apps you can access is Access. It’s a toоl to create vаrious types of databases and reports on your computer. If you’re looking for a method on how to bυild a databаsе, MS Accеss is the best way to do it whether you want to build a simple or a complex databаse.

You can use the tool to build a database, create forms for data entries, filter your data using custom queries, and generate reports out of your data. There are step-by-step wizards to help you create these items so it’s not too difficult to use.

How To Build a Blank Database With MS Access

The first thing you need to do is build a database. To do this, start a new database in Access. Your data tables, forms, queries, and reports will be saved in it. To do it, you can either use one of the many templates that Access provides or build one from scratch.

Here we’ll build a database that stores student information and we’ll be using a blank database template.

1. Launch the Access app on your computer.
2. Click on New in the left sidebar to create a new database.
3. Select the Blank database option on the right-hand side pane to create a new blank database.

1. Click on the little folder icon and choose a path to save your database. Then, click on the button that says Create.

1. That’s how you build a database with Access. Your database should be available at the specified path.

Create a Table In Your Database

The base of any database is tables. It’s these tables where your data is saved in various columns, and this is what you can run queries on and generate reports from.

When you build a new database in Access, it opens the new table creation screen in the datasheet view. This view isn’t the easiest to work with and so you need to change it to the design view and then create your table columns.

1. Right-click on the newly created table and select Design View.

1. It’ll prompt you to save your table first. Enter a name for the table and click on OK.

1. The following screen lets you add columns and their data-types to the table. Keep the first column as-is because it generates a unique ID for each of your items.
2. As we’re building a student database, put your cursor in the second field and type Student Name. Choose Short Text from the Data Type field.

1. Enter Age as the next field name and choose Number from the Data Type dropdown menu.

1. Add the last column with the name Country and Short Text as the data type.

1. Press Ctrl + S to save the table.

Create a Form For Data Entry In Your Database

While you can open the table in datasheet view and add the required data to it, a form will provide you with an easier way to input your data. You’ll also not have to meddle with any other data in the table as a form only lets you edit one entry at a time.

You can use the Access’ form wizard to create a form for data entry with your chosen fields.

1. While Access is still open with your database, click on the Create tab at the top and choose the option that says Form Wizard.

1. It’ll ask you to select the fields you want to use in your form. Select all that you’ll need to enter a value for and click on the right arrow icon to add them to the list. Then click on Next at the bottom.

1. The following screen offers four form layouts to choose from. Click on any layout and a preview will appear on the left side. Once you’ve made a selection, click on Next at the bottom.

1. Enter a name for your form and hit Finish.

1. The form should open letting you add data to your table.

Create a Query To Filter Data In Your Database

A query lets you filter the data saved in your tables using various custom criteria. For example, if you’re looking to retrieve the data of students who’re 20 years or older and live in the US, you can create a query and generate a table that only has the students in it that match your criteria.

1. Click on the Create tab at the top and select Query Wizard.

1. Choose the first option that says Simple Query Wizard and hit OK.

1. Select the table and the fields you want to include in the query and click on Next.

1. Choose the Detail option on the following screen and click on Next at the bottom.

1. Enter a name for your query and hit Finish at the bottom.

1. Right-click on your newly created query and choose Design View. You’ll use this view to enter the criteria for your query.

1. The following screen lets you specify the filters for your query. Let’s create a rule that only shows students who are 20 years or older and are from the US.
   
   Type >=20 in the Criteria box for the Age field.
   
   Enter US in the Criteria row for the Country field.

1. Press Ctrl + S to save the changes.
2. Double-click on your query in the left sidebar and you’ll see the filtered version of your data.

How To Build a Database Report In Access

Reports are usually used to bring data out of Access and to view them as standalone files. Access lets you generate reports for your chosen tables and fields and it uses the same wizard style as forms and queries to make reports.

1. Click on the Create tab at the top and select Report Wizard.

1. Add the fields you’d like to have in your report and click on Next.

1. If you want to specify any grouping orders, you can do that on this screen. Then hit Next.

1. If you want to sort your records by a field, you can do that on this screen. Then click on Next.

1. Select a report layout and hit Next.

1. Enter a name for the report and click on Finish.

1. Right-click on the report and choose Print Preview.

1. Click on PDF or XPS at the top to save it in either of these formats.

Your full database with tables, forms, queries, and reports is ready.

How do you build your databases? If you use Access, do you use the features mentioned above? Let us know in the comments below.

Related posts

• Microsoft Outlook ma furmi doono? 10 siyaabood oo loo hagaajiyo

• Sida loo sameeyo dukumeenti PDF gudaha Microsoft Office

• Sida Loo Muujiyo Tirada Word gudaha Microsoft Word

• Sida looga Dhoofiyo Iimaylkaaga Microsoft Outlook una dhoofin lahayd CSV ama PST

• U samee qoraha OpenOffice muuqaal oo u shaqeeyo si ka badan sida Microsoft Word

• Sida Fonts Cusub loogu daro Microsoft Word

• Sida loo qaado oo loo geliyo Screenshots addoo isticmaalaya OneNote

• Sida loogu daro Liiska Hoos-u-dhaca ee Microsoft Word

• Beddel Cutubyada Cabbirka ee Microsoft Word

• Sida Loo Abuuro Jadwalka Kooxda ee Microsoft 365

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida loo sahlo Mode-madow gudaha Microsoft Outlook (Windows, Mac, iyo Mobile)

• Sida loo Gelida Horizontal Line gudaha Microsoft Word

• Waa maxay Microsoft Publisher? Hagaha bilowga

• Google Slides vs Microsoft PowerPoint - Waa maxay faraqa u dhexeeya?

• 13-ka Hab-gaab ee Kiiboodhka ugu Fiican ee Kooxaha Microsoft

• 5 Shaqooyinka Qoraalka Xaashiyaha Google ee aad u baahan tahay inaad ogaato

• Sida loo Uninstall Kooxaha Microsoft Marka ay sii wado dib u rakibidda

• Sida loo hagaajiyo Bookmark aan lagu qeexin qalad gudaha Word

• Sida loo sameeyo Database a isticmaalaya Microsoft Access