Weydiinta^(Query) waa qalab ka soo celiya xogta hal miis ama miisas badan; waa qalabka ugu awooda badan ee lagu falanqeeyo xogtaada gudaha Microsoft Access ; Asal ahaan^(Basically) , Weydiintu^(Query) waa uun su'aal loo soo bandhigay si ay Helitaanka^(Access) u habayn karto ama codsiga xogta.

Abuur oo wax ka beddel su'aalaha gelitaanka

Kooxda weydiimaha^{(Queries Group)} , waxaa jira laba qalab oo abuuri kara weydiintaada^(Query) kuwan:

1. Wizard Wizard^{(The Query Wizard)} : Wuxuu kaa caawinayaa inaad abuurto weydiin fudud

• • Saaxir Weydiinta Fudud^{(Simple Query Wizard)} : Tani waxay ka abuurtaa weydiinta goobaha aad dooratay.
  • Wizard Tab Query^{(Cross Tab Query Wizard)} : Saaxir Tani waxa uu abuuraa Crosstab Weydiinta^{(Crosstab Query)} oo soo bandhigta xogta qaab xisaabeed.
  • Soo hel Wizard Su'aal Nuqul^{(Find Duplicate Query Wizard)} ah : Saaxirkan waxa uu abuuraa weydiimo^(Query) ka helaya xog leh qiimayaal goob nuqul ah oo hal miis ah iyo weydiin^(Query) .
  • Soo hel Wizard Weydiimo Aan Isbarbar^{(Find Unmatched Query Wizard)} -dhigin : Tani waxay abuurtaa weydiimo ka hela diiwaannada ama safafka hal miis oo aan lahayn diiwaan xiriir la leh miis kale.

1. Naqshadaynta^{(The Query Design)} Weydiinta: Ku samee su'aal cusub oo madhan Aragtida Naqshadda^{(Design View)} . Waxaad isticmaali kartaa sanduuqa wada hadalka miiska miiska^{(Show Table)} si aad ugu darto weydiimaha iyo miisaska Nakhshadda Weydiinta^{(Query Design)} .

Waa maxay faa'iidooyinka^(Advantages) isticmaalka weydiinta?

Gudaha Microsoft Access , Weydiintu waxay ka jawaabi kartaa su'aal fudud, isku darka xogta miisaska kala duwan, samaynta xisaabinta, ku dar, beddelo, oo tirtirto xogta kaydka. Maqaalkan, waxaan ku sharxi doonaa sida loo:

1. Sida Loo Abuuro Weydiinta^(Query) Weydiinta Wizard^{(Wizard Query)} .
2. Sida Su'aal loogu Abuuro Nakhshad ^(Query)Wayneedka^{(Query Design)}
3. Ku darida xogta^(Data) si loo Nakhshadeeyo Shabakadda^{(Design Grid)} Daaqadda Weydiinta Nakhshadeynta^{(Design Query Window)}
4. Sida loo tirtiro weydiimaha

1] Sida^(How) Su'aal loogu Abuuro Weydiinta ^(Query)Wizard^{(Wizard Query)}

Guji tab Abuur ^{(Create Tab)}Kooxda weydiimaha^{(Queries Group)} , waxaad dooran kartaa Wizard ama Naqshad waydiinta^{(Query Design)} . Marka hore^(First) , waxaanu ku sharixi doonaa sida loo abuuro Weydiinta Wizard ^{(Wizard Query)}Query .

Guji Wizard Query , kadibna dooro Wizard fudud^{(Simple Query Wizard)} , kaas oo kuu ogolaanaya inaad samayso su'aal^(Query) fudud , Guji ^(Click) OK . Dooro miiska iyo goobaha aad rabto inaad geliso Weydiintaada; Dhagsii Xiga^(Next) .

Waxaad arki doontaa laba ikhtiyaar oo aad ku furi karto weydiintaada^(Query) ; waxaad dooran kartaa inaad furto su'aalaha^(Query) si aad u aragto macluumaadka, taas oo abuurta waydiinta^(Query) isla markiiba ama dooro inaad wax ka beddesho weydiinta. Kadib dhame^(Finish) . Su'aal ayaa la sameynayaa

2] Sida^(How) Su'aal loogu Abuuro Naqshad ^{(Query Design)}Wayneed^(Query)

