10-06-2017, 06:43 AM
Create a query in Microsoft Access:
A "query" refers to the action of instructing the database to return some (or all) of the data in your database. In other words, you are "querying" the database for some data that matches a given criteria. For example, you might like to see a list of all individuals whose first name is "Homer". Or you might like to see a list of all users who have registered with your database over a given time period. To do this, you need to do a query.
Here's how to create a query in Microsoft Access:
1. Ensuring you have the "Query" tab open, click "New"
2. Select "Simple Query Wizard" and click "OK":
3. Choose the fields you'd like to be presented in the results of your query. To choose 1 field at a time, select it and click the ">" arrow. To choose all fields click the ">>" arrows. For now, just select the "First Name" and "Last Name" fields, then click "Next":
4. Choose a name for your query and click "Finish":
A "query" refers to the action of instructing the database to return some (or all) of the data in your database. In other words, you are "querying" the database for some data that matches a given criteria. For example, you might like to see a list of all individuals whose first name is "Homer". Or you might like to see a list of all users who have registered with your database over a given time period. To do this, you need to do a query.
Here's how to create a query in Microsoft Access:
1. Ensuring you have the "Query" tab open, click "New"
2. Select "Simple Query Wizard" and click "OK":
3. Choose the fields you'd like to be presented in the results of your query. To choose 1 field at a time, select it and click the ">" arrow. To choose all fields click the ">>" arrows. For now, just select the "First Name" and "Last Name" fields, then click "Next":
4. Choose a name for your query and click "Finish":