![]() ![]() ![]() For example, if Tailspin Toys goes out of business and the company’s products are no longer available for sale, find all of their products and automatically delete them from the relevant tables. Find information or records and then delete them. For example, if Tailspin Toys has added “TT” to the beginning of the names of all its products, search for all of the company’s products and then update the product names so that each entry begins with “TT”-all through an update query.ĭelete data based on a query. Query for data and then use the results to automatically enter or update information. For example, you might create a query that asks the user for the name of the supplier to search for and then displays all the products acquired from that supplier. Create reusable queries that always ask you for search criteria. For example, you might ask to see all products created by Tailspin Toys.Įnter criteria and search on the fly. Find and view information from one or more tables by specifying criteria that the data must meet and itemizing which values to display. A query might show data from one or more tables, from other queries, or from a combination of the two. ![]() Instead, it displays data that is stored in tables and it makes that data available for you to work with. Or you might combine data from more than one table, such as customer information and order information, to see what a customer has ordered. For example, you might want to just find a contact’s phone number, which requires a simple query of a phone number field for a specific person in a contacts table. In queries, you sometimes use data from just one table and other times from more than one. In Access, queries are like questions that you ask to find related, even very specific, information in your database. Use queries to answer business or other questions based on data and to quickly and easily make bulk updates or to delete information from the database. ![]()
0 Comments
Leave a Reply. |