New Data | search
Click here to view New Data news from 60+ newspapers.
Bookmark or Share- Introduction to queries - Microsoft SupportA query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.
- Import database objects into the current Access databaseYou can import tables, queries, forms, reports, macros, or modules from one Access database into your current database. When you import an object, Access creates a copy of the object in the current database.
- Examples of query criteria - Microsoft SupportA query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query.
- Create and run an update query - Microsoft SupportLike the Find and Replace dialog box, an update query lets you specify which value is being replaced, and what the new value is. Unlike the Find and Replace dialog box, an update query lets you: Use criteria that do not depend on the value that you want to replace. Update lots of records in one pass.
- Create a make table query - Microsoft SupportA make table query retrieves data from one or more tables, and then loads the result set into a new table. That new table can reside in the database that you have open, or you can create it in another database. Typically, you create make table queries when you need to copy or archive data.
More