Si aad u isticmaasho Nakhshad waydiinta^{(Query Design)} . Guji Naqshad Weydiinta^{(Click Query Design)} . Daaqadda Naqshadeynta Weydiinta^{(Query Design)} , waxaa jira sanduuqa wada-hadalka miiska^{(Show Table)} , oo leh qaybo ay ka mid yihiin Shaxannada^(Tables) , Xiriirinta^(Links) , Weydiimaha^(Queries) , ama Dhammaan^(All) .

Maqaalkan, waxaan ku dhejineynaa qaybta miiska^(Table) oo aan doorano miis aan rabno inaan ku isticmaalno weydiinta^(Query) . Guji ^(Click) Ku dar Shaxda la doortay^{(Add Selected Table )} ama laba jeer guji. Jadwalka ayaa ku dari doona daaqada weydiinta ; ^(Query)miisaska waa in la isku xiraa (eeg maqaal ku saabsan xiriirka).

3] Kudar Xogta^{(Add Data)} Nakhshadeynta Grid^{(Design Grid)} daaqada Weydiinta Nakhshadeynta^{(Design Query)}

Naqshadeynta Grid^{(Design Grid)} waxay ku taal muraayadda hoose ee daaqada waxayna qeexaysaa meelaha Weydiinta^(Query) iyo shuruudaha. Naqshaduhu^{(Design Grid)} wuxuu ka kooban yahay Goobo^(Fields) , Miiska^(Table) , Kala soocida^(Sort) , Shuruudaha^(Criteria) , iyo ama^(or) .

Si aad xogta ugu darto Shabakadda Nakhshadda^{(Design Grid)} , laba jeer ku dhufo Goobaha^(Fields) miiska aad dooratay ee aad rabto inaad ku darto Weydiinta^(Query) . Waxaad ku arki doontaa xogta Shabakadda Naqshadeynta^{(Design Grid)} . Xulashada kale waa inaad aado Shabakadda Naqshadeynta^{(Design Grid)} , guji safka Goobta^(Field) ; Waxaad arki doontaa liiska hoos-u-dhaca ah, dooro beerahaaga.

Hoosta safka garoonku waa safka miiska^(Table) . Dooro miiska aad rabto. Waxaad u kala sooci kartaa xogtaada safka kala soocida^{(Sort )} .

Safka shuruuduhu^(Criteria) waa in aad ka raadiso waxa aad ka raadinayso miiskaaga ama su'aalahaaga^(Query) . Tusaale ahaan, waxaad raadineysaa arday haysta Shahaadada Maamulka Xisaabaadka^(Accounts) iyo Ganacsiga^{(Business Administration Degree)} . Nooca kowaad ee ^(First)Xisaabaadka^(Accounts) safka Shuruudaha^(Criteria) ee hoos yimaad Degree iyo Maamulka Ganacsiga^{(Business Administration)} ee safka ka hooseeya Xisaabaadka^(Accounts) . Guji orod^(Run) .

Weydiinta ayaa la abuuray Guji amarka Badbaadinta^(Save) ee ku yaal bar-barka galka degdega ah, u magacow su'aalahaaga^(Query) , ka dibna dhagsii OK .

4] Si aad u tirtirto weydiinta^(Query) . Ka hel su'aalaha^(Query) ku yaal Pane Navigation^{(Navigation Pane)} . Dooro Weydiinta^(Query) , midig-guji, kadibna Delete . Weydiinta^(Query) waa laga saarayaa sanduuqa hagidda^{(Navigation Pane)} .

Akhri soo socda^{(Read next)} : Sida foom loogu abuuro Microsoft Access .

How to Create and Modify Query in Microsoft Access

A Query is a tool that retrieves data from a single table or multiple tables; it is the most powerful tool to analyze your data in Microsoft Access; Basically, a Query is just a question presented in a way that Access can process or a request for data.

Create and Modify Query in Access

In the Queries Group, there two tools that can create your Query these are:

1. The Query Wizard: Helps you to create a simple Query

• • Simple Query Wizard: This creates Query from the fields you pick.
  • Cross Tab Query Wizard: This wizard creates a Crosstab Query that displays data in a spreadsheet format.
  • Find Duplicate Query Wizard: This wizard creates a Query that finds data with duplicate field values in a single table and Query.
  • Find Unmatched Query Wizard: This creates a Query that finds records or rows in one table with no related records in another table.

