Question

what is query in ms access? write steps to implement a query?
​

Answer 1

❤❤ HEY MATE HERE IS YOUR ANSWER:-

MS Query gives Excel users ability to access 3rd party databases, text files, and excel workbooks as relational data sources. With text files, you can place them all in one folder to form a database. With excel, you define several named ranges in a single workbook, and then use the ranges as database tables.

Steps to implement a query:

☆ Open your Microsoft Access ❤abase. Double-click the Access document for which you want to create an action query. If you haven't yet created the document, open Microsoft Access, click blank database, enter a name, click create, and enter your database's data before continuing.

☆ Click create. This tab is at the top of the Microsoft Access window. Doing so prompts a toolbar to appear below the create tab.

☆ Click query design. It's in the "Queries" section of the create toolbar. A pop-up window will open.

☆ Select your table. Double-click the table from which you want to display the data. If you have more than one table, double-click the each table that you want to use. ☆ Click close. It's at the bottom of the pop-up window. ☆ Select columns for the action query. Double-click each column from which you want the action query to display data.

• By default, columns are named "Field 1", "Field 2", and so on.

☆ Set the query's criteria. In the section at the bottom of the Access window, change any of the following values for the selected (checked) columns:

• Field - Type in the name of the column here to replace the selected column with a new one. You can also click the drop-down arrow to the right of the column's name to see all available columns in the current table.

• Table - Type in the name of a different table in your database to replace the selected table with a new one. You can also click the drop-down arrow to the right of the table's name to see a list of available tables in the document.

• Sort - Select a sort order.

• Show - Check this box to display a column's information, or uncheck it to hide the information.

• Criteria - Add formulas or information to filter the data displayed by the query. For example you must type the (>"1") to show all column values that are greater than 1.

☆ Click the design tab. It's at the top of the window. Doing so opens a toolbar below the tab.

• You may already be on this tab.

☆ Click run. This exclamation mark-shaped icon is in the "Results" section of the Design toolbar. Clicking run will prompt your query to display any information from your table(s) that matches your established criteria.

HOPE THIS HELPS YOU MATE AND PLEASE MARK ME AS BRAINLY ❤❤