1. The Query Design: Create a new blank query in Design View. You can use the Show Table dialog box to add queries and tables to the Query Design.

What are the Advantages of using a Query?

In Microsoft Access, a Query can answer a simple question, merge data from different tables, perform calculations, add, change, and delete data from the database. In this article, we are going to explain how to:

1. How to Create a Query in Wizard Query.
2. How to Create a Query in Query Design
3. Adding Data to Design Grid in the Design Query Window
4. How to delete a Query

1] How to Create a Query in Wizard Query

Click the Create Tab. On the Queries Group, you can either select Wizard or Query Design. First, we are going to explain how to create Query in Wizard Query.

Click Wizard Query, then select Simple Query Wizard, which lets you create a simple Query, Click OK.  Choose the table and fields you want to put into your Query; click Next.

You will see two options for opening your Query; you can choose to open the Query to view information, which creates the Query immediately or choose to modify the query. Then Finish. A Query is being made.

2] How to Create a Query in Query Design

To use Query Design. Click Query Design. In the Query Design window, there is a Show Table dialog box, with categories such as Tables, Links, Queries, or All.

In this article, we are sticking to the Table category and choose a table we want to use in the Query. Click Add Selected Table or double click. The table will add to the Query window; the tables must be connected (see article about relationships).

3] Add Data to Design Grid in the Design Query window

The Design Grid is located at the lower pane of the window and specifies the Query fields and criteria. Design Grid consists of Fields, Table, Sort, Criteria, and or.

To add data to the Design Grid, Double click on the Fields from your selected table you want to include in the Query. You will see the data in the Design Grid. The other option is to go to the Design Grid, click in the Field row; you will see a drop-down menu, choose your fields.

Below the field row is the Table row. Select your desired table. You can sort your data in the Sort row.

The Criteria row is to search for what you are looking for from your Table or Query. For instance, you are looking for students that have an Accounts and Business Administration Degree. First type Accounts in the Criteria row under the field Degree and Business Administration in the or row below the Accounts. Click Run.

A Query is created. Click the Save command on the quick access toolbar, name your Query, and then click OK.

4] To delete a Query. Locate the Query on the Navigation Pane. Select the Query, right-click, then Delete. The Query will be removed from the Navigation Pane.

Read next: How to Create a Form in Microsoft Access.

Related posts

• Sida loo sameeyo Warbixin iyadoo la isticmaalayo Microsoft Access

• Sida loo sameeyo Database a isticmaalaya Microsoft Access

• Sida Loo Dhiso Database Iyadoo Microsoft Access

• Gal oo isticmaal Microsoft Edge oo ku saabsan bogga calanka ee Windows 11/10

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

• Samee Jidka Gaaban ee Kiiboodhka si aad si badbaado leh u gasho Ka saar Wadahadalka Hardware

• Ku samee liisaska hubinta sanduuqyada calaamadaynta, iyo sida loo tafatiro, gudaha Microsoft Word

• NeoRouter waa gelitaanka fog ee qaabaynta eber & xalka VPN

• Sida loo kabsado oo loo soo celiyo faylalka gelitaanka degdega ah gudaha Windows 11/10

• Sida loo bilaabo Microsoft Edge gudaha Windows 10 (hababka 12)

• HELIDDA LA DIIDAY - Waftiga xaddidan ee CIFS wuu guuldarraystay

• PowerShell Get-Appxpackage Aan shaqayn ama Galitaanka waa la diiday

• Hagaaji Gelitaanka Kontroolka Helitaanka waa qalad kharriban gudaha Windows 10

• Ku samee foomamka la buuxin karo Microsoft Word

• Abuur sharciyada iimaylka si aad uga hortagto Ransomware gudaha Microsoft 365 Business

• Sida Loo Abuuro Oo Loo Badbaadiyo Xaashiyaha Faafinta Excel ee Microsoft Office ee Android

• U samee ama u abuur furaha-gaaban ee kiiboodhka ee Microsoft Office

• Sida loo habeeyo aaladda Helitaanka Degdegga ah ee barnaamijyada Xafiiska

• Ka gal galka iyo faylasha aad jeceshahay liiska macnaha guud ee ConFavor

